select c.user_name 登录名,
nvl(c.employee_id, 0) 雇员ID,
b.RESPONSIBILITY_NAME 职责名称,
c.start_date 用户有效开始日期,
c.end_date 用户有效结束日期,
a.START_DATE 职责有效开始日期,
a.END_DATE 职责有效结束日期,
d.full_name 员工姓名,
e.ASSIGNMENT_NUMBER 员工编号,
f.name 部门名称
from apps.FND_USER_RESP_GROUPS_DIRECT a,
apps.FND_RESPONSIBILITY_VL b,
apps.fnd_user c,
apps.hr_employees d,
apps.per_assignments_f e,
apps.hr_all_organization_units_tl f
where a.user_id = c.user_id
and a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
and c.employee_id(+) = d.employee_id
and c.employee_id = e.PERSON_ID
and e.ORGANIZATION_ID(+) = f.organization_id
and f.language = 'ZHS'
and sysdate between c.start_date and nvl(c.end_date, sysdate)
and sysdate between a.start_date and nvl(a.end_date, sysdate)
and sysdate between e.EFFECTIVE_START_DATE and
nvl(e.EFFECTIVE_END_DATE, sysdate)
and nvl(c.employee_id, 0) <> 0
怎么查看系统里所有用户对应拥有的权限?
最新推荐文章于 2024-10-02 10:38:28 发布