EBS后台查询人员职责信息

由于EBS查询人员的职责可以界面路径：

系统管理员--安全性--用户

查询一个用户可以，但是想通过职责查询人员不方便：

FND_USER --账号表

FND_RESPONSIBILITY_VL --职责表

per_people_f --人员表

根据上述表查询相关权限和人员信息关联：

SELECT USER_NAME,

FULL_NAME,

RESPONSIBILITY_NAME --, CC.DESCRIPTION,

cc.START_DATE,

cc.END_DATE

FROM FND_USER AA,

FND_USER_RESP_GROUPS BB,

FND_RESPONSIBILITY_VL CC,

per_people_f DD,

fnd_flex_values_vl ffvv,

fnd_flex_value_sets ffvs

WHERE AA.USER_ID = BB.USER_ID

AND BB.RESPONSIBILITY_ID = CC.RESPONSIBILITY_ID

AND AA.EMPLOYEE_ID = DD.PERSON_ID

--and AA.USER_NAME = '100195'

AND ffvv.flex_value_set_id = ffvs.flex_value_set_id

AND ffvs.flex_value_set_name = 'ZZM_DEPARTMENT'

and ffvv.description like '%财务%'

ORDER BY USER_NAME;