VIEW: APPS.WF_NOTIFICATIONS_VIEW

Source

View Text - Preformatted

SELECT N.ROWID ROW_ID , 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.USER_COMMENT , N.CALLBACK , N.CONTEXT , WF_NOTIFICATION.GETSUBJECT(N.NOTIFICATION_ID) SUBJECT , WF_NOTIFICATION.GETSHORTBODY(N.NOTIFICATION_ID) MESSAGE , WF_DIRECTORY.GETROLEDISPLAYNAME(N.RECIPIENT_ROLE) RECIPIENT_ROLE_NAME , L.MEANING STATUS_NAME FROM WF_NOTIFICATIONS N, WF_LOOKUPS L WHERE L.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS' AND L.LOOKUP_CODE = N.STATUS

View Text - HTML Formatted

SELECT N.ROWID ROW_ID
, 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.USER_COMMENT
, N.CALLBACK
, N.CONTEXT
, WF_NOTIFICATION.GETSUBJECT(N.NOTIFICATION_ID) SUBJECT
, WF_NOTIFICATION.GETSHORTBODY(N.NOTIFICATION_ID) MESSAGE
, WF_DIRECTORY.GETROLEDISPLAYNAME(N.RECIPIENT_ROLE) RECIPIENT_ROLE_NAME
, L.MEANING STATUS_NAME
FROM WF_NOTIFICATIONS N
, WF_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
AND L.LOOKUP_CODE = N.STATUS