SQL query to find concurrent program attached to request group

SQL query to find concurrent program attached to request group

In this post , We will be able to able discuss about sql query to find concurrent program attached to request group. This sql query will help to extract the complete details of request group to which the given concurrent program attached. We can find out the complete list of request group to which any given concurrent program has attached. This is one of the useful sql query to extract concurrent program request group details. Here below is the complete detail about SQL query to find concurrent program attached to request group.

SQL query to find concurrent program attached to request group

6 Important Table Used by SQL query to find concurrent program attached to request group

1.fnd_request_groups

2.fnd_request_group_units

3.fnd_concurrent_programs 

4.fnd_concurrent_programs_tl

5.fnd_application

6.fnd_application_tl 

Detail SQL query to find concurrent program attached to request group

SELECT con_prog.user_concurrent_program_name,

       DECODE(rgu.request_unit_type,

              'P', 'Program',

              'S', 'Set',

              rgu.request_unit_type)        "Type",

       cp.concurrent_program_name           "Concurrent Program Short Name",

       rg.request_group_name   ,

       appl_fat.application_name                 "Application Name"

  FROM fnd_request_groups          rg,

       fnd_request_group_units     rgu,

       fnd_concurrent_programs     cp,

       fnd_concurrent_programs_tl  con_prog,

       fnd_application             appl_fa,

       fnd_application_tl          appl_fat

 WHERE rg.request_group_id       =  rgu.request_group_id

   AND rgu.request_unit_id       =  cp.concurrent_program_id

   AND cp.concurrent_program_id  =  con_prog.concurrent_program_id

   AND rg.application_id         =  appl_fat.application_id

   AND appl_fa.application_id         =  appl_fat.application_id

   AND con_prog.user_concurrent_program_name = 'XX Program Name';

SQL query to find concurrent program attached to request group