Query to find Request Group for concurrent program

Following query finds the associated request group and the application module name (Payables, Receivables, etc.) for a concurrent program.

In this example, I used "Active Users" as concurrent program name. With a little modification to the query, you should be able to find concurrent request set name also.

-------------------------------------------------------------------------------

-- Query to find request group and application name for a concurrent program

-------------------------------------------------------------------------------

SELECT fcp.user_concurrent_program_name    "Concurrent Program Name",

       fcp.concurrent_program_name         "Concurrent Program Short Name",

       fr.responsibility_name              "Responsibility Name",

       frg.request_group_name              "Request Group Name",

       luv.meaning                         "Request Unit Type",

       fa.application_name                 "Application Name",

       fa.application_short_name           "Application Short Name",

       fa.basepath                         "Basepath"

  FROM FND_CONCURRENT_PROGRAMS_VL  fcp,

       FND_RESPONSIBILITY_VL       fr,

       FND_REQUEST_GROUPS          frg,

       FND_REQUEST_GROUP_UNITS     frgu,

       (SELECT lookup_code, meaning

          FROM FND_LOOKUP_VALUES

         WHERE UPPER (lookup_type) = 'SRS_REQUEST_UNIT_TYPES') luv,

       FND_APPLICATION_VL          fa

 WHERE frg.request_group_id = fr.request_group_id

   AND frgu.request_group_id = frg.request_group_id

   AND fcp.concurrent_program_id = frgu.request_unit_id

   AND frgu.request_unit_type = luv.lookup_code

   AND frg.application_id = fa.application_id

   AND fcp.user_concurrent_program_name = 'Active Users'

 ORDER BY fcp.user_concurrent_program_name, 

       fr.responsibility_name, 

       frg.request_group_name;