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

TABLE: CSM.CSF_M_MAIL_RECIPIENTS_INQ

Object Details
Object Name: CSF_M_MAIL_RECIPIENTS_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
DELETE_FLAG VARCHAR2 (4000)
The Delete Flag
READ_FLAG VARCHAR2 (4000)
The Read Flag
DATERECEIVED DATE

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

The Resource or agent identifier
RESOURCE_RECV_ID NUMBER

The Resource Receiving ID
CLIENT_NAME VARCHAR2 (4000)
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
MSGORIGADDRESS#1 VARCHAR2 (4000)
Query Text

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


SELECT CLID$$CS
,      NOTIFICATION_ID
,      DELETE_FLAG
,      READ_FLAG
,      DATERECEIVED
,      RECIPADDRESS
,      RESOURCE_ID
,      RESOURCE_RECV_ID
,      CLIENT_NAME
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      MSGORIGADDRESS#1
FROM CSM.CSF_M_MAIL_RECIPIENTS_INQ;

Dependencies

[top of page]

CSM.CSF_M_MAIL_RECIPIENTS_INQ does not reference any database object

CSM.CSF_M_MAIL_RECIPIENTS_INQ is referenced by following:

SchemaCSM
ViewCSF_M_MAIL_RECIPIENTS_INQ#