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.
WORK_ORDER_ASSET_ID NUMBER 38 0 To be deprecated in the future.
ASSET_ID NUMBER 38 0 To be deprecated in the future.
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_METHOD_CODE VARCHAR2 32 Work method code
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