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

Copyright © 2019, 2024, Oracle and/or its affiliates.