Query to find out Responsibilities assigned to a user

* Formatted on 2016/08/26 16:14 (Formatter Plus v4.8.8) */

SELECT fu.user_name "User Name",

       frt.responsibility_name "Responsibility Name",

       furg.start_date "Start Date", furg.end_date "End Date",

       fr.responsibility_key "Responsibility Key",

       fa.application_short_name "Application Short Name"

  FROM fnd_user_resp_groups_direct furg,

       applsys.fnd_user fu,

       applsys.fnd_responsibility_tl frt,

       applsys.fnd_responsibility fr,

       applsys.fnd_application_tl fat,

       applsys.fnd_application fa

WHERE furg.user_id = fu.user_id

   AND furg.responsibility_id = frt.responsibility_id

   AND fr.responsibility_id = frt.responsibility_id

   AND fa.application_id = fat.application_id

   AND fr.application_id = fat.application_id

   AND frt.LANGUAGE = USERENV ('LANG')

   AND UPPER (fu.user_name) =

          UPPER

             ('MUNGI500')  ---- Provide user id