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 '%制造%'

转载于:https://www.cnblogs.com/st-sun/p/3777988.html