Query to find Oracle Concurrent Program Request groups Assignment:

SELECT cpt.user_concurrent_program_name     "Concurrent Program Name",

       DECODE(rgu.request_unit_type,

              'P', 'Program',

              'S', 'Set',

              rgu.request_unit_type)        "Unit Type",

       cp.concurrent_program_name           "Concurrent Program Short Name",

       rg.application_id                    "Application ID",

       rg.request_group_name                "Request Group Name",

       fat.application_name                 "Application Name",

       fa.application_short_name            "Application Short Name",

       fa.basepath                          "Basepath"

  FROM apps.fnd_request_groups          rg,

       apps.fnd_request_group_units     rgu,

       apps.fnd_concurrent_programs     cp,

       apps.fnd_concurrent_programs_tl  cpt,

       apps.fnd_application             fa,

       apps.fnd_application_tl          fat

 WHERE rg.request_group_id       =  rgu.request_group_id

   AND rgu.request_unit_id       =  cp.concurrent_program_id

   AND cp.concurrent_program_id  =  cpt.concurrent_program_id

   AND rg.application_id         =  fat.application_id

   AND fa.application_id         =  fat.application_id

   AND cpt.language              =  USERENV('LANG')

   AND fat.language              =  USERENV('LANG')

   AND cpt.user_concurrent_program_name = :Program_Name;

with responsibility names and request groups:

SELECT cpt.user_concurrent_program_name     "Concurrent Program Name",
       DECODE(rgu.request_unit_type,
              'P', 'Program',
              'S', 'Set',
              rgu.request_unit_type)        "Unit Type",
       cp.concurrent_program_name           "Concurrent Program Short Name",
       rg.application_id                    "Application ID",
       frv.responsibility_name              "Responsibility Name",
       rg.request_group_name                "Request Group Name",
       fat.application_name                 "Application Name",
       fa.application_short_name            "Application Short Name",
       fa.basepath                          "Basepath"   
  FROM apps.fnd_request_groups          rg,
       apps.fnd_request_group_units     rgu,
       apps.fnd_concurrent_programs     cp,
       apps.fnd_concurrent_programs_tl  cpt,
       apps.fnd_application             fa,
       apps.fnd_application_tl          fat,
       apps.FND_RESPONSIBILITY_VL frv
 WHERE rg.request_group_id       =  rgu.request_group_id
   AND rgu.request_unit_id       =  cp.concurrent_program_id
   AND cp.concurrent_program_id  =  cpt.concurrent_program_id
   AND rg.application_id         =  fat.application_id
   AND fa.application_id         =  fat.application_id
   AND cpt.language              =  USERENV('LANG')
   AND fat.language              =  USERENV('LANG')
   AND rg.request_group_id           = frv.request_group_id 

   AND ((frv.end_date is null) or (trunc(frv.end_date) >= SYSDATE))                   
   AND cpt.user_concurrent_program_name =:Program_Name;