How to Find the Request Group Associated with a Program.
SELECT rg.application_id
“Request Group Application ID”,
rg.request_group_id
“Request Group – Group ID”,
rg.request_group_name,
rg.description,
rgu.unit_application_id,
rgu.request_group_id
“Request Group Unit – Group ID”,
rgu.request_unit_id,
cp.concurrent_program_id,
cp.concurrent_program_name,
cpt.user_concurrent_program_name,
Decode(rgu.request_unit_type, ‘P’, ‘Program’,
‘S’, ‘Set’, rgu.request_unit_type) “Unit Type”
FROM fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt
WHERE rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND cpt.user_concurrent_program_name = ‘Program Name’;
Read More Articles
Query To Verify Workflow IMAP Setting
Query To Find Complete Database Size
Query To Find Find EBS Profile Options For All Values
Query To Find Number Of Users Connected To EBS
Query To Find Who Is Connected When to Which Responsibilities
Query For Workflow Mailer Configurations
Query To Find All Responsibilities Assigned To a User
Query To Find All Users Assigned To Given Responsibility
Query To Find All Reports Registered Within Given Application
Query To Find Responsibility Name from a Concurrent Program
Query Count the number of reports registered In Each Module
Query To Find Scheduled Concurrent Request
Query To Find All Reports Status With User Name
Query To Count Pending Request
Query To find Concurrent Program Name, Phase Code And Status Code for a given Request ID
Query To Find a Concurrent Program Enabled with Trace
Query To Find Request Submitted By User
Query To Find Pending Request in Oracle Apps dba
Query To Find the Reports Finished With Error Code In Oracle Apps DBA