DBA Data[Home] [Help] [Dependency Information]


TABLE: APPLSYS.WF_NOTIFICATIONS

Object Details
Object Name: WF_NOTIFICATIONS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_NOTIFICATIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNOTIFICATION_ID
WF_NOTIFICATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECIPIENT_ROLE
ColumnSTATUS
WF_NOTIFICATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
ColumnNOTIFICATION_ID
WF_NOTIFICATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAIL_STATUS
ColumnSTATUS
WF_NOTIFICATIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIGINAL_RECIPIENT
WF_NOTIFICATIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_TYPE
ColumnSTATUS
WF_NOTIFICATIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMORE_INFO_ROLE
ColumnSTATUS
WF_NOTIFICATIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_ROLE
ColumnSTATUS
WF_NOTIFICATIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONDER
Columns
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
Query Text

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;

Dependencies

[top of page]

APPLSYS.WF_NOTIFICATIONS does not reference any database object

APPLSYS.WF_NOTIFICATIONS is referenced by following:

SchemaAPPLSYS
ViewWF_NOTIFICATIONS#