Oracle EBS-SQL (SYS-21):sys_用户名与人员对应关系查询.sql
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 '%制造%'