1-) Query to get the executable details for the concurrent program or package
Introduction: This query is used to fetch the user concurrent program name, concurrent program name, executable id and also the executable name. In this we can pass either the user concurrent program name (or) executable file name so that fetching of data takes place based on the parameter passed to the query..
SQL Query:
SELECT fcp.user_concurrent_program_name,
fcp.concurrent_program_name,
fe.executable_id,
fe.execution_file_name
FROM fnd_concurrent_programs_vl fcp ,
fnd_executables fe
WHERE 1 = 1
AND fcp.executable_id = fe.executable_id
AND fcp.user_concurrent_program_name LIKE ‘%<CP_NAME>%’
AND fe.execution_file_name like ‘%<PACKAGE_NAME> %’ ;
Parameter:
- Concurrent Program Name
- Package Name
2-)Query to get the Concurrent Program’s and their Request Groups
Introduction: This query is used to fetch the request group name (responsibility name), application name and also the application id, request unit id and the request group id. In this we will be passing user concurrent program name as the parameter so that all the request groups, application name, etc. attached to that specific user concurrent program gets displayed.
SQL Query:
SELECT frg.request_group_name,
fcp.user_concurrent_program_name,
fa.application_name,
frgu.unit_application_id,
frgu.request_unit_id,
frg.application_id,
frg.request_group_id
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_application_tl fa,
fnd_concurrent_programs_tl fcp
WHERE frg.request_group_id = frgu.request_group_id
AND frgu.unit_application_id = fa.application_id
AND frgu.request_unit_id = fcp.concurrent_program_id
AND fcp.user_concurrent_program_name LIKE ‘:CP_NAME’
ORDER BY fcp.user_concurrent_program_name;
Parameter: User Concurrent Program Name