Total Pageviews

Thursday, January 19, 2012

List Responsibilities and Responsibility Keys that are assigned to a user

SELECT r.responsibility_key,a.application_name, fa.APPLICATION_SHORT_NAME
    FROM fnd_user u,
         fnd_user_resp_groups ur,
         fnd_responsibility r,
         fnd_application_tl a,
         fnd_application fa
   WHERE  ur.responsibility_id = r.responsibility_id
         AND u.user_id = ur.user_id
         AND fa.APPLICATION_ID = a.APPLICATION_ID
         AND r.application_id = a.application_id
         AND upper(u.user_name) = UPPER ('ORACLE')
         AND a.language = 'US'
ORDER BY 1