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

TABLE: CSL.CSL_WF_NOTIFICATIONS_INQ

Object Details
Object Name: CSL_WF_NOTIFICATIONS_INQ
Object Type: TABLE
Owner: CSL
Subobject Name:
Status: VALID


Inqueue table for WF_NOTIFICATIONS containing data uploaded by mobile clients


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSL_WF_NOTIFICATIONS_INQ_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANID$$
ColumnCLID$$CS
ColumnSEQNO$$
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (240)
Mobile username refers to FND_USER
NOTIFICATION_ID NUMBER

Unique notification identifier
GROUP_ID NUMBER

Grouping of notifications
MESSAGE_TYPE VARCHAR2 (8)
Item type of the message
MESSAGE_NAME VARCHAR2 (30)
Internal name of the message
RECIPIENT_ROLE VARCHAR2 (320)
Role of person to receive notification
STATUS VARCHAR2 (8)
Determines whether the notification is open or closed
ACCESS_KEY VARCHAR2 (80)
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
ORIGINAL_RECIPIENT VARCHAR2 (320)
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
DMLTYPE$$ VARCHAR2 (1)
DML code
SEQNO$$ NUMBER (10)
Oracle Lite sequence number
TRANID$$ NUMBER (10)
Transaction id
VERSION$$ NUMBER (10)
Record version
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CLID$$CS
,      NOTIFICATION_ID
,      GROUP_ID
,      MESSAGE_TYPE
,      MESSAGE_NAME
,      RECIPIENT_ROLE
,      STATUS
,      ACCESS_KEY
,      MAIL_STATUS
,      PRIORITY
,      BEGIN_DATE
,      END_DATE
,      DUE_DATE
,      ORIGINAL_RECIPIENT
,      FROM_USER
,      TO_USER
,      SUBJECT
,      LANGUAGE
,      MORE_INFO_ROLE
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
FROM CSL.CSL_WF_NOTIFICATIONS_INQ;

Dependencies

[top of page]

CSL.CSL_WF_NOTIFICATIONS_INQ does not reference any database object

CSL.CSL_WF_NOTIFICATIONS_INQ is referenced by following:

SchemaCSL
ViewCSL_WF_NOTIFICATIONS_INQ#