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%';