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


TABLE: CLN.M4R_WSM_DWIP_MSG_STAGING

Object Details
Object Name: M4R_WSM_DWIP_MSG_STAGING
Object Type: TABLE
Owner: CLN
FND Design Data: TableCLN.M4R_WSM_DWIP_MSG_STAGING
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
M4R_WSM_DWIP_MSG_STAGING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMSG_ID
Columns
Name Datatype Length Mandatory Comments
MSG_ID NUMBER
Yes Internal Control Number of the message, which is unique to the message
TP_FROM_CODE VARCHAR2 (30)
Code identifying the from trading partner
TP_TO_CODE VARCHAR2 (30)
Code identifying the to trading partner
PARTY_ID NUMBER

Party ID of the trading partner
PARTY_SITE_ID NUMBER

Party Site ID of the trading partner
DOC_GENERATION_DATE DATE

The Business Document Generation Date
DOC_ID VARCHAR2 (256)
The Business Document Identifier
Query Text

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


SELECT MSG_ID
,      TP_FROM_CODE
,      TP_TO_CODE
,      PARTY_ID
,      PARTY_SITE_ID
,      DOC_GENERATION_DATE
,      DOC_ID
FROM CLN.M4R_WSM_DWIP_MSG_STAGING;

Dependencies

[top of page]

CLN.M4R_WSM_DWIP_MSG_STAGING does not reference any database object

CLN.M4R_WSM_DWIP_MSG_STAGING is referenced by following:

SchemaAPPS
SynonymM4R_WSM_DWIP_MSG_STAGING