VIEW: APPS.WF_HA_NTFA_V

Source

View Text - Preformatted

SELECT NA.ROWID ROW_ID, I.Item_type, I.Item_key, NA.NOTIFICATION_ID, NA.NAME, NA.TEXT_VALUE, NA.NUMBER_VALUE, NA.DATE_VALUE FROM WF_NOTIFICATION_ATTRIBUTES NA,WF_NOTIFICATIONS N,WF_ITEMS I WHERE NA.notification_id = N.notification_id and 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 NA.ROWID ROW_ID
, I.ITEM_TYPE
, I.ITEM_KEY
, NA.NOTIFICATION_ID
, NA.NAME
, NA.TEXT_VALUE
, NA.NUMBER_VALUE
, NA.DATE_VALUE
FROM WF_NOTIFICATION_ATTRIBUTES NA
, WF_NOTIFICATIONS N
, WF_ITEMS I
WHERE NA.NOTIFICATION_ID = N.NOTIFICATION_ID
AND 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)