DW_MFG_WORK_ORDERS_CF (Preview)

This table requires activation of Manufacturing functional area. This table stores information about work order details. It identifies the primary product and can optionally refer to the Item Structure used to define material requirements.

Details

Module:

Key Columns

WORK_ORDER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
WORK_ORDER_ID NUMBER 38 0 True The unique identifier of work order record DW_MFG_WORK_ORDERS_TL WORK_ORDER_ID
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. System Generated    
WORK_ORDER_NUMBER VARCHAR2 128     Represents the user-facing identifier of the work order.    
INVENTORY_ITEM_ID NUMBER 38 0   Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ORGANIZATION_ID NUMBER 38 0   The organization identifier that represents the manufacturing plant to which this work order belongs. DW_INTERNAL_ORG_D ORGANIZATION_ID
BUSINESS_UNIT_ID NUMBER 38 0   Business unit for the manufacturing plant DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEDGER_ID NUMBER 38 0   Ledger associated to the business unit DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_TYPE VARCHAR2 16     Fiscal period type #2 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Fiscal period name. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity for the manufacturing plant DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
WORK_METHOD_ID NUMBER 38 0   Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. DW_MFG_WORK_METHODS_TL WORK_METHOD_ID
WORK_ORDER_TYPE_CODE VARCHAR2 32     Indicates the type of this work order. #3 DW_ORA_WIE_WO_TYPE_LKP_TL ORA_WIE_WO_TYPE_CODE
WORK_ORDER_SUB_TYPE_CODE VARCHAR2 32     The subtype specifically will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. #4 DW_ORA_WIE_WO_SUB_TYPE_LKP_TL ORA_WIE_WO_SUB_TYPE_CODE
WORK_ORDER_STATUS_ID NUMBER 38 0   Represents the internal identifier of the user-defined status of the work order. DW_MFG_STATUSES_TL WO_STATUS_ID
WORK_ORDER_SYSTEM_STATUS_CODE VARCHAR2 32     Represents the system status code for a given work order status. DW_ORA_WIE_WO_SYSTEM_STATUS_LKP_TL ORA_WIE_WO_SYSTEM_STATUS_CODE
SCHEDULING_METHOD_CODE VARCHAR2 32     Indicates the scheduling method for this work order. DW_ORA_WIE_WO_SCHEDULING_METHOD_LKP_TL ORA_WIE_WO_SCHEDULING_METHOD_CODE
PLANNED_START_DATE DATE       Planned start date of the work order without timestamp DW_DAY_D CALENDAR_DATE
PLANNED_START_TIMESTAMP TIMESTAMP       Planned start date of the work order with timestamp    
ACTUAL_START_DATE DATE       Actual start date of the work order without timestamp DW_DAY_D CALENDAR_DATE
ACTUAL_START_TIMESTAMP TIMESTAMP       Actual start date of the work order with timestamp    
RELEASED_DATE DATE       Date when the work order is released, without timestamp DW_DAY_D CALENDAR_DATE
RELEASED_TIMESTAMP TIMESTAMP       Date when the work order is released, with timestamp    
PLANNED_COMPLETION_DATE DATE       Planned completion date of the work order without timestamp DW_DAY_D CALENDAR_DATE
PLANNED_COMPLETION_TIMESTAMP TIMESTAMP       Planned completion date of the work order with timestamp    
ACTUAL_COMPLETION_DATE DATE       Actual completion date of the work order without timestamp DW_DAY_D CALENDAR_DATE
ACTUAL_COMPLETION_TIMESTAMP TIMESTAMP       Actual completion date of the work order with timestamp    
CLOSED_DATE DATE       Date when the work order is closed, without timestamp DW_DAY_D CALENDAR_DATE
CLOSED_TIMESTAMP TIMESTAMP       Date when the work order is closed, with timestamp    
CANCELED_DATE DATE       Date when the work order is canceled, without timestamp DW_DAY_D CALENDAR_DATE
CANCELED_TIMESTAMP TIMESTAMP       Date when the work order is canceled, with timestamp    
CANCELED_REASON VARCHAR2 256     Cancellation Reason    
WORK_DEFINITION_ID NUMBER 38 0   Unique identifier to the work definition    
WORK_DEFINITION_VERSION_ID NUMBER 38 0   Work definition version identifier    
PJC_PROJECT_ID NUMBER 38 0   Identifier of the project used for project-related transaction distributions DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0   Identifier of the task used for project-related transaction distributions DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0   Identifier of the expenditure type used for project-related transaction distributions DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE DATE       Date on which a project-related transaction is incurred. DW_DAY_D CALENDAR_DATE
PJC_ORGANIZATION_ID NUMBER 38 0   Identifier of the expenditure organization used for project-related transaction distributions DW_INTERNAL_ORG_D ORGANIZATION_ID
CREATION_DATE TIMESTAMP       Work order creation date    
LAST_UPDATE_DATE TIMESTAMP       Work order last update date    
UOM_CODE VARCHAR2 16     Represents the unit of measure code. The assembly quantity will be produced in this UOM. The transactions that moves the assembly from operation to operation and also eventually the completions will be performed in this UOM. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PLANNED_START_QUANTITY NUMBER       Refers to the planned work order quantity which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders    
COMPLETED_QUANTITY NUMBER       Primary product quantity completed so far in the work order.    
SCRAPPED_QUANTITY NUMBER       Primary product quantity that is scrapped in the work order.    
REJECTED_QUANTITY NUMBER       Primary product quantity that is rejected in the work order.    
PUOM_CODE VARCHAR2 16     Primary UOM code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_CONVERSION_FACTOR NUMBER       Transaction UOM to Primary UOM conversion factor    
PUOM_PLANNED_START_QUANTITY NUMBER       Refers to the planned work order quantity in primary UOM which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders    
PUOM_COMPLETED_QUANTITY NUMBER       Primary product quantity completed so far in the work order in primary UOM.    
PUOM_SCRAPPED_QUANTITY NUMBER       Primary product quantity that is scrapped in the work order in primary UOM.    
PUOM_REJECTED_QUANTITY NUMBER       Primary product quantity that is rejected in the work order in primary UOM.    
HISTORIC_REJECT_FLAG VARCHAR2 16     Flag to denote whether any reject operation transaction happened on work order or not    
HISTORIC_REJECT_QUANTITIES NUMBER       Aggregated value of transaction quantities of all reject operation transactions    
PUOM_HISTORIC_REJECT_QUANTITIES NUMBER       Aggregated value of primary UOM quantities of all reject operation transactions    
WORK_ORDER_DATE DATE       Stores Planned Start Date for Unreleased Work Orders and Released Date for Released Work Orders. Used in joining with Fiscal Dates #2 DW_DAY_D CALENDAR_DATE
PRIMARY_PRODUCT_UOM_CODE VARCHAR2 16     Represents the unit of measure code of the primary product used to create the work order DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PRIMARY_PRODUCT_PUOM_CONVERSION_FACTOR NUMBER       Primary Product UOM to Primary UOM conversion factor    
PRIMARY_PRODUCT_QUANTITY NUMBER       Represents the output quantity of the primary product used to create the work order    
PUOM_PRIMARY_PRODUCT_QUANTITY NUMBER       Represents the output quantity of the primary product used to create the work order in Primary UOM    
BACK_TO_BACK_FLAG VARCHAR2 16     Flag to indicate that the work order is created as a result of a back-to-back flow DW_YN_LKP_TL YN_LKP_CODE
CONTRACT_MFG_FLAG VARCHAR2 16     Flag to indicate that the work order is a contract manufacturing work order DW_YN_LKP_TL YN_LKP_CODE
CM_PO_HEADER_ID NUMBER 38 0   Represents the internal identifier of the contract manufacturer's purchase order    
CM_PO_LINE_ID NUMBER 38 0   The reference to the contract manufacturer's PO line identifier    
CM_PO_LINE_LOC_ID NUMBER 38 0   The reference to the contract manufacturer's PO schedule line reference    
SOURCE_HEADER_REF_ID NUMBER 38 0   Represents the source system's internal header reference identifier    
SOURCE_LINE_REF_ID NUMBER 38 0   Represents the source system's internal line reference identifier    
BEHIND_PLAN_RATIO BIGDECIMAL   10   This is the ratio of quantities by which Work Order is lagging to the planned start quantity in primary UOM    
UNDER_COMPLETED_FLAG VARCHAR2 16     Flag to indicate that the work order is marked as under-completed DW_YN_LKP_TL YN_LKP_CODE
WORK_ORDER_PRIORITY NUMBER       Used to set the priority of the work order depending on the demand that needed to be prioritized.    
FIRM_PLANNED_FLAG VARCHAR2 16     Flag to allow or prevent Planning from suggesting rescheduling and re-planning recommendations with respect to the Work Order. When the flag is on, this work order will not be considered by MRP to reschedule or re-plan.    
RESEQUENCE_FLAG VARCHAR2 16     Flag used to indicate if the work order has operations which can be re-sequenced while executing the operation. Valid values are Y or N.    

Notes

#1 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on WORK_ORDER_DATE column #3 Dimensional Reference for WORK_ORDER_TYPE_CODE is derived from DW_ORA_WIE_WO_TYPE_LKP_TL lookup in case this work order is a manufacturing work order and DW_ORA_MNT_WO_TYPE_LKP_TL lookup when it is a maintenance work order #4 Dimensional Reference for WORK_ORDER_SUB_TYPE_CODE is derived from DW_ORA_WIE_WO_SUB_TYPE_LKP_TL lookup in case this work order is a manufacturing work order and DW_ORA_MNT_WO_SUB_TYPE_LKP_TL lookup when it is a maintenance work order

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