Get Request Group name Associated With Application

Get Request Group name Associated With Application



SELECT   g.request_group_name, c.user_concurrent_program_name,
         a.application_name, g.application_id, g.request_group_id,
         u.unit_application_id, u.request_unit_id
    FROM fnd_request_groups g,
         fnd_request_group_units u,
         fnd_application_tl a,
         fnd_concurrent_programs_tl c
   WHERE g.request_group_id = u.request_group_id
     AND u.unit_application_id = a.application_id
     AND u.request_unit_id = c.concurrent_program_id
ORDER BY c.user_concurrent_program_name,
         a.application_name,
         g.request_group_id