CST_WORK_ORDERS_V_S_GT
This global temporary table is used to temporarily store a subset of the data from cst_work_orders_v view for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WORK_ORDERS_V_S_GT_PK |
CST_WORK_ORDER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate identifying a work order uniquely in costing. | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Code identifying the external system owning this work order definition. | |
| WO_EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the work order in the source system. Manufacturing work order ID. | |
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Yes | Work Order Number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level. | |
| INV_ORG_ID | NUMBER | 18 | Yes | Manufacturing Organization in which the work order is created. | |
| WORK_METHOD_ID | NUMBER | 18 | Yes | The work method that will be used to execute the work order. The Master table for which is WIS_WORK_METHODS_B/TL. | |
| WORK_METHOD_CODE | VARCHAR2 | 30 | Code associated to the work method. | ||
| WORK_ORDER_TYPE | VARCHAR2 | 30 | Yes | Based on the Work Method, this attribute further classifies the Work Order to indicate whether it is meant for either Standard or Non Standard Production. The value for which comes from a lookup_type = 'WIE_WO_TYPE'. This lookup is system defined and not alterable by the user. | |
| WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | For a specific Work Order Type, this attribute represents the specific nature of work being performed such as Standard Production, Prototyping, or Repair. The value for which comes from a lookup_type = 'WIE_WO_SUB_TYPE'. This is a user extensible lookup. | ||
| WORK_ORDER_LESS_FLAG | VARCHAR2 | 1 | When products have well defined product definitions, They can be produced by means of something called work order less completions. Such completion transaction can trigger the creation of a work order and marks that with the ORDER_LESS_FLAG = "Y". | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | This refers to the primary product that needs to be manufactured, and can be any active item that has the "Build in WIP" flag checked at the Item Organization (Plant) level. | ||
| MNT_COMPLETE_TO_INV_FLAG | VARCHAR2 | 1 | Flag indicating that the asset(s) involved in the work order will be completing to inventory upon completion of work. | ||
| CONTAINS_OP_YIELD_OPERATION | VARCHAR2 | 1 | Indicates if the work order has at least one operation with operation yield factor not equal to 1. Possible values are Y, NULL. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WORK_ORDERS_V_S_GT_U1 | Unique | CST_WORK_ORDER_ID |