Query to get Errored Activities in Oracle Workflow

SELECT wav.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           wav

   ,wf_activities_vl           wav1

   ,wf_items wi

  WHERE wias.item_type = wi.item_type

    AND wias.item_key = wi.item_key

    AND wias.activity_status = 'ERROR'

    AND wias.process_activity = wpa.instance_id

    AND wpa.activity_name = wav.name

    AND wpa.activity_item_type = wav.item_type

    AND wpa.process_name = wav1.name

    AND wpa.process_item_type = wav1.item_type

    AND wpa.process_version = wav1.version

    AND wi.parent_item_type = 'XXITEMTP'

    AND wi.parent_item_key = 'XXITEMTP001'

    AND wi.begin_date >= wav.begin_date

    AND wi.begin_date < NVL(wav.end_date, wi.begin_date + 1)

  ORDER BY wias.execution_time