Oracle EBS-SQL (SYS-3):sys_人员用户名对应关系查询.sql
时间：2022-03-10 17:32
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 ‘%制造%‘
Oracle EBS-SQL (SYS-3):sys_人员用户名对应关系查询.sql,布布扣,bubuko.com
