select fu.user_name 用户名,
fu.description 描述,
(select
ppf.FULL_NAME
from
per_people_f ppf
where
ppf.PERSON_ID =
fu.employee_id
and trunc(sysdate) between trunc(ppf.EFFECTIVE_START_DATE)
and
trunc(ppf.EFFECTIVE_END_DATE)) 人员姓名
from fnd_user fu
--where
fu.description like ‘%制造%‘