View: WF_HA_NTFA_V

Product:	FND - Application Object Library
Description:	Private view for High Availability project. Subject to change without notice.
Implementation/DBA Data:	APPS.WF_HA_NTFA_V

View Text

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)

Columns