[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WF_NOTIFICATIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | APPLSYS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| NOTIFICATION_ID | NUMBER | Yes | ||
| GROUP_ID | NUMBER | Yes | ||
| MESSAGE_TYPE | VARCHAR2 | (8) | Yes | |
| MESSAGE_NAME | VARCHAR2 | (30) | Yes | |
| RECIPIENT_ROLE | VARCHAR2 | (320) | Yes | |
| STATUS | VARCHAR2 | (8) | Yes | |
| ACCESS_KEY | VARCHAR2 | (80) | Yes | |
| MAIL_STATUS | VARCHAR2 | (8) | ||
| PRIORITY | NUMBER | |||
| BEGIN_DATE | DATE | |||
| END_DATE | DATE | |||
| DUE_DATE | DATE | |||
| RESPONDER | VARCHAR2 | (320) | ||
| USER_COMMENT | VARCHAR2 | (4000) | ||
| CALLBACK | VARCHAR2 | (240) | ||
| CONTEXT | VARCHAR2 | (2000) | ||
| ORIGINAL_RECIPIENT | VARCHAR2 | (320) | Yes | |
| FROM_USER | VARCHAR2 | (320) | ||
| TO_USER | VARCHAR2 | (320) | ||
| SUBJECT | VARCHAR2 | (2000) | ||
| LANGUAGE | VARCHAR2 | (4) | ||
| MORE_INFO_ROLE | VARCHAR2 | (320) | ||
| FROM_ROLE | VARCHAR2 | (320) | ||
| SECURITY_GROUP_ID | VARCHAR2 | (32) | ||
| USER_KEY | VARCHAR2 | (240) | ||
| ITEM_KEY | VARCHAR2 | (240) | ||
| PROTECTED_TEXT_ATTRIBUTE1 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE2 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE3 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE4 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE5 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE6 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE7 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE8 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE9 | VARCHAR2 | (4000) | ||
| PROTECTED_TEXT_ATTRIBUTE10 | VARCHAR2 | (4000) | ||
| PROTECTED_FORM_ATTRIBUTE1 | VARCHAR2 | (4000) | ||
| PROTECTED_FORM_ATTRIBUTE2 | VARCHAR2 | (4000) | ||
| PROTECTED_FORM_ATTRIBUTE3 | VARCHAR2 | (4000) | ||
| PROTECTED_FORM_ATTRIBUTE4 | VARCHAR2 | (4000) | ||
| PROTECTED_FORM_ATTRIBUTE5 | VARCHAR2 | (4000) | ||
| PROTECTED_URL_ATTRIBUTE1 | VARCHAR2 | (4000) | ||
| PROTECTED_URL_ATTRIBUTE2 | VARCHAR2 | (4000) | ||
| PROTECTED_URL_ATTRIBUTE3 | VARCHAR2 | (4000) | ||
| PROTECTED_URL_ATTRIBUTE4 | VARCHAR2 | (4000) | ||
| PROTECTED_URL_ATTRIBUTE5 | VARCHAR2 | (4000) | ||
| PROTECTED_DATE_ATTRIBUTE1 | DATE | |||
| PROTECTED_DATE_ATTRIBUTE2 | DATE | |||
| PROTECTED_DATE_ATTRIBUTE3 | DATE | |||
| PROTECTED_DATE_ATTRIBUTE4 | DATE | |||
| PROTECTED_DATE_ATTRIBUTE5 | DATE | |||
| PROTECTED_NUMBER_ATTRIBUTE1 | NUMBER | |||
| PROTECTED_NUMBER_ATTRIBUTE2 | NUMBER | |||
| PROTECTED_NUMBER_ATTRIBUTE3 | NUMBER | |||
| PROTECTED_NUMBER_ATTRIBUTE4 | NUMBER | |||
| PROTECTED_NUMBER_ATTRIBUTE5 | NUMBER | |||
| TEXT_ATTRIBUTE1 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE2 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE3 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE4 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE5 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE6 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE7 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE8 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE9 | VARCHAR2 | (4000) | ||
| TEXT_ATTRIBUTE10 | VARCHAR2 | (4000) | ||
| FORM_ATTRIBUTE1 | VARCHAR2 | (4000) | ||
| FORM_ATTRIBUTE2 | VARCHAR2 | (4000) | ||
| FORM_ATTRIBUTE3 | VARCHAR2 | (4000) | ||
| FORM_ATTRIBUTE4 | VARCHAR2 | (4000) | ||
| FORM_ATTRIBUTE5 | VARCHAR2 | (4000) | ||
| URL_ATTRIBUTE1 | VARCHAR2 | (4000) | ||
| URL_ATTRIBUTE2 | VARCHAR2 | (4000) | ||
| URL_ATTRIBUTE3 | VARCHAR2 | (4000) | ||
| URL_ATTRIBUTE4 | VARCHAR2 | (4000) | ||
| URL_ATTRIBUTE5 | VARCHAR2 | (4000) | ||
| DATE_ATTRIBUTE1 | DATE | |||
| DATE_ATTRIBUTE2 | DATE | |||
| DATE_ATTRIBUTE3 | DATE | |||
| DATE_ATTRIBUTE4 | DATE | |||
| DATE_ATTRIBUTE5 | DATE | |||
| NUMBER_ATTRIBUTE1 | NUMBER | |||
| NUMBER_ATTRIBUTE2 | NUMBER | |||
| NUMBER_ATTRIBUTE3 | NUMBER | |||
| NUMBER_ATTRIBUTE4 | NUMBER | |||
| NUMBER_ATTRIBUTE5 | NUMBER | |||
| SENT_DATE | 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
APPS
WF_NOTIFICATIONS
|
|
|
|