DW_MFG_OPERATION_SUBSTITUTE_MATERIALS_MAP_G (Preview)

This table requires activation of Manufacturing functional area. This table stores Work Order Operation Material Substitute Item Details

Details

Module:

Key Columns

WO_OPERATION_SUBSTITUTE_MATERIAL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
WO_OPERATION_SUBSTITUTE_MATERIAL_ID NUMBER 38 0 True The unique identifier of the work order operation substitute material record
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Generated
CREATION_DATE TIMESTAMP Creation timestamp of the work order operation substitute material record
LAST_UPDATE_DATE TIMESTAMP Last update timestamp of the work order operation substitute material record
WORK_ORDER_ID NUMBER 38 0 The unique identifier of work order record DW_MFG_WORK_ORDERS_TL WORK_ORDER_ID
WORK_ORDER_NUMBER VARCHAR2 128 Represents the user-facing identifier of the work order.
WO_INVENTORY_ITEM_ID NUMBER 38 0 Work Order Item to be Manufactured #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
WO_OPERATION_ID NUMBER 38 0 The unique identifier of the operation that uses this material. DW_MFG_OPERATIONS_TL WO_OPERATION_ID
OPERATION_SEQ_NUMBER NUMBER Operation sequence number
WO_OPERATION_MATERIAL_ID NUMBER 38 0 The unique identifier of the Operation Material.
MATERIAL_SEQ_NUMBER NUMBER Material sequence number
WO_OPERATION_MATERIAL_ITEM_ID NUMBER 38 0 The unique identifier of the material used in the operation. #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ORGANIZATION_ID NUMBER 38 0 The manufacturing plant identifier for which the operation material substitute is defined. DW_INTERNAL_ORG_D ORGANIZATION_ID
WO_OPERATION_MATERIAL_SUBSTITUTE_FLAG VARCHAR2 16 Flag used indicate whether this Operation Material is a substituted item or not
INVENTORY_ITEM_ID NUMBER 38 0 Represents the identifier of the substitute material #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
SUBSTITUTE_FLAG VARCHAR2 16 Flag used indicate whether this component is a substitute or not. Valid values: Y - Substitute N - Primary component
UOM_CODE VARCHAR2 16 Represents the unit of measure code of the specified quantity DW_UNIT_OF_MEASURE_D_TL UOM_CODE
QUANTITY_PER_PRODUCT NUMBER Represents the item quantity per assembly for the substitute material/component
REQUIRED_QUANTITY NUMBER Represents the total item quantity for the substitute material/component
INVERSE_QUANTITY NUMBER Represents the inverse item quantity for the substitute material/component
PRIORITY_RANKING NUMBER Indicates the order of preference.

Notes

#1 In these cases in addition to the Item column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D