Oracle Concurrent Programs wise Request Group and Responsibility Name Script

SELECT   frg.request_group_name, frg.description request_group_description,

         fat.application_name, frv.responsibility_name, frv.description,

         frv.responsibility_key, fcp.concurrent_program_name,

         fcp.user_concurrent_program_name, fcp.description cp_description

    FROM fnd_request_group_units frgu,

         fnd_request_groups frg,

         fnd_concurrent_programs_vl fcp,

         fnd_application_tl fat,

         fnd_responsibility_vl frv

   WHERE frg.request_group_id = frgu.request_group_id

     AND frg.application_id = frgu.application_id

     AND frgu.request_unit_id = fcp.concurrent_program_id

     AND frg.application_id = fat.application_id

     AND fat.application_id = frv.application_id

     AND frg.request_group_id = frv.request_group_id

     AND fcp.concurrent_program_name = :p_program_short_name

ORDER BY responsibility_name;

Email us at JGTech