Find requet_group of specific request or C.P

    SELECT

    --######################################################

    ---Find requet_group of specific request or C.P

    --######################################################

       RG.APPLICATION_ID "Request Group Application ID",

       RG.REQUEST_GROUP_ID "Request Group - Group ID",

       RG.REQUEST_GROUP_NAME,

       RG.DESCRIPTION,

       rgu.unit_application_id,

       rgu.request_group_id "Request Group Unit - Group ID",

       rgu.request_unit_id,

       cp.concurrent_program_id,

       cp.concurrent_program_name,

       cpt.user_concurrent_program_name,

       DECODE (rgu.request_unit_type,

               'P', 'Program',

               'S', 'Set',

               rgu.request_unit_type)

          "Unit Type"

  FROM fnd_request_groups rg,

       fnd_request_group_units rgu,

       fnd_concurrent_programs cp,

       FND_CONCURRENT_PROGRAMS_TL CPT

 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 cpt.user_concurrent_program_name = 'Your_Concurrent_Program_Name';