eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSL_WF_NOTIFICATIONS_INQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANID$$ CLID$$CS SEQNO$$

Columns

Name	Datatype	Length	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:

APPS: CSL_WF_NOTIFICATIONS_INQ