Oracle EBS-SQL (SYS-3):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 '%制造%'