Workflow: SQL Query to get workflow notification errors within a certain period

--***********************************************************************************

--Workflow: SQL Query to get workflow notification errors within a certain period

--*********************************************************************************** 
SELECT   IAS.BEGIN_DATE, IAS.ITEM_KEY, AC.NAME ACTIVITY,
         IAS.ACTIVITY_RESULT_CODE RESULT, IAS.ERROR_NAME ERROR_NAME,
         IAS.ERROR_MESSAGE ERROR_MESSAGE
    FROM WF_ITEM_ACTIVITY_STATUSES IAS,
         WF_PROCESS_ACTIVITIES PA,
         WF_ACTIVITIES AC,
         WF_ACTIVITIES AP,
         WF_ITEMS I
   WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
     AND IAS.ACTIVITY_STATUS = 'ERROR'
     AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
     AND PA.ACTIVITY_NAME = AC.NAME
     AND PA.ACTIVITY_ITEM_TYPE = AC.ITEM_TYPE
     AND PA.PROCESS_NAME = AP.NAME
     AND PA.PROCESS_ITEM_TYPE = AP.ITEM_TYPE
     AND PA.PROCESS_VERSION = AP.VERSION
     AND I.ITEM_TYPE = 'APEXP'
     AND I.ITEM_KEY = IAS.ITEM_KEY
     AND I.BEGIN_DATE >= AC.BEGIN_DATE
     AND I.BEGIN_DATE < NVL (AC.END_DATE, I.BEGIN_DATE + 1)
ORDER BY IAS.BEGIN_DATE DESC;