[Home] [Help] [Dependency Information]
Object Name: | WF_NOTIFICATIONS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.WF_NOTIFICATIONS_VIEW |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This shows all information for notification. It expands from the table
definiton by including the status quickcode description and the
subject, message text and recepient role name.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
NOTIFICATION_ID | NUMBER | Yes | Unique notification identifier | |
GROUP_ID | NUMBER | Yes | grouping of notifications | |
MESSAGE_TYPE | VARCHAR2 | (8) | Yes | Item type of the message |
MESSAGE_NAME | VARCHAR2 | (30) | Yes | Internal name of the message |
RECIPIENT_ROLE | VARCHAR2 | (320) | Yes | Role of person to receive the notification |
STATUS | VARCHAR2 | (8) | Yes | Status code (open or closed) |
ACCESS_KEY | VARCHAR2 | (80) | Yes | Internal Key |
MAIL_STATUS | VARCHAR2 | (8) | Mail status of the notification | |
PRIORITY | NUMBER | Priority (1-100) | ||
BEGIN_DATE | DATE | Start date | ||
END_DATE | DATE | Finished date | ||
DUE_DATE | DATE | Date timeout occurs if no responce | ||
USER_COMMENT | VARCHAR2 | (4000) | User comment | |
CALLBACK | VARCHAR2 | (240) | Package and procedure name to execute once notification is responded to | |
CONTEXT | VARCHAR2 | (2000) | Data used by the specified callback function | |
SUBJECT | VARCHAR2 | (4000) | Subject line of the message | |
MESSAGE | VARCHAR2 | (4000) | The message body | |
RECIPIENT_ROLE_NAME | VARCHAR2 | (4000) | The display name of the recipient role | |
STATUS_NAME | VARCHAR2 | (80) | Yes | Quickcode meaning of the status code |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, SUBJECT
, MESSAGE
, RECIPIENT_ROLE_NAME
, STATUS_NAME
FROM APPS.WF_NOTIFICATIONS_VIEW;
|
|
|