[Home] [Help]
View: XDP_FMC_V
Product: | XDP - Provisioning |
Description: | This view is used to retrieve workflow notifications |
Implementation/DBA Data: |
APPS.XDP_FMC_V
|
View Text
SELECT N.ROWID
, 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
, L.MEANING
FROM WF_NOTIFICATIONS N
, WF_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
AND L.LOOKUP_CODE = N.STATUS
Columns
Name |
ROW_ID |
NOTIFICATION_ID |
GROUP_ID |
MESSAGE_TYPE |
MESSAGE_NAME |
RECIPIENT_ROLE |
STATUS |
ACCESS_KEY |
MAIL_STATUS |
PRIORITY |
BEGIN_DATE |
END_DATE |
DUE_DATE |
USER_COMMENT |
CALLBACK |
CONTEXT |
STATUS_NAME |