Query to get request group for responsibility

Query to get request group for responsibility

In this post , We will be discuss about Query to get request group for responsibility.  This sql query will help to extract the request group details for a responsibility in oracle apps. We can find out the responsibility, request group informations using this sql query. This is one of the useful sql query to get the request group details. Here below is the complete detail about Query to get request group for responsibility.

Query to get request group for responsibility

6 Important Table used by Query to get request group for responsibility

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'

Query to get request group for responsibility