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

TABLE: MSC.MSC_ST_CO_PRODUCTS

Object Details
Object Name: MSC_ST_CO_PRODUCTS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_CO_PRODUCTS
Subobject Name:
Status: VALID


This table is used for collecting the CO Product Bill in Legacy Collections


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COMPONENT_NAME VARCHAR2 (250)
The name of the component for which the co-product is defined
COMPONENT_ID NUMBER

Component identifier
CO_PRODUCT_NAME VARCHAR2 (250)
The co -product name for the component
CO_PRODUCT_ID NUMBER

Co-product identifier
SPLIT NUMBER

The split percentage indicating the percentage of each co-product
PRIMARY_FLAG NUMBER

The promary co-product will have value 1, the non-primary co-product will have value 2
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
DELETED_FLAG NUMBER

This flag indicates whether corresponding record in ODS will be deleted or not. 1-Yes 2-No
SR_INSTANCE_ID NUMBER

Source application instance identifier
COMPANY_NAME VARCHAR2 (255)
Required only for SCE. should provide the party name with which the company is registered on Exchange.
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
SR_INSTANCE_CODE VARCHAR2 (3)
Source instance code defined on planning server
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-Sucessfully Processed.
ERROR_TEXT VARCHAR2 (2000)
Pre-defined error text generated by the pre-processor
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.
REFRESH_ID NUMBER

Refresh Id of last collections
LAST_UPDATED_BY NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
CO_PRODUCT_GROUP_ID NUMBER

Co Product Group Id
SOURCE_COMPONENT_ID NUMBER

This is the Component ID for the Component 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_CO_PRODUCT_ID NUMBER

This is the Product ID for the Co Product 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_CO_PRODUCT_GROUP_ID NUMBER

This is the Product Group ID for the Co Product Group 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.
Query Text

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


SELECT COMPONENT_NAME
,      COMPONENT_ID
,      CO_PRODUCT_NAME
,      CO_PRODUCT_ID
,      SPLIT
,      PRIMARY_FLAG
,      ORGANIZATION_CODE
,      DELETED_FLAG
,      SR_INSTANCE_ID
,      COMPANY_NAME
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      ERROR_TEXT
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      REFRESH_ID
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CO_PRODUCT_GROUP_ID
,      SOURCE_COMPONENT_ID
,      SOURCE_CO_PRODUCT_ID
,      SOURCE_CO_PRODUCT_GROUP_ID
FROM MSC.MSC_ST_CO_PRODUCTS;

Dependencies

[top of page]

MSC.MSC_ST_CO_PRODUCTS does not reference any database object

MSC.MSC_ST_CO_PRODUCTS is referenced by following:

SchemaMSC
ViewMSC_ST_CO_PRODUCTS#