View: WF_NOTIFICATION_ATTR_RESP_V

Product:	FND - Application Object Library
Description:	Information for notifications that have been responded and are closed
Implementation/DBA Data:	APPS.WF_NOTIFICATION_ATTR_RESP_V

View Text

SELECT WFN.GROUP_ID
, WFN.RECIPIENT_ROLE
, WF_DIRECTORY.GETROLEDISPLAYNAME(RECIPIENT_ROLE)
, WFNA.NAME
, WFMA.DISPLAY_NAME
, WFNA.TEXT_VALUE
, WF_NOTIFICATION.GETSHORTTEXT('&'||WFNA.NAME
, WFN.NOTIFICATION_ID) ATTR_VALUE
, WFN.MESSAGE_TYPE
, WFN.MESSAGE_NAME
FROM WF_NOTIFICATIONS WFN
, WF_NOTIFICATION_ATTRIBUTES WFNA
, WF_MESSAGE_ATTRIBUTES_VL WFMA
WHERE WFN.STATUS = 'CLOSED'
AND WFN.MESSAGE_TYPE = WFMA.MESSAGE_TYPE
AND WFN.MESSAGE_NAME = WFMA.MESSAGE_NAME
AND WFN.NOTIFICATION_ID = WFNA.NOTIFICATION_ID
AND WFNA.NAME = WFMA.NAME
AND WFMA.SUBTYPE = 'RESPOND'

Columns