Query to get Request Set Information with Request Group

--Query to get Request Set Information with Request Group
SELECT rs.user_request_set_name Request_Set_Name
      ,rss.display_sequence Seq
      ,cp.user_concurrent_program_name Concurrent_Program_Name
      ,frg.request_group_name
      ,e.EXECUTABLE_NAME
      ,e.execution_file_name
      ,lv.meaning file_type
      ,fat.application_name Application_Name
      ,fa.application_short_name  Application_Short_Name
      ,fat.application_name application_name
  FROM fnd_request_sets_vl rs
      ,fnd_req_set_stages_form_v rss
      ,fnd_request_set_programs rsp
      ,fnd_concurrent_programs_vl cp
      ,fnd_executables e
      ,fnd_lookup_values lv
      ,fnd_application_tl fat
      ,fnd_request_group_units frgu
      ,fnd_request_groups frg
      ,fnd_application fa
WHERE 1=1
  AND rs.application_id = rss.set_application_id
  AND fa.application_id = fat.application_id
  AND rs.request_set_id = rss.request_set_id
  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
  AND rs.request_set_id = frgu.request_unit_id
  AND frgu.request_group_id = frg.request_group_id
  AND rs.user_request_set_name = :P_REQUEST_SET_NAME
ORDER BY 1;

Query to get list of Custom or Customised Workflows

--Query to get list of custom or customized workflows
SELECT distinct item_type,
       trunc(begin_date) 
  FROM apps.wf_activities a 
 WHERE begin_date > date '2002-01-01' 
   AND NOT EXISTS 
        (select 'x' 
           from apps.ad_patch_runs pr 
          where a.begin_date between pr.start_date - 1 and pr.end_date + 1 
        )
    AND item_type like 'XX%'
order by item_type, trunc(begin_date)


--Query to get list of customized Process and Activity in workflows
SELECT distinct process_item_type
      ,process_name
      ,activity_name
      ,instance_label
  FROM wf_process_activities
 WHERE process_name like 'XX' OR activity_name like '%XX%';