Thursday 3 September 2015

How to find the responsibility name and key in Oracle apps:

SELECT unique r.responsibility_key,responsibility_name,
fa.application_short_name
FROM apps.fnd_user u,
apps.fnd_user_resp_groups ur,
apps.fnd_responsibility r,
apps.fnd_application_tl a,
apps.fnd_application fa,
apps.fnd_responsibility_tl tl
WHERE 1=1
AND ur.responsibility_id = r.responsibility_id
AND ur.responsibility_id = tl.responsibility_id
AND u.user_id = ur.user_id
AND fa.application_id = a.application_id
AND r.application_id = a.application_id
AND u.user_name = UPPER(:user_name)
and tl.language ='US'
ORDER BY 1