Query to get List of all Errored Oracle Workflow Activities for a given Item Type/Item Key

SELECT wac.display_name          activity

      ,wias.activity_result_code activity_result

  ,wias.error_name           error_name

  ,wias.error_message        error_message

  ,wias.error_stack          error_stack

  FROM wf_item_activity_statuses wias

      ,wf_process_activities wpa

      ,wf_activities_vl wac

      ,wf_activities_vl wap

      ,wf_items wi

 WHERE wias.item_type = 'XXITEMTP'

   AND wias.item_key = 'XXITEMTP001'

   AND wias.activity_status = 'ERROR'

   AND wias.process_activity = wpa.instance_id

   AND wpa.activity_name = wac.name

   AND wpa.activity_item_type = wac.item_type

   AND wpa.process_name = wap.name

   AND wpa.process_item_type = wap.item_type

   AND wpa.process_version = wap.version

   AND wi.item_type = 'XXITEMTP'

   AND wi.item_key = wias.item_key

   AND wi.begin_date >= wac.begin_date

   AND wi.begin_date < nvl(wac.end_date, wi.begin_date + 1)

 ORDER BY wias.execution_time