EBS 超找用户所具有的职责
SELECT fu.user_name 用户名,
frt.RESPONSIBILITY_NAME 职责名,
fu.user_id 用户号,
furg.responsibility_id 职责号
FROM fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_id = furg.user_id
and furg.RESPONSIBILITY_ID=fr.responsibility_id
and fr.responsibility_id= frt.responsibility_id
and fu.user_name like 'ZMSUP013' ;