[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_CATEGORY_SETS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_ST_CATEGORY_SETS |
Subobject Name: | |
Status: | VALID |
The staging table used by the collection program to validate and process
data for table MSC_CATEGORY_SETS.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_SET_ID | NUMBER | Category set identifier | ||
SR_CATEGORY_SET_ID | NUMBER | Category set identifier from source application instance | ||
CATEGORY_SET_NAME | VARCHAR2 | (30) | Category set name | |
DESCRIPTION | VARCHAR2 | (240) | Category set description | |
CONTROL_LEVEL | NUMBER | Control level | ||
DEFAULT_FLAG | NUMBER | Default flag | ||
DELETED_FLAG | NUMBER | Yes/No flag indicating whether the row will be deleted | ||
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 | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
REFRESH_ID | NUMBER | Refresh identifier | ||
COMPANY_ID | NUMBER | Company identifier | ||
COMPANY_NAME | VARCHAR2 | (255) | Company name | |
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 | ||
DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source Type indicating the source of data | |
ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
SOURCE_SR_CATEGORY_SET_ID | NUMBER | This is the Category Set ID for the Category Set 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 CATEGORY_SET_ID
, SR_CATEGORY_SET_ID
, CATEGORY_SET_NAME
, DESCRIPTION
, CONTROL_LEVEL
, DEFAULT_FLAG
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID
, REFRESH_ID
, COMPANY_ID
, COMPANY_NAME
, SR_INSTANCE_CODE
, MESSAGE_ID
, PROCESS_FLAG
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, ERROR_TEXT
, BATCH_ID
, SOURCE_SR_CATEGORY_SET_ID
FROM MSC.MSC_ST_CATEGORY_SETS;
MSC.MSC_ST_CATEGORY_SETS does not reference any database object
MSC.MSC_ST_CATEGORY_SETS is referenced by following:
|
|
|