EBS 职责关联用户 SQL

SELECT s.user_name 用户名,
p.full_name 人员,
v.RESPONSIBILITY_NAME 职责名,
u.END_DATE 用户失效日期
FROM apps.fnd_user_resp_groups_all u,
apps.fnd_responsibility_vl v,
apps.fnd_user s,
apps.per_all_people_f p,
apps.per_all_assignments_f a,
apps.hr_all_organization_units h
WHERE v.RESPONSIBILITY_ID(+) = u.RESPONSIBILITY_ID
AND s.user_id = u.user_id(+)
and s.employee_id = p.person_id(+)
–AND s.end_date IS NULL
–AND u.END_DATE IS NULL
–and p.effective_end_date > SYSDATE
–AND SYSDATE BETWEEN a.effective_start_date AND a.effective_end_date
–and s.user_name = ‘SYSADMIN’
AND p.person_id = a.person_id(+)
AND a.organization_id = h.organization_id(+)
ORDER BY 1