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

TABLE: MSC.MSC_TP_ID_LID

Object Details
Object Name: MSC_TP_ID_LID
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_TP_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 partners.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_TP_ID_LID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSR_INSTANCE_ID
ColumnSR_TP_ID
ColumnPARTNER_TYPE
ColumnSR_COMPANY_ID
MSC_TP_ID_LID_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_ID
Columns
Name Datatype Length Mandatory Comments
SR_TP_ID NUMBER
Yes Trading partner identifier from source application instance
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
PARTNER_TYPE NUMBER
Yes Indicate type of partner, supplier or customer
TP_ID NUMBER
Yes Trading partner identifier generated at planning server
SR_COMPANY_ID NUMBER

Represents the sr company id for the company name in msc_companies. Used in Collaborative Planning
AGGREGATE_DEMAND_FLAG NUMBER

Aggregate demand flag
SR_CUST_ACCOUNT_NUMBER VARCHAR2 (240)
CUST_ACCOUNT_NUMBER
RESOURCE_TYPE NUMBER

Resource Type
Query Text

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


SELECT SR_TP_ID
,      SR_INSTANCE_ID
,      PARTNER_TYPE
,      TP_ID
,      SR_COMPANY_ID
,      AGGREGATE_DEMAND_FLAG
,      SR_CUST_ACCOUNT_NUMBER
,      RESOURCE_TYPE
FROM MSC.MSC_TP_ID_LID;

Dependencies

[top of page]

MSC.MSC_TP_ID_LID does not reference any database object

MSC.MSC_TP_ID_LID is referenced by following:

SchemaAPPS
SynonymMSC_TP_ID_LID