How to List Reponsibilities for an User in Oracle Applications 11i

You can use following SQL Statments to list responsibities assigned to all users or to a particuler user instead of going to System Administrator Screen.


For All Users

SELECT UNIQUE fu.user_id "User ID",
fu.user_name "User Name",
frt.responsibility_name "Responsibility Name",
frv.description "Responsibility Detail",
fat.application_name "Application Name"
FROM fnd_user fu,
fnd_user_resp_groups furg,
fnd_application_tl fat,
fnd_responsibility_tl frt,
fnd_responsibility_vl frv
WHERE furg.user_id(+) = fu.user_id
AND furg.responsibility_application_id = fat.application_id
AND fat.application_id = frt.application_id
AND furg.responsibility_id = frt.responsibility_id
AND furg.responsibility_application_id = frv.application_id
AND furg.responsibility_id = frv.responsibility_id
ORDER BY fu.user_name,
fat.application_name,
frt.responsibility_name


For particuler User
 SELECT UNIQUE fu.user_id "User ID",
fu.user_name "User Name",
frt.responsibility_name "Responsibility Name",
frv.description "Responsibility Detail",
fat.application_name "Application Name"
FROM fnd_user fu,
fnd_user_resp_groups furg,
fnd_application_tl fat,
fnd_responsibility_tl frt,
fnd_responsibility_vl frv
WHERE furg.user_id(+) = fu.user_id
AND furg.responsibility_application_id = fat.application_id
AND fat.application_id = frt.application_id
AND furg.responsibility_id = frt.responsibility_id
AND furg.responsibility_application_id = frv.application_id
AND furg.responsibility_id = frv.responsibility_id
And fu.USER_NAME = &Username