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

TABLE: MSC.MSC_TP_SITE_ID_LID

Object Details
Object Name: MSC_TP_SITE_ID_LID
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_TP_SITE_ID_LID
Subobject Name:
Status: VALID


This table is used by the collection program to maintain the correspondence
between the source instances identifiers and the planning identifiers for trading
partner sites.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_TP_SITE_ID_LID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSR_INSTANCE_ID
ColumnSR_TP_SITE_ID
ColumnPARTNER_TYPE
ColumnSR_COMPANY_ID
MSC_TP_SITE_ID_LID_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_SITE_ID
MSC_TP_SITE_ID_LID_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
ColumnSR_INSTANCE_ID
ColumnPARTNER_TYPE
ColumnTP_SITE_ID
Columns
Name Datatype Length Mandatory Comments
SR_TP_SITE_ID NUMBER
Yes Trading partner site identifier at source application instance
PARTNER_TYPE NUMBER
Yes Indicate type of partner, supplier or customer
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
TP_SITE_ID NUMBER
Yes Trading partner site identifier generated at planning server
SR_COMPANY_ID NUMBER

Source company identifier
OPERATING_UNIT NUMBER

Operating Unit
LOCATION_ID NUMBER

Location Identifier
SR_CUST_ACCT_ID NUMBER

Customer Account Identifier
Query Text

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


SELECT SR_TP_SITE_ID
,      PARTNER_TYPE
,      SR_INSTANCE_ID
,      TP_SITE_ID
,      SR_COMPANY_ID
,      OPERATING_UNIT
,      LOCATION_ID
,      SR_CUST_ACCT_ID
FROM MSC.MSC_TP_SITE_ID_LID;

Dependencies

[top of page]

MSC.MSC_TP_SITE_ID_LID does not reference any database object

MSC.MSC_TP_SITE_ID_LID is referenced by following:

SchemaAPPS
SynonymMSC_TP_SITE_ID_LID