Workflow Notification Details

----------------------------------------------
--Workflow Notification Details
----------------------------------------------
select  wn.notification_id nid,
        wn.context,
        wn.group_id,
        wn.status,
        wn.mail_status,
        wn.message_type,
        wn.message_name,
        wn.access_key,
        wn.priority,
        wn.begin_date,
        wn.end_date,
        wn.due_date,
        wn.callback,
        wn.recipient_role,
        wn.responder,
        wn.original_recipient,
        wn.from_user,
        wn.to_user,
        wn.subject
from    wf_notifications wn, wf_item_activity_statuses wias
where  wn.group_id = wias.notification_id
and  wias.item_type = 'APEXP'
and  wias.item_key  = 'APX123SD';

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;