VIEW: APPS.WF_HA_NTF_V

Source

View Text - Preformatted

SELECT N.ROWID ROW_ID, I.Item_type, I.Item_key, N.NOTIFICATION_ID, N.GROUP_ID, N.MESSAGE_TYPE,N.MESSAGE_NAME, N.RECIPIENT_ROLE, N.STATUS, N.ACCESS_KEY, N.MAIL_STATUS, N.PRIORITY, N.BEGIN_DATE, N.END_DATE, N.DUE_DATE, N.RESPONDER, N.USER_COMMENT, N.CALLBACK, N.CONTEXT, N.ORIGINAL_RECIPIENT, N.FROM_USER, N.TO_USER, N.SUBJECT, N.LANGUAGE, N.MORE_INFO_ROLE FROM WF_NOTIFICATIONS N,WF_ITEMS I WHERE N.group_id in (select notification_id from wf_item_activity_statuses IAS where IAS.ITEM_TYPE = I.Item_type and IAS.ITEM_KEY = I.Item_key UNION ALL select notification_id from wf_item_activity_statuses_h IASH where IASH.ITEM_TYPE = I.Item_type and IASH.ITEM_KEY = I.Item_key)

View Text - HTML Formatted

SELECT N.ROWID ROW_ID
, I.ITEM_TYPE
, I.ITEM_KEY
, N.NOTIFICATION_ID
, N.GROUP_ID
, N.MESSAGE_TYPE
, N.MESSAGE_NAME
, N.RECIPIENT_ROLE
, N.STATUS
, N.ACCESS_KEY
, N.MAIL_STATUS
, N.PRIORITY
, N.BEGIN_DATE
, N.END_DATE
, N.DUE_DATE
, N.RESPONDER
, N.USER_COMMENT
, N.CALLBACK
, N.CONTEXT
, N.ORIGINAL_RECIPIENT
, N.FROM_USER
, N.TO_USER
, N.SUBJECT
, N.LANGUAGE
, N.MORE_INFO_ROLE
FROM WF_NOTIFICATIONS N
, WF_ITEMS I
WHERE N.GROUP_ID IN (SELECT NOTIFICATION_ID
FROM WF_ITEM_ACTIVITY_STATUSES IAS
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY UNION ALL SELECT NOTIFICATION_ID
FROM WF_ITEM_ACTIVITY_STATUSES_H IASH
WHERE IASH.ITEM_TYPE = I.ITEM_TYPE
AND IASH.ITEM_KEY = I.ITEM_KEY)