[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_APPS_INSTANCES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This is the interface table to load the profile option values via Legacy Collections
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSC_ORG_FOR_BOM_EXPLOSION | VARCHAR2 | (7) | Organization Identifier for BOM Explosion | |
WSM_CREATE_LBJ_COPY_ROUTING | NUMBER | Source side value of the profile option - WSH: Create Lot Based Job Copy Routing | ||
DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | ||
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 | ||
DATA_SOURCE_TYPE | VARCHAR2 | (10) | Source type indicates source of records BATCH/XML | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
ST_TRANSACTION_ID | NUMBER | Transaction id generated during pre-processing to uniquely identify the records | ||
REFRESH_ID | NUMBER | Refresh number | ||
ERROR_TEXT | VARCHAR2 | (2000) | Error text | |
MESSAGE_ID | NUMBER | To identify the records got via XML | ||
CREATED_BY | NUMBER | Standard Who column | ||
SR_INSTANCE_CODE | VARCHAR2 | (3) | Source instance code | |
SR_INSTANCE_ID | NUMBER | Source instance identifier | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
VALIDATION_ORG_ID | NUMBER | Validation org id |
Cut, paste (and edit) the following text to query this object:
SELECT MSC_ORG_FOR_BOM_EXPLOSION
, WSM_CREATE_LBJ_COPY_ROUTING
, DELETED_FLAG
, PROCESS_FLAG
, DATA_SOURCE_TYPE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, CREATION_DATE
, ST_TRANSACTION_ID
, REFRESH_ID
, ERROR_TEXT
, MESSAGE_ID
, CREATED_BY
, SR_INSTANCE_CODE
, SR_INSTANCE_ID
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, VALIDATION_ORG_ID
FROM MSC.MSC_ST_APPS_INSTANCES;
MSC.MSC_ST_APPS_INSTANCES does not reference any database object
MSC.MSC_ST_APPS_INSTANCES is referenced by following:
|
|
|