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

TABLE: CSM.CSF_M_MAIL_MESSAGES_INQ

Object Details
Object Name: CSF_M_MAIL_MESSAGES_INQ
Object Type: TABLE
Owner: CSM
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (30)
Name of the Client
NOTIFICATION_ID NUMBER
Yes Unique Notification ID
SENDER VARCHAR2 (320)
Role or email address that sent the mail message
MESSAGE VARCHAR2 (4000)
Message Description
DATERECEIVED DATE

The date on which the message was received
RECEIVER VARCHAR2 (4000)
Role or email address that received the mail message
RESOURCE_ID NUMBER

The Resource or agent identifier
CLIENT_NAME VARCHAR2 (4000)
The name of the client
DMLTYPE$$ VARCHAR2 (1)
Type of the DML operation performed at the client
SEQNO$$ NUMBER

Sequence Nmber to uniquely identify this record, among the records, which were performed
TRANID$$ NUMBER (10)
Id of the synch session in which this record was populated
VERSION$$ NUMBER (10)
The identifier of the Version Number
SUBJECT VARCHAR2 (4000)
MESSAGE_TYPE VARCHAR2 (4000)
SENDER_FULL_NAME#1 VARCHAR2 (360)
RECEIVER_FULL_NAME#1 VARCHAR2 (360)
Query Text

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


SELECT CLID$$CS
,      NOTIFICATION_ID
,      SENDER
,      MESSAGE
,      DATERECEIVED
,      RECEIVER
,      RESOURCE_ID
,      CLIENT_NAME
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      SUBJECT
,      MESSAGE_TYPE
,      SENDER_FULL_NAME#1
,      RECEIVER_FULL_NAME#1
FROM CSM.CSF_M_MAIL_MESSAGES_INQ;

Dependencies

[top of page]

CSM.CSF_M_MAIL_MESSAGES_INQ does not reference any database object

CSM.CSF_M_MAIL_MESSAGES_INQ is referenced by following:

SchemaCSM
ViewCSF_M_MAIL_MESSAGES_INQ#