[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_LOCATION_ASSOCIATIONS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_ST_LOCATION_ASSOCIATIONS |
Subobject Name: | |
Status: | VALID |
The staging table used by the collection program to validate and process data for table MSC_LOCATION_ASSOCIATIONS.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_ID | NUMBER | Location identifer | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
LOCATION_CODE | VARCHAR2 | (60) | Location code | |
ORGANIZATON_ID | NUMBER | Organization identifier | ||
PARTNER_ID | NUMBER | Partner identifier | ||
PARTNER_SITE_ID | NUMBER | Partner site identifier | ||
SR_TP_ID | NUMBER | Trading partner identifer from source application | ||
SR_TP_SITE_ID | NUMBER | Trading partner site site identifer from source application | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
REQUEST_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
ORGANIZATION_ID | NUMBER | Organization identifer | ||
REFRESH_ID | NUMBER | Refresh identifer | ||
PARTNER_TYPE | NUMBER | Partner type | ||
COMPANY_ID | NUMBER | Company identifier | ||
COMPANY_NAME | VARCHAR2 | (255) | Company name | |
PARTNER_NAME | VARCHAR2 | (255) | Name of the supplier or customer | |
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization code | |
TP_SITE_CODE | VARCHAR2 | (30) | Trading partner site code | |
SR_INSTANCE_CODE | VARCHAR2 | (3) | Source Instance Code | |
MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | ||
PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
DELETED_FLAG | NUMBER | Deleted Flag | ||
DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source Type indicating the source of the records | |
ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
SOURCE_SR_TP_ID | NUMBER | This is the Trading Partner ID for the Trading Partner in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
SOURCE_SR_TP_SITE_ID | NUMBER | This is the Trading Partner Site ID for the Trading Partner Site in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
SOURCE_LOCATION_ID | NUMBER | This is the Location ID for the Location in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_ID
, SR_INSTANCE_ID
, LOCATION_CODE
, ORGANIZATON_ID
, PARTNER_ID
, PARTNER_SITE_ID
, SR_TP_ID
, SR_TP_SITE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORGANIZATION_ID
, REFRESH_ID
, PARTNER_TYPE
, COMPANY_ID
, COMPANY_NAME
, PARTNER_NAME
, ORGANIZATION_CODE
, TP_SITE_CODE
, SR_INSTANCE_CODE
, MESSAGE_ID
, PROCESS_FLAG
, DELETED_FLAG
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, BATCH_ID
, ERROR_TEXT
, SOURCE_SR_TP_ID
, SOURCE_SR_TP_SITE_ID
, SOURCE_LOCATION_ID
FROM MSC.MSC_ST_LOCATION_ASSOCIATIONS;
MSC.MSC_ST_LOCATION_ASSOCIATIONS does not reference any database object
MSC.MSC_ST_LOCATION_ASSOCIATIONS is referenced by following:
|
|
|