RAFIUDDIN

Pages

Tuesday, October 7, 2014

DBA: SQL Query to get application users of a a responsibility

--Kindly change the highlighted in Yellow to your responsibility name

SELECT fu.user_name "User Name", fr.responsibility_name "Responsibility",
       fa.application_name "Application", fur.start_date "From",

       fur.end_date "To", fm.user_menu_name "Menu",
       frg.request_group_name "Request Group"
  FROM fnd_user fu,
       fnd_user_resp_groups_all fur,
       fnd_responsibility_vl fr,
       fnd_application_vl fa,
       fnd_menus_vl fm,
       fnd_request_groups frg
 WHERE fu.user_id = fur.user_id
   AND fur.responsibility_id = fr.responsibility_id
   AND fr.application_id = fa.application_id
   AND fr.menu_id = fm.menu_id
   AND fr.request_group_id = frg.request_group_id(+)
   AND UPPER (fr.responsibility_name) = UPPER ('Application Developer')