1. Tables and Views for SCM
  2. MSS_WO_OPERATIONS

MSS_WO_OPERATIONS

This table stores work order operation information.

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSS_WO_OPERATIONS_PK

PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER

Columns

Name Datatype Length Precision Not-null Comments
PLAN_ID NUMBER 18 Yes Identifier of the Production Scheduling plan.
WORK_ORDER_ID NUMBER 18 Yes Foreign Key reference to the work order header table MSS_WORK_ORDERS.
WO_OPERATION_ID NUMBER 18 Yes Indirect foreign key to WIE_WO_OPERATIONS_B
RESOURCE_SEQ_NUMBER NUMBER Yes Resource sequence number of the work order operation.
OPERATION_SEQ_NUMBER NUMBER Yes Operation Sequence Number. This is the user key in defining the order of the operations within the work order.
WORK_CENTER_ID NUMBER 18 Yes Indicates the Work Center Identifier.
WD_OPERATION_ID NUMBER 18 Work Definition Operation reference.
STANDARD_OPERATION_ID NUMBER 18 Reference to the standard operation. If an operation in the work order is created by referencing the standard operation, this column value will be populated.
OPERATION_CODE VARCHAR2 300 Code of the work order operation.
OPERATION_NAME VARCHAR2 120 Display name of the work order operation.
OPERATION_TYPE VARCHAR2 30 Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup.
EXECUTION_SEQUENCE NUMBER Indicates the execution sequence of the operation if the work order has re-sequence operations.
SUPPLIER_ID NUMBER 18 Represents the identifier of the suggested supplier for a supplier operation.
SUPPLIER_SITE_ID NUMBER 18 Represents the identifier of the suggested supplier site for a supplier operation.
SUPPLIER_NAME VARCHAR2 360 Name of the supplier for a supplier operation.
SUPPLIER_SITE_CODE VARCHAR2 240 Code of the supplier site for a supplier operation.
STATUS VARCHAR2 30 Yes Operation status: Open|Active|Closed
YIELD NUMBER Yield percentage of the work order operation.
FIRM_STATUS VARCHAR2 30 Operation firm status: 'Firm Start'|'Firm End'|'Firm Range'. The operation is not firmed if this is not specified.
COMPLETED_QUANTITY NUMBER Quantity completed so far in the work order. Relates to the work order planned start quantity.
SCRAPPED_QUANTITY NUMBER Quantity that is scrapped in the work order. Relates to the work order planned start quantity.
REJECTED_QUANTITY NUMBER Quantity that is rejected in the work order. Relates to the work order planned start quantity.
START_DATE TIMESTAMP Earliest start date or firm start date of the operation.
END_DATE TIMESTAMP Latest end date or firm end date of the operation.
ACTUAL_START_DATE TIMESTAMP Work order operation actual start date.
ACTUAL_END_DATE TIMESTAMP Work order operation actual end date.
SCHEDULED_START_DATE TIMESTAMP PS scheduled start date of this operation.
SCHEDULED_END_DATE TIMESTAMP PS scheduled completion date of this operation.
SCHEDULED_DURATION NUMBER PS scheduled duration of this operation.
SCHEDULED_DURATION_UNIT VARCHAR2 30 PS scheduled duration unit: seconds|minutes|hours|days|weeks.
DURATION_RES_ID NUMBER 18 Planned duration resource ID, if there are no alternate resources. Foreign key to MSS_RESOURCES.
DURATION_RES_SET_CODE VARCHAR2 100 Duration resource set code as defined in MSS_OP_RESOURCE_SET_MEMBERS, which is only set when duration resources are in a resource set.
LOT_MULTIPLE_RES_ID NUMBER 18 Planned lot multiple resource ID, if there are no alternate resources. Foreign key to MSS_RESOURCES.
LOT_MULTIPLE_RES_SET_CODE VARCHAR2 100 Lot multiple resource set code as defined in MSS_OP_RESOURCE_SET_MEMBERS, which is only set when lot multiple resources are in a resource set.
SUPPLY_RESERVATIONS_FLAG VARCHAR2 1 Flag that indicates that the work order operation has reservations on upstream supplies: Y|N.
CHANGED_BY_LAST_REPAIR VARCHAR2 1 Changed by last repair solve (Y/N)?
CHANGED_SINCE_LAST_SOLVE VARCHAR2 1 Changed by repair solves since last cold solve (Y/N)?
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_WO_OPERATIONS mss_work_orders PLAN_ID, WORK_ORDER_ID
MSS_WO_OPERATIONS mss_resources PLAN_ID, WORK_CENTER_ID, DURATION_RES_ID
MSS_WO_OPERATIONS mss_resources PLAN_ID, WORK_CENTER_ID, LOT_MULTIPLE_RES_ID
mss_wo_temporal_relations mss_wo_operations PLAN_ID, FROM_WO_OPERATION_ID, FROM_RESOURCE_SEQ_NUMBER
mss_wo_temporal_relations mss_wo_operations PLAN_ID, TO_WO_OPERATION_ID, TO_RESOURCE_SEQ_NUMBER
mss_wo_op_attribute_values mss_wo_operations PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER
mss_wo_operation_resources mss_wo_operations PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER
mss_wo_reschedule_commands mss_wo_operations PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER
mss_wo_operation_materials mss_wo_operations PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER
mss_changeover_instances mss_wo_operations PLAN_ID, FROM_WO_OPERATION_ID, FROM_RESOURCE_SEQ_NUMBER
mss_changeover_instances mss_wo_operations PLAN_ID, TO_WO_OPERATION_ID, TO_RESOURCE_SEQ_NUMBER

Indexes

Index Uniqueness Tablespace Columns
MSS_WO_OPERATIONS_N1 Non Unique Default PLAN_ID, WORK_CENTER_ID, DURATION_RES_ID
MSS_WO_OPERATIONS_N2 Non Unique Default PLAN_ID, WORK_CENTER_ID, LOT_MULTIPLE_RES_ID
MSS_WO_OPERATIONS_U1 Unique Default PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER
MSS_WO_OPERATIONS_U2 Unique Default PLAN_ID, WORK_ORDER_ID, OPERATION_SEQ_NUMBER, RESOURCE_SEQ_NUMBER