/******************************************************************* *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';
Wednesday, 24 August 2011
SQL Query to list out Responsibilities assigned to a Request Group
Subscribe to:
Post Comments (Atom)
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.
ReplyDeleteOracle Fusion HCM Technical Online Training
ReplyDeleteIam 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.