To analyze concurrent programs placement in request groups becomes necessary task sometimes. Here is the query to find concurrent programs attached to request group. You will also get information about concurrent program application with this query.
Query To Find Concurrent Programs Attached To Request Group
SELECT frv.responsibility_name "Responsibility", frg.request_group_name "Request Group Name", fa1.application_name "Application Name", frg.description "Description", DECODE(frgu.request_unit_type, 'P', 'Program', 'S', 'Set', 'A', 'Application', frgu.request_unit_type) "Request Type", DECODE(frgu.request_unit_type, 'P', fcpt.user_concurrent_program_name, 'S', frst.user_request_set_name, 'A', fa3.application_name, frgu.request_unit_type) "Request Name", fa2.application_name "Request Application" FROM apps.fnd_responsibility_vl frv, fnd_request_groups frg, fnd_request_group_units frgu, fnd_concurrent_programs_tl fcpt, fnd_request_sets_tl frst, fnd_application_tl fa1, fnd_application_tl fa2, fnd_application_tl fa3 WHERE 1 = 1 AND frg.request_group_id = frgu.request_group_id AND frv.request_group_id = frg.request_group_id AND frgu.request_unit_id = fcpt.concurrent_program_id(+) AND fcpt.LANGUAGE(+) = USERENV('LANG') AND frg.application_id = fa1.application_id AND fa1.LANGUAGE(+) = USERENV('LANG') AND frgu.unit_application_id = fa2.application_id AND fa2.LANGUAGE(+) = USERENV('LANG') AND frgu.unit_application_id = fcpt.application_id(+) AND frgu.request_unit_id = frst.request_set_id(+) AND frst.LANGUAGE(+) = USERENV('LANG') AND frgu.request_unit_id = fa3.application_id(+) AND fa3.LANGUAGE(+) = USERENV('LANG') AND frgu.unit_application_id = frst.application_id(+) AND UPPER(fa1.application_name) = UPPER('&Application_Name') AND UPPER(frg.request_group_name) = UPPER('&Request_Group_Name') AND frgu.request_unit_type = 'P' -- P stands for programs ORDER BY request_group_name, frgu.request_unit_type, frgu.request_unit_id;
Comment Request group condition to get data of all request groups in that application
AND UPPER(frg.request_group_name) = UPPER('&Request_Group_Name')
Comment Request unit type condition to get request application and request type of objects attached to that request group
AND frgu.request_unit_type = 'P' -- P stands for programs
Put a comment on application name condition to get list of all request groups attached to all applications
AND UPPER(fa1.application_name) = UPPER('&Application_Name')
Hope you like the article and find it useful. We highly appreciate comments and feedback.
Hi I am Paras.
Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at firstname.lastname@example.org. Again I appreciate your visit. Hope to see you again and again!