WIE_WO_OPERATIONS_B_GT
This is a global temporary table that is to capture shadow records of work order operation
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_WO_OPERATIONS_B_GT_PK |
TEMPORARY_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPORARY_ROW_ID | NUMBER | Yes | Unique id of work order operation shadow record | ||
| WO_OPERATION_ID | NUMBER | 18 | This is the internal Work Order Operation identifier | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORGANIZATION_ID | NUMBER | 18 | The manufacturing plant identifier. | ||
| WORK_ORDER_ID | NUMBER | 18 | Foreign Key reference to the work order header table. | ||
| OPERATION_TYPE | VARCHAR2 | 30 | Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup. | ||
| OPERATION_SEQ_NUMBER | NUMBER | Operation Sequence Number. This is the user key in defining the order of the operations within the work order. | |||
| 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. | ||
| WORK_CENTER_ID | NUMBER | 18 | Execution Work Center Identifier. | ||
| COUNT_POINT_OPERATION_FLAG | VARCHAR2 | 1 | Count Point operations are operations that are needing user intervention. The quantity of the assembly must move in and out of the operation that is defined as a count point operation | ||
| AUTO_TRANSACT_FLAG | VARCHAR2 | 1 | Indicates whether both resources and material are automatically charged based on the Supply Type or the Charge Type setups for the operation. If the supply type is Operation Pull, the component level issue transactions will happen when the operation is completed. If the supply type is Assembly Pull, the component level issue transactions will happen at the Assembly Completion event. Resource Transaction are automatically done when the Quantity is moved outside the Operation. Valid values are 'Y' and 'N'. | ||
| READY_QUANTITY | NUMBER | Ready Quantity. The qantity that is sitting in the inbound queue of each of the operation. | |||
| COMPLETED_QUANTITY | NUMBER | Primary Product Quantity completed so far in the work order. This is a summary column. | |||
| SCRAPPED_QUANTITY | NUMBER | Primary Product Quantity that is scrapped in the work order. This is a summary column. | |||
| REJECTED_QUANTITY | NUMBER | Primary Product Quantity that is rejected in the work order. This is a summary column. | |||
| PLANNED_START_DATE | TIMESTAMP | Planned start date of this operation. | |||
| PLANNED_COMPLETION_DATE | TIMESTAMP | Planned completion date of this operation. | |||
| ACTUAL_START_DATE | TIMESTAMP | Actual start date of the operation. Currently, this column is not used. | |||
| ACTUAL_COMPLETION_DATE | TIMESTAMP | Actual completion date of the operation. Currently, this column is not used. | |||
| SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Indicates that this is the first operation where the end item begins to be tracked by serial numbers. Valid Values: 'Y' and 'N'. | ||
| PREVIOUS_CP_OP_SEQ_NUM | NUMBER | The previous count point operation sequence number. This is de-normalized to derive defaults upon execution of the operation. Internal Column | |||
| NEXT_CP_OP_SEQ_NUM | NUMBER | The next count point operation sequence number. This is de-normalized to derive defaults upon execution of the operation. Internal Column | |||
| WD_OPERATION_ID | NUMBER | 18 | Work Definition Operation reference. | ||
| SHIPPING_DOCUMENTS_FLAG | VARCHAR2 | 1 | Flag used to determine whether shipping documents need to be generated for a supplier operation. Valid Values: 'Y' and 'N'. | ||
| OSP_ITEM_ID | NUMBER | 18 | Item that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. | ||
| 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. | ||
| LEAD_TIME_UOM | VARCHAR2 | 3 | Represents the unit of measure for the fixed and/or variable lead time values on the supplier operation. | ||
| FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operation’s start and end date for the supplier operation. | |||
| VARIABLE_LEAD_TIME | NUMBER | Represents the variable lead time used to calculate the operation’s start and end date based on the operation quantity for the supplier operation. | |||
| IN_PROCESS_QUANTITY | NUMBER | Quantity in supplier operation that has been completed in the previous count point operation but hasn't been received yet in this operation. | |||
| PO_REQUESTED_QUANTITY | NUMBER | Quantity for which a supply request has been raised with SCO for this supplier operation. | |||
| PO_APPROVED_QUANTITY | NUMBER | Quantity for which an approved PO exists for this supplier operation. | |||
| SHIPPED_QUANTITY | NUMBER | Quantity which has been shipped to the supplier. | |||
| RECEIVED_QUANTITY | NUMBER | Quantity of the partially finished assembly (PFA) that has been delivered to the shopfloor from the supplier. | |||
| OVER_RECEIPT_QUANTITY | NUMBER | The quantity received in excess of the expected quantity for a supplier operation. | |||
| CUMULATIVE_SCRAP_QUANTITY | NUMBER | The total cumulative scrapped quantity up to the current operation, excluding the current operation. | |||
| ADDL_MTL_AT_MANUAL_ISSUE | VARCHAR2 | 30 | Indicates whether or not this operation allows additional materials to be added at manual issue. Valid values exist in the lookup with lookup type = ORA_WIS_ADDL_MANUAL_ISSUE_OPTS. | ||
| OP_COMPL_WITH_UNDER_ISSUE | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with under issued material. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
| OP_COMPL_WITH_OPEN_EXCEPTIONS | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with open exceptions. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
| RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N. | ||
| EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence of the operation if the work order has re-sequence operations. | |||
| TOLLGATE_OP_SEQ_NUM | NUMBER | Used to identify the set of re-sequence operations between two operations. This field is used to help dispatch list pull records efficiently. | |||
| REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the reason for which this repair operation is to be performed. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE_ID | NUMBER | 18 | Represents the code to which this repair transaction is applicable. Foreign key to cse_condition_event_codes_b table. | ||
| WORK_ACCOMPLISHED_CODE_ID | NUMBER | 18 | Represents the accomplishment code to record when the operation is completed. Foreign key to cse_condition_event_codes_b table. | ||
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor which represents the percentage of the starting quantity that is actually yielded at the completion of the operation. The default value is 1 (100%). | |||
| MNT_COMPLETE_FLAG | VARCHAR2 | 1 | Flag indicating whether the operation is soft completed by the maintenance technician. | ||
| VARIANCE_QUANTITY | NUMBER | Batch variance quantity reported at the current operation. | |||
| CUMULATIVE_VARIANCE_QUANTITY | NUMBER | The total cumulative variance quantity up to the current operation, excluding the current operation. | |||
| OP_COMPL_FLAG | VARCHAR2 | 1 | Indicates whether the current operation has been marked complete. Valid values are: N (default) - operation is not marked complete Y - operation is marked complete and no more forward transactions are allowed |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| WIE_WO_OPERATIONS_B_GT_U1 | Unique | TEMPORARY_ROW_ID |