Query To Find Responsibility Name from a Concurrent Program
SELECT DISTINCT FCPL.user_concurrent_program_name,
FCP.concurrent_program_name,
FAPP.application_name,
FRG.request_group_name,
FNRTL.responsibility_name
FROM apps.fnd_request_groups FRG,
apps.fnd_application_tl FAPP,
apps.fnd_request_group_units FRGU,
apps.fnd_concurrent_programs FCP,
apps.fnd_concurrent_programs_tl FCPL,
apps.fnd_responsibility FNR,
apps.fnd_responsibility_tl FNRTL
WHERE FRG.application_id=fapp.application_id
AND FRG.application_id=FRGU.application_id
AND FRG.request_group_id=FRGU.request_group_id
AND FRG.request_group_id=FNR.request_group_id
AND FRG.application_id=FNR.application_id
AND FNR.responsibility_id=FNRTL.responsibility_id
AND FRGU.request_unit_id=FCP.concurrent_program_id
AND FRGU.unit_application_id=FCP.application_id
AND FCP.concurrent_program_id=FCPL.concurrent_program_id
AND FCPL.user_concurrent_program_name LIKE ‘%&Conc_Prog_name%’
AND FNRTL.LANGUAGE=’US’
AND FAPP.LANGUAGE=’US’;
Read More:
Query Count the number of reports registered In Each Module
Query To Find Scheduled Concurrent Request
Query To Check Scheduled Concurrent Requests
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
Terminating Report From Backend