[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#;
|
|
|