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 ,
       frt.responsibility_name
FROM fnd_responsibility fr,
  fnd_request_groups frg,
  fnd_responsibility_tl frt
WHERE 1=1
  --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';

2 comments:

  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

    ReplyDelete

  2. Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle Fusion HCM Techno Functional.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topic Oracle PPM Cloud.Thank you soo much.

    ReplyDelete