SELECT fu.user_name, frt.responsibility_name
FROM fnd_user fu
,fnd_user_resp_groups furg
,fnd_responsibility_tl frt
WHERE fu.user_name = '<<USER NAME>>'
AND fu.user_id = furg.user_id
AND furg.responsibility_id = frt.responsibility_id
AND frt.language =USERENV('LANG')
ORDER BY frt.responsibility_name
FROM fnd_user fu
,fnd_user_resp_groups furg
,fnd_responsibility_tl frt
WHERE fu.user_name = '<<USER NAME>>'
AND fu.user_id = furg.user_id
AND furg.responsibility_id = frt.responsibility_id
AND frt.language =USERENV('LANG')
ORDER BY frt.responsibility_name
No comments:
Post a Comment