[Home] [Help] [Dependency Information]
Object Name: | MSC_COMPANY_SITE_ID_LID |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_COMPANY_SITE_ID_LID |
Subobject Name: | |
Status: | VALID |
This table contains the link between the company site identifier in the source and the company site identifier generated in APS. This table is ppulated and used by the Collections program.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_COMPANY_SITE_ID_LID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SR_INSTANCE_ID
SR_COMPANY_ID SR_COMPANY_SITE_ID PARTNER_TYPE |
MSC_COMPANY_SITE_ID_LID_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMPANY_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
SR_COMPANY_ID | NUMBER | Yes | Source application company identifier | |
SR_COMPANY_SITE_ID | NUMBER | Yes | Source application company site identifier | |
COMPANY_SITE_ID | NUMBER | Yes | Company site identifier | |
PARTNER_TYPE | NUMBER | Yes | Partner type |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INSTANCE_ID
, SR_COMPANY_ID
, SR_COMPANY_SITE_ID
, COMPANY_SITE_ID
, PARTNER_TYPE
FROM MSC.MSC_COMPANY_SITE_ID_LID;
MSC.MSC_COMPANY_SITE_ID_LID does not reference any database object
MSC.MSC_COMPANY_SITE_ID_LID is referenced by following:
|
|
|