Wednesday, 24 August 2011

SQL Query to list out Responsibilities assigned to a Request Group

 *PURPOSE: To list out Responsibilities assigned to a Request Group*
 *PARAMETERS: Responsibility Name (or) Request Group Name          *
SELECT frg.request_group_id,
       frg.request_group_name ,
       frg.request_group_code ,
       fr.responsibility_key ,
FROM fnd_responsibility fr,
  fnd_request_groups frg,
  fnd_responsibility_tl frt
  --and frt.responsibility_name like 'General Ledger Super User'
  --and frg.request_group_name = 'All Inclusive GUI'
AND frg.application_id    = fr.application_id
AND frt.responsibility_id = fr.responsibility_id
AND frt.LANGUAGE          = 'US';

1 comment:

  1. This post is very informative for everybody. I would like to appreciate your work for good accuracy and got informative knowledge from here. Thank you very much for posting this blog it’s very nice.

    Oracle Fusion HCM Technical Online Training