WIE_WO_OPERATION_MATERIALS
This table stores the material requirements for the work order at the operation level. The various types of materials required are recorded in this table.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_WO_OPER_MATERIALS_PK |
WO_OPERATION_MATERIAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_OPERATION_MATERIAL_ID | NUMBER | 18 | Yes | The unique identifier of work order operation material record. Its value is an application generated unique id. | |
| 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 | Yes | The organization identifier that represents the manufacturing plant to which this operation material belongs. | |
| WO_OPERATION_ID | NUMBER | 18 | Represents the foreign key reference to the WIE_WO_OPERATIONS_B table. For the primary product, this table is directly a child of WIE_WORK_ORDERS. | ||
| WORK_ORDER_ID | NUMBER | 18 | Represents the internal identifier of the work order. | ||
| MATERIAL_SEQ_NUMBER | NUMBER | Yes | Represents the order of consumption of material for a given operation. | ||
| MATERIAL_TYPE | VARCHAR2 | 30 | Yes | Type of material consumed by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_INPUT_MATERIAL. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | The primary item identifier defined in the work order. | |
| ITEM_REVISION | VARCHAR2 | 18 | If the primary product is revision controlled, this will have a value. | ||
| QUANTITY_PER_PRODUCT | NUMBER | Represents the quantity per assembly. This is the MATERIAL_QUANTITY from the work definition operation material. | |||
| BASIS_TYPE | VARCHAR2 | 30 | Yes | Indicates whether the material quantity is fixed (i.e. quantity per lot produced) or variable (i.e. quantity per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | |
| QUANTITY | NUMBER | Yes | Quantity of the material either consumed in the operation or produced from the operation. This is usually the work order quantity times the QUANTITY_PER_ASSEMBLY when the basis type is VARIABLE. | ||
| INVERSE_QUANTITY | NUMBER | The inverse of material quantity. | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code of the specified quantity. | |
| REQUIRED_DATE | TIMESTAMP | Date when the material is required in the operation. | |||
| YIELD_FACTOR | NUMBER | Yes | This is the percentage of material quantity actually incorporated into the finished good. | ||
| INCLUDE_IN_PLANNING_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether this material requirement should be seen by the planning process or not. | |
| SUBSTITUTE_FLAG | VARCHAR2 | 1 | Flag used indicate whether this component is a substitute or not. Valid values: Y - Substitute N or null - Primary component | ||
| SUBSTITUTE_PRIORITY_RANKING | NUMBER | Internal column to store the priority ranking of the substitute when swapped with primary. | |||
| SUPPLY_TYPE | VARCHAR2 | 30 | Yes | Reference of the supply type used for the work order operation material. Valid values exist in the lookup with lookup type = EGP_WIP_SUP_TYPE + lookup_type = ORA_WIE_WO_SUPPLY_TYPE. | |
| SUPPLY_SUBINVENTORY | VARCHAR2 | 20 | The subinventory that supplies material to the operation. | ||
| SUPPLY_LOCATOR_ID | NUMBER | 18 | The locator within the supply subinventory that feeds material into the work order operations. | ||
| ISSUED_QUANTITY | NUMBER | Represents the quantity issued so far, since partial issues are possible. This is mostly kept for runtime calculations. | |||
| PRODUCED_QUANTITY | NUMBER | Represents the quantity produced so far, since partial completions are possible. This is mostly kept for runtime calculations. | |||
| PICKED_QUANTITY | NUMBER | The actual pick confirmed quantity which gets updated when inventory does pick confirm for move orders. | |||
| ALLOCATED_QUANTITY | NUMBER | The total allocated quantity displayed as part of component pick processing. The value is incremented for the pick release quantity and adjusted for the quantity that is pick confirmed from inventory. | |||
| REMAINING_ALLOCATED_QUANTITY | NUMBER | The total remaining allocated quantity maintained as part of component pick processing. The value represents the total allocated quantity (ALLOCATED_QUANTITY) minus the quantity issued to the work order post allocation. | |||
| TIA_REF_LINE_ID | NUMBER | 18 | The transaction item attrbute reference identifier. This could be either the value of the CTO_MATCH_LINES.LINE_ID or FOM_ORDER_LINES.LINE_ID. The differentiator will be persisted in TIA_REF_ENTITY. | ||
| TIA_REF_ENTITY | VARCHAR2 | 30 | This column specifies whether the TIA_REF_LINE_ID is from CTO Match Lines or OM Order Lines. | ||
| WD_OPERATION_MATERIAL_ID | NUMBER | 18 | Represents the work order operation material identifier from the work definition. | ||
| 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. | ||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| WIE_WO_OPERATION_MATERIALS | wie_wo_operations_b | WO_OPERATION_ID |
| WIE_WO_OPERATION_MATERIALS | wie_work_orders_b | WORK_ORDER_ID |
| wie_wo_op_sub_materials | wie_wo_operation_materials | WO_OPERATION_MATERIAL_ID |
| wie_wo_product_serials | wie_wo_operation_materials | WO_OPERATION_MATERIAL_ID |
| wie_wo_material_tia_values | wie_wo_operation_materials | WO_OPERATION_MATERIAL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIE_WO_OPER_MATERIALS_N01 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID |
| WIE_WO_OPER_MATERIALS_N02 | Non Unique | Default | WO_OPERATION_ID, INVENTORY_ITEM_ID |
| WIE_WO_OPER_MATERIALS_N03 | Non Unique | Default | WORK_ORDER_ID, BASIS_TYPE |
| WIE_WO_OPER_MATERIALS_N04 | Non Unique | Default | WORK_ORDER_ID, MATERIAL_TYPE |
| WIE_WO_OPER_MATERIALS_N05 | Non Unique | Default | INVENTORY_ITEM_ID, WO_OPERATION_ID |
| WIE_WO_OPER_MATERIALS_U01 | Unique | Default | WO_OPERATION_MATERIAL_ID |
| WIE_WO_OPER_MATERIALS_U02 | Unique | Default | WORK_ORDER_ID, WO_OPERATION_ID, MATERIAL_SEQ_NUMBER |