Query to get Oracle Workflow Deferred Activities

SELECT COUNT(1)

      ,wias.item_type

  FROM apps.wf_items wi

      ,apps.wf_item_activity_statuses wias

  ,apps.wf_process_activities wpa

 WHERE wi.item_type = wias.item_type

   AND wi.item_key = wias.item_key

   AND wi.end_date IS NULL

   AND wias.end_date IS NULL

   AND wias.activity_status = 'DEFERRED'

   --AND wias.item_type = 'REQAPPRV'

   AND wias.item_type = wi.item_type

   AND wpa.instance_id(+) = wias.process_activity

GROUP BY wias.item_type