1. Tables and Views for SCM
  2. MSS_WORK_ORDERS

MSS_WORK_ORDERS

This table stores the work order header information.

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSS_WORK_ORDERS_PK

PLAN_ID, WORK_ORDER_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PLAN_ID NUMBER 18 Yes Identifier of the Production Scheduling plan.
WORK_ORDER_ID NUMBER 18 Yes Indirect foreign key to WIE_WORK_ORDERS_B
WORK_ORDER_NUMBER VARCHAR2 300 Yes User defined Work Order Number.
SP_SUPPLY_ID NUMBER 18 Planned order transaction ID, indirect foreign key field to MSC_SUPPLIES table.
WORK_METHOD_ID NUMBER 18 Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. Required in the source schema.
WORK_METHOD_CODE VARCHAR2 30 A code that represents the user key to the work method. Required in the source schema.
WORK_METHOD_NAME VARCHAR2 120 Indicates the name of the work method. Required in the source schema.
WORK_ORDER_TYPE VARCHAR2 30 Yes Indicates the type of this work order: Production|Maintenance|EAM.
WORK_ORDER_TYPE_CODE VARCHAR2 30 Indicates the type of this work order. Values are contained within the ORA_WIE_WO_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_TYPE lookup.
WORK_ORDER_TYPE_NAME VARCHAR2 80 Indicates the type name of this work order.
WORK_ORDER_SUB_TYPE_CODE VARCHAR2 30 Indicates the subtype of this work order. Values are contained in the ORA_WIE_WO_SUB_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_SUB_TYPE lookup.
WORK_ORDER_SUB_TYPE_NAME VARCHAR2 80 Indicates the subtype name of this work order.
DESCRIPTION VARCHAR2 500 Indicates the description of the work order.
INVENTORY_ITEM_ID NUMBER 18 Foreign key to MSS_INVENTORY_ITEMS.
WORK_DEFINITION_ID NUMBER 18 Indirect foreign key reference to the work definition.
WD_VERSION_NUMBER VARCHAR2 10 Indicates the version of the work definition, stored as string.
ROUTING_CODE VARCHAR2 300 Code of the work definition for this work order.
ORDER_CLASS VARCHAR2 20 Order class: HotOrder|Committed|Uncommitted
WORK_ORDER_PRIORITY NUMBER Translated value from the user defined Work Order Priority.
MATERIAL_AVAILABLE VARCHAR2 30 Material availability status: 'Fully Assigned'|'Partially Assigned'|'Unassigned'. Materials not assigned if this is not specified.
WORK_ORDER_STATUS VARCHAR2 30 User defined status of the work order.
ON_HOLD_FLAG VARCHAR2 1 On-hold flag of the work order (Y/N).
UOM_CODE VARCHAR2 3 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. Required in the source schema.
UOM_NAME VARCHAR2 25 Translatable Unit of Measure name.
PLANNED_START_QUANTITY NUMBER Yes 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. This represents the Batch Quantity for Process work orders.
PRIMARY_PRODUCT_QUANTITY NUMBER Represents the output quantity of the primary product used to create the work order.
PRIMARY_PRODUCT_UOM_CODE VARCHAR2 3 Represents the unit of measure code of the primary product used to create the work order. Obsolete
COMPLETED_QUANTITY NUMBER Quantity completed so far in the work order. Relates to the planned start quantity.
SCRAPPED_QUANTITY NUMBER Quantity that is scrapped in the work order. Relates to the planned start quantity.
REJECTED_QUANTITY NUMBER Quantity that is rejected in the work order. Relates to the planned start quantity.
REMAINING_QUANTITY NUMBER Quantity that is remaining in the work order. Relates to the planned start quantity.
PRIMARY_PRODUCT_REMAINING_QTY NUMBER Primary product quantity remaining in the work order, scaled to primary product unit of measure. This is equal to the remaining quantity, except for process work orders with a distinct primary product UOM.
RESERVED_QUANTITY NUMBER Total quantity reserved to downstream demands.
FIRM_PLANNED_FLAG VARCHAR2 1 Yes Flag to allow or prevent Planning from suggesting rescheduling and re-planning recommendations with respect to the Work Order.
RESCHEDULED_FLAG VARCHAR2 1 Flag to indicate if the work order is rescheduled.
SELECTED_FOR_RELEASE_FLAG VARCHAR2 1 Flag to indicate if the work order is selected for release.
SCHEDULED_START_DATE TIMESTAMP PS scheduled start date of the work order.
SCHEDULED_END_DATE TIMESTAMP PS Scheduled completion date of the work order.
ACTUAL_START_DATE TIMESTAMP Actual start date of the work order.
ACTUAL_END_DATE TIMESTAMP Actual completion date of the work order.
REQUESTED_DATE TIMESTAMP Yes Requested date of the work order.
EARLIEST_START_DATE TIMESTAMP Earliest start date of the work order
TARGET_COMPLETION_DATE TIMESTAMP Target completion date of the work order
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
MSS_WORK_ORDERS mss_items PLAN_ID, INVENTORY_ITEM_ID
mss_wo_assets mss_work_orders PLAN_ID, WORK_ORDER_ID
mss_work_orders_demands mss_work_orders PLAN_ID, WORK_ORDER_ID
mss_wo_operations mss_work_orders PLAN_ID, WORK_ORDER_ID

Indexes

Index Uniqueness Tablespace Columns
MSS_WORK_ORDERS_N1 Non Unique Default PLAN_ID, INVENTORY_ITEM_ID
MSS_WORK_ORDERS_U1 Unique Default PLAN_ID, WORK_ORDER_ID
MSS_WORK_ORDERS_U2 Unique Default PLAN_ID, WORK_ORDER_NUMBER