Query To Get All Concurrent Programs Attached To Request Group In Oracle Apps

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.

Check out all useful queries are here

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')

Official Oracle Support Page

Hope you like the article and find it useful. We highly appreciate comments and feedback.

You can also Subscribe here to stay updated on latest posts of Oraclemine.com.

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 hioraclemine@gmail.com. Again I appreciate your visit. Hope to see you again and again!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.