[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WF_NOTIFICATIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.WF_NOTIFICATIONS
|
| Subobject Name: | |
| Status: | VALID |
WF_NOTIFICATIONS holds the runtime information about a specific
instance of a sent message. A new row is created in the table each
time a message is sent.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WF_NOTIFICATIONS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 NOTIFICATION_ID
|
| WF_NOTIFICATIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RECIPIENT_ROLE
STATUS
|
| WF_NOTIFICATIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GROUP_ID
NOTIFICATION_ID
|
| WF_NOTIFICATIONS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MAIL_STATUS
STATUS
|
| WF_NOTIFICATIONS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORIGINAL_RECIPIENT
|
| WF_NOTIFICATIONS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MESSAGE_TYPE
STATUS
|
| WF_NOTIFICATIONS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MORE_INFO_ROLE
STATUS
|
| WF_NOTIFICATIONS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_ROLE
STATUS
|
| WF_NOTIFICATIONS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESPONDER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 notification |
| STATUS | VARCHAR2 | (8) | Yes | Determines whether the notification is open or closed |
| ACCESS_KEY | VARCHAR2 | (80) | Yes | Access key for notifications |
| MAIL_STATUS | VARCHAR2 | (8) | Status tells mailer if it should send, and mailer records the result here if sent operation is successful | |
| PRIORITY | NUMBER | Priority assigned to the message (1-100) | ||
| BEGIN_DATE | DATE | Start date | ||
| END_DATE | DATE | Date finished | ||
| DUE_DATE | DATE | Indicates the reply-by date | ||
| RESPONDER | VARCHAR2 | (320) | Role or e-mail address that responded to a notification | |
| USER_COMMENT | VARCHAR2 | (4000) | User comment | |
| CALLBACK | VARCHAR2 | (240) | Package and procedure name used by the notification | |
| CONTEXT | VARCHAR2 | (2000) | Data used by callback to call the procedure | |
| ORIGINAL_RECIPIENT | VARCHAR2 | (320) | Yes | Original recipient (as opposed to forwarded recipient) |
| FROM_USER | VARCHAR2 | (320) | Denormalized value (display name) of FROM_ROLE | |
| TO_USER | VARCHAR2 | (320) | Denormalized value of RECIPEINT_ROLE | |
| SUBJECT | VARCHAR2 | (2000) | Denormalized value of subject | |
| LANGUAGE | VARCHAR2 | (4) | Language in which the denormalized values is in | |
| MORE_INFO_ROLE | VARCHAR2 | (320) | More information is requested from this role | |
| FROM_ROLE | VARCHAR2 | (320) | The role that send this notification | |
| SECURITY_GROUP_ID | VARCHAR2 | (32) | identifier reserved for hosting environment | |
| USER_KEY | VARCHAR2 | (240) | User key | |
| ITEM_KEY | VARCHAR2 | (240) | Item Key | |
| PROTECTED_TEXT_ATTRIBUTE1 | VARCHAR2 | (4000) | Protected Text Custom Column1 | |
| PROTECTED_TEXT_ATTRIBUTE2 | VARCHAR2 | (4000) | Protected Text Custom Column2 | |
| PROTECTED_TEXT_ATTRIBUTE3 | VARCHAR2 | (4000) | Protected Text Custom Column3 | |
| PROTECTED_TEXT_ATTRIBUTE4 | VARCHAR2 | (4000) | Protected Text Custom Column4 | |
| PROTECTED_TEXT_ATTRIBUTE5 | VARCHAR2 | (4000) | Protected Text Custom Column5 | |
| PROTECTED_TEXT_ATTRIBUTE6 | VARCHAR2 | (4000) | Protected Text Custom Column6 | |
| PROTECTED_TEXT_ATTRIBUTE7 | VARCHAR2 | (4000) | Protected Text Custom Column7 | |
| PROTECTED_TEXT_ATTRIBUTE8 | VARCHAR2 | (4000) | Protected Text Custom Column8 | |
| PROTECTED_TEXT_ATTRIBUTE9 | VARCHAR2 | (4000) | Protected Text Custom Column9 | |
| PROTECTED_TEXT_ATTRIBUTE10 | VARCHAR2 | (4000) | Protected Text Custom Column10 | |
| PROTECTED_FORM_ATTRIBUTE1 | VARCHAR2 | (4000) | Protected Form Custom Column1 | |
| PROTECTED_FORM_ATTRIBUTE2 | VARCHAR2 | (4000) | Protected Form Custom Column2 | |
| PROTECTED_FORM_ATTRIBUTE3 | VARCHAR2 | (4000) | Protected Form Custom Column3 | |
| PROTECTED_FORM_ATTRIBUTE4 | VARCHAR2 | (4000) | Protected Form Custom Column4 | |
| PROTECTED_FORM_ATTRIBUTE5 | VARCHAR2 | (4000) | Protected Form Custom Column5 | |
| PROTECTED_URL_ATTRIBUTE1 | VARCHAR2 | (4000) | Protected URL Custom Column1 | |
| PROTECTED_URL_ATTRIBUTE2 | VARCHAR2 | (4000) | Protected URL Custom Column2 | |
| PROTECTED_URL_ATTRIBUTE3 | VARCHAR2 | (4000) | Protected URL Custom Column3 | |
| PROTECTED_URL_ATTRIBUTE4 | VARCHAR2 | (4000) | Protected URL Custom Column4 | |
| PROTECTED_URL_ATTRIBUTE5 | VARCHAR2 | (4000) | Protected URL Custom Column5 | |
| PROTECTED_DATE_ATTRIBUTE1 | DATE | Protected Date Custom Column1 | ||
| PROTECTED_DATE_ATTRIBUTE2 | DATE | Protected Date Custom Column2 | ||
| PROTECTED_DATE_ATTRIBUTE3 | DATE | Protected Date Custom Column3 | ||
| PROTECTED_DATE_ATTRIBUTE4 | DATE | Protected Date Custom Column4 | ||
| PROTECTED_DATE_ATTRIBUTE5 | DATE | Protected Date Custom Column5 | ||
| PROTECTED_NUMBER_ATTRIBUTE1 | NUMBER | Protected Number Custom Column1 | ||
| PROTECTED_NUMBER_ATTRIBUTE2 | NUMBER | Protected Number Custom Column2 | ||
| PROTECTED_NUMBER_ATTRIBUTE3 | NUMBER | Protected Number Custom Column3 | ||
| PROTECTED_NUMBER_ATTRIBUTE4 | NUMBER | Protected Number Custom Column4 | ||
| PROTECTED_NUMBER_ATTRIBUTE5 | NUMBER | Protected Number Custom Column5 | ||
| TEXT_ATTRIBUTE1 | VARCHAR2 | (4000) | Text Custom Column1 | |
| TEXT_ATTRIBUTE2 | VARCHAR2 | (4000) | Text Custom Column2 | |
| TEXT_ATTRIBUTE3 | VARCHAR2 | (4000) | Text Custom Column3 | |
| TEXT_ATTRIBUTE4 | VARCHAR2 | (4000) | Text Custom Column4 | |
| TEXT_ATTRIBUTE5 | VARCHAR2 | (4000) | Text Custom Column5 | |
| TEXT_ATTRIBUTE6 | VARCHAR2 | (4000) | Text Custom Column6 | |
| TEXT_ATTRIBUTE7 | VARCHAR2 | (4000) | Text Custom Column7 | |
| TEXT_ATTRIBUTE8 | VARCHAR2 | (4000) | Text Custom Column8 | |
| TEXT_ATTRIBUTE9 | VARCHAR2 | (4000) | Text Custom Column9 | |
| TEXT_ATTRIBUTE10 | VARCHAR2 | (4000) | Text Custom Column10 | |
| FORM_ATTRIBUTE1 | VARCHAR2 | (4000) | Text Custom Column1 | |
| FORM_ATTRIBUTE2 | VARCHAR2 | (4000) | Text Custom Column2 | |
| FORM_ATTRIBUTE3 | VARCHAR2 | (4000) | Text Custom Column3 | |
| FORM_ATTRIBUTE4 | VARCHAR2 | (4000) | Text Custom Column4 | |
| FORM_ATTRIBUTE5 | VARCHAR2 | (4000) | Text Custom Column5 | |
| URL_ATTRIBUTE1 | VARCHAR2 | (4000) | Text Custom Column1 | |
| URL_ATTRIBUTE2 | VARCHAR2 | (4000) | Text Custom Column2 | |
| URL_ATTRIBUTE3 | VARCHAR2 | (4000) | Text Custom Column3 | |
| URL_ATTRIBUTE4 | VARCHAR2 | (4000) | Text Custom Column4 | |
| URL_ATTRIBUTE5 | VARCHAR2 | (4000) | Text Custom Column5 | |
| DATE_ATTRIBUTE1 | DATE | Date Custom Column1 | ||
| DATE_ATTRIBUTE2 | DATE | Date Custom Column2 | ||
| DATE_ATTRIBUTE3 | DATE | Date Custom Column3 | ||
| DATE_ATTRIBUTE4 | DATE | Date Custom Column4 | ||
| DATE_ATTRIBUTE5 | DATE | Date Custom Column5 | ||
| NUMBER_ATTRIBUTE1 | NUMBER | Number Custom Column1 | ||
| NUMBER_ATTRIBUTE2 | NUMBER | Number Custom Column2 | ||
| NUMBER_ATTRIBUTE3 | NUMBER | Number Custom Column3 | ||
| NUMBER_ATTRIBUTE4 | NUMBER | Number Custom Column4 | ||
| NUMBER_ATTRIBUTE5 | NUMBER | Number Custom Column5 | ||
| SENT_DATE | DATE | Notification Sent Date |
Cut, paste (and edit) the following text to query this object:
SELECT NOTIFICATION_ID
, GROUP_ID
, MESSAGE_TYPE
, MESSAGE_NAME
, RECIPIENT_ROLE
, STATUS
, ACCESS_KEY
, MAIL_STATUS
, PRIORITY
, BEGIN_DATE
, END_DATE
, DUE_DATE
, RESPONDER
, USER_COMMENT
, CALLBACK
, CONTEXT
, ORIGINAL_RECIPIENT
, FROM_USER
, TO_USER
, SUBJECT
, LANGUAGE
, MORE_INFO_ROLE
, FROM_ROLE
, SECURITY_GROUP_ID
, USER_KEY
, ITEM_KEY
, PROTECTED_TEXT_ATTRIBUTE1
, PROTECTED_TEXT_ATTRIBUTE2
, PROTECTED_TEXT_ATTRIBUTE3
, PROTECTED_TEXT_ATTRIBUTE4
, PROTECTED_TEXT_ATTRIBUTE5
, PROTECTED_TEXT_ATTRIBUTE6
, PROTECTED_TEXT_ATTRIBUTE7
, PROTECTED_TEXT_ATTRIBUTE8
, PROTECTED_TEXT_ATTRIBUTE9
, PROTECTED_TEXT_ATTRIBUTE10
, PROTECTED_FORM_ATTRIBUTE1
, PROTECTED_FORM_ATTRIBUTE2
, PROTECTED_FORM_ATTRIBUTE3
, PROTECTED_FORM_ATTRIBUTE4
, PROTECTED_FORM_ATTRIBUTE5
, PROTECTED_URL_ATTRIBUTE1
, PROTECTED_URL_ATTRIBUTE2
, PROTECTED_URL_ATTRIBUTE3
, PROTECTED_URL_ATTRIBUTE4
, PROTECTED_URL_ATTRIBUTE5
, PROTECTED_DATE_ATTRIBUTE1
, PROTECTED_DATE_ATTRIBUTE2
, PROTECTED_DATE_ATTRIBUTE3
, PROTECTED_DATE_ATTRIBUTE4
, PROTECTED_DATE_ATTRIBUTE5
, PROTECTED_NUMBER_ATTRIBUTE1
, PROTECTED_NUMBER_ATTRIBUTE2
, PROTECTED_NUMBER_ATTRIBUTE3
, PROTECTED_NUMBER_ATTRIBUTE4
, PROTECTED_NUMBER_ATTRIBUTE5
, TEXT_ATTRIBUTE1
, TEXT_ATTRIBUTE2
, TEXT_ATTRIBUTE3
, TEXT_ATTRIBUTE4
, TEXT_ATTRIBUTE5
, TEXT_ATTRIBUTE6
, TEXT_ATTRIBUTE7
, TEXT_ATTRIBUTE8
, TEXT_ATTRIBUTE9
, TEXT_ATTRIBUTE10
, FORM_ATTRIBUTE1
, FORM_ATTRIBUTE2
, FORM_ATTRIBUTE3
, FORM_ATTRIBUTE4
, FORM_ATTRIBUTE5
, URL_ATTRIBUTE1
, URL_ATTRIBUTE2
, URL_ATTRIBUTE3
, URL_ATTRIBUTE4
, URL_ATTRIBUTE5
, DATE_ATTRIBUTE1
, DATE_ATTRIBUTE2
, DATE_ATTRIBUTE3
, DATE_ATTRIBUTE4
, DATE_ATTRIBUTE5
, NUMBER_ATTRIBUTE1
, NUMBER_ATTRIBUTE2
, NUMBER_ATTRIBUTE3
, NUMBER_ATTRIBUTE4
, NUMBER_ATTRIBUTE5
, SENT_DATE
FROM APPLSYS.WF_NOTIFICATIONS;
APPLSYS.WF_NOTIFICATIONS does not reference any database object
APPLSYS.WF_NOTIFICATIONS is referenced by following:
APPLSYS
WF_NOTIFICATIONS#
|
|
|
|