Query to find out Request set details

/* Formatted on 9/11/2013 9:23:44 AM (QP5 v5.114.809.3010) */
  SELECT   rs.user_request_set_name "Request Set",
           rss.display_sequence Seq,
           cp.user_concurrent_program_name "Concurrent Program",
           e.EXECUTABLE_NAME,
           e.execution_file_name,
           lv.meaning file_type,
           fat.application_name "Application Name"
    FROM   apps.fnd_request_sets_vl rs,
           apps.fnd_req_set_stages_form_v rss,
           applsys.fnd_request_set_programs rsp,
           apps.fnd_concurrent_programs_vl cp,
           apps.fnd_executables e,
           apps.fnd_lookup_values lv,
           apps.fnd_application_tl fat
   WHERE       1 = 1
           AND rs.application_id = rss.set_application_id
           AND rs.request_set_id = rss.request_set_id
           AND rs.user_request_set_name = :p_request_set_name
           AND e.APPLICATION_ID = FAT.APPLICATION_ID
           AND rss.set_application_id = rsp.set_application_id
           AND rss.request_set_id = rsp.request_set_id
           AND rss.request_set_stage_id = rsp.request_set_stage_id
           AND rsp.program_application_id = cp.application_id
           AND rsp.concurrent_program_id = cp.concurrent_program_id
           AND cp.executable_id = e.executable_id
           AND cp.executable_application_id = e.application_id
           AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
           AND lv.lookup_code = e.execution_method_code
           AND lv.language = 'US'
           AND fat.language = 'US'
           AND rs.end_date_active IS NULL
ORDER BY   1, 2