Product: | FND - Application Object Library |
---|---|
Description: | All notification information |
Implementation/DBA Data: | APPS.WF_NOTIFICATIONS_VIEW |
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