Find Request Group of Report

SQL Query To find Report Attached to Which Request Group

/* Formatted on 1/1/2015 3:43:35 PM (QP5 v5.215.12089.38647) */

SELECT frg.request_group_name,

frt.user_concurrent_program_name,

       frt.description,

       frg.request_group_code,

       frg.description

  FROM fnd_request_groups frg, fnd_concurrent_programs_tl frt

 WHERE     frg.application_id = frt.application_id

 AND frt.user_concurrent_program_name = 'KFSH Detailed Absence Report'