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

TABLE: MSC.MSC_ST_BOM_COMPONENTS

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

The staging table used by the collection program to valid and process data for table MSC_BOM_COMPONENTS.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER

Component identifier on the source application instance
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Identifier of the component item
USING_ASSEMBLY_ID NUMBER

Identifier of the item being assembled
BILL_SEQUENCE_ID NUMBER

Identifier of the BOM
COMPONENT_TYPE NUMBER

Component (1), Ingredient component (-1), by-product (2)
SCALING_TYPE NUMBER

Scaling type
CHANGE_NOTICE VARCHAR2 (10)
Code for ECO. Use for UI and reporting
REVISION VARCHAR2 (3)
Inventory item revision code
UOM_CODE VARCHAR2 (3)
Unit of measure code
USAGE_QUANTITY NUMBER

Quantity of the component to build one unit of item
EFFECTIVITY_DATE DATE

Date of effectivity for this component
DISABLE_DATE DATE

End of effectivity
FROM_UNIT_NUMBER VARCHAR2 (30)
Effective from this unit number
TO_UNIT_NUMBER VARCHAR2 (30)
Effective up to this unit number
USE_UP_CODE NUMBER

Yes/No flag indicating whether the component is effective
SUGGESTED_EFFECTIVITY_DATE DATE

Calculated use-up-date (if Use-up-code is yes)
DRIVING_ITEM_ID NUMBER

Item which consumption determine the switch to this component
OPERATION_OFFSET_PERCENT NUMBER

Operation offset percent
OPTIONAL_COMPONENT NUMBER

Yes/No flag - if optional use planning factor to determine demand
OLD_EFFECTIVITY_DATE DATE

Old effectivity date
WIP_SUPPLY_TYPE NUMBER

Used mainly for phantoms
PLANNING_FACTOR NUMBER

Planning factor for this component (percent)
ATP_FLAG NUMBER

Yes/No flag used for ATP
COMPONENT_YIELD_FACTOR NUMBER

Factor used to multiply component quantity with to obtain component quantity
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised item sequence identifier
STATUS_TYPE NUMBER

Status type
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
BOM_NAME VARCHAR2 (250)
BOM Name. If this is empty during uploads then it would be replaced by ASSEMBLY_NAME
ORGANIZATION_CODE VARCHAR2 (7)
Organization Identifier
ASSEMBLY_NAME VARCHAR2 (250)
Assembly Name. This has to be provided for uploads from legacy.
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
COMPONENT_NAME VARCHAR2 (250)
Component Name
OPERATION_SEQ_CODE VARCHAR2 (10)
Operation Sequence Code. This has to be provided during loads from legacy to help link this component to a routing operation.
DRIVING_ITEM_NAME VARCHAR2 (250)
Item Name whose consumption determines whether to switch to this component or not
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (40)
Alternate BOM's Reference
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
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.
DATA_SOURCE_TYPE VARCHAR2 (15)
Source type indicates the source of data, BATCH/XML
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
SCALE_MULTIPLE NUMBER

Scale Multiple
SCALE_ROUNDING_VARIANCE NUMBER

Scale Rounding Variance
ROUNDING_DIRECTION NUMBER

Rounding Direction
PRIMARY_FLAG NUMBER

Primary Flag Indicator
SOURCE_ORGANIZATION_ID NUMBER

SOURCE_BILL_SEQUENCE_ID NUMBER

SOURCE_COMPONENT_SEQUENCE_ID NUMBER

SOURCE_USING_ASSEMBLY_ID NUMBER

SOURCE_INVENTORY_ITEM_ID NUMBER

SOURCE_DRIVING_ITEM_ID NUMBER

CONTRIBUTE_TO_STEP_QTY NUMBER

OLD_COMPONENT_SEQUENCE_ID NUMBER

OPERATION_SEQ_NUM NUMBER

Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      USING_ASSEMBLY_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_TYPE
,      SCALING_TYPE
,      CHANGE_NOTICE
,      REVISION
,      UOM_CODE
,      USAGE_QUANTITY
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      FROM_UNIT_NUMBER
,      TO_UNIT_NUMBER
,      USE_UP_CODE
,      SUGGESTED_EFFECTIVITY_DATE
,      DRIVING_ITEM_ID
,      OPERATION_OFFSET_PERCENT
,      OPTIONAL_COMPONENT
,      OLD_EFFECTIVITY_DATE
,      WIP_SUPPLY_TYPE
,      PLANNING_FACTOR
,      ATP_FLAG
,      COMPONENT_YIELD_FACTOR
,      REVISED_ITEM_SEQUENCE_ID
,      STATUS_TYPE
,      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
,      BOM_NAME
,      ORGANIZATION_CODE
,      ASSEMBLY_NAME
,      SR_INSTANCE_CODE
,      COMPONENT_NAME
,      OPERATION_SEQ_CODE
,      DRIVING_ITEM_NAME
,      ALTERNATE_BOM_DESIGNATOR
,      ERROR_TEXT
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      SCALE_MULTIPLE
,      SCALE_ROUNDING_VARIANCE
,      ROUNDING_DIRECTION
,      PRIMARY_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_COMPONENT_SEQUENCE_ID
,      SOURCE_USING_ASSEMBLY_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_DRIVING_ITEM_ID
,      CONTRIBUTE_TO_STEP_QTY
,      OLD_COMPONENT_SEQUENCE_ID
,      OPERATION_SEQ_NUM
FROM MSC.MSC_ST_BOM_COMPONENTS;

Dependencies

[top of page]

MSC.MSC_ST_BOM_COMPONENTS does not reference any database object

MSC.MSC_ST_BOM_COMPONENTS is referenced by following:

SchemaMSC
ViewMSC_ST_BOM_COMPONENTS#