eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WF_NOTIFICATION_ATTR_RESP_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'