WIS_WD_OPERATION_MATERIALS
This table associates an operation to one or more material lines. It defines the material consumed and/or yielded for the given operation. Note that a given material line can be consumed/yielded by/from different operations. In this case, the material quantity consumed/yielded for the operation is also maintained in this table.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_WD_OPERATION_MATERIALS_PK |
WD_OPERATION_MATERIAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_MATERIAL_ID | NUMBER | 18 | Yes | The unique identifier of a work definition operation material. 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. | |
| MATERIAL_SEQ_NUMBER | NUMBER | Yes | Indicates the sequence of this material line within this 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. | |
| MATERIAL_QUANTITY | NUMBER | This is the quantity required to produce one unit of finished goods. In the case of an ATO model, this field will not be populated and instead fetched directly from PIM. | |||
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the material quantity. | ||
| YIELD_FACTOR | NUMBER | This is the percentage of material quantity actually incorporated into the finished good. | |||
| INVERSE_MATERIAL_QUANTITY | NUMBER | Indicates the inverse quantity of material. | |||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the item 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. | ||
| SUPPLY_TYPE | VARCHAR2 | 30 | Yes | Indicates the supply type code. Valid values exist in the lookup with lookup type = EGP_WIP_SUP_TYPE. | |
| ADHOC_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether this material line is based on the item structure. | |
| WD_OPERATION_ID | NUMBER | 18 | Yes | Reference to the operation to which this material line is assigned. | |
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Reference to the item structure component (EGP_COMPONENTS_B) assigned to this operation. | ||
| COMPONENT_SEQUENCE_ID_PATH | CLOB | Contains the lineage key of this component in the ATO Model item structure. This attribute refers to EGP_EXPLOSIONS_V.COMP_SEQ_PATH. It is used to uniquely identify this component in the exploded ATO Model item structure. | |||
| ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this item belongs. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Represents the unique identifier of the item for this material line. | ||
| SUPPLY_SUBINVENTORY_NAME | VARCHAR2 | 10 | Indicates the subinventory from which this material line is consumed. | ||
| SUPPLY_LOCATOR_ID | NUMBER | 18 | Indicates the locator from which this material line is consumed. | ||
| 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 |
|---|---|---|
| WIS_WD_OPERATION_MATERIALS | wis_wd_operations_b | WD_OPERATION_ID |
| wis_wd_op_sub_materials | wis_wd_operation_materials | WD_OPERATION_MATERIAL_ID |
| wis_wd_substitute_materials | wis_wd_operation_materials | WD_OPERATION_MATERIAL_ID |
| wis_wd_mtl_ref_designators | wis_wd_operation_materials | WD_OPERATION_MATERIAL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| WIS_WD_OPERATION_MATERIALS_N1 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID | |
| WIS_WD_OPERATION_MATERIALS_N2 | Non Unique | Default | WD_OPERATION_ID | Obsolete |
| WIS_WD_OPERATION_MATERIALS_N3 | Non Unique | Default | COMPONENT_SEQUENCE_ID | |
| WIS_WD_OPERATION_MATERIALS_N4 | Non Unique | Default | SUPPLY_SUBINVENTORY_NAME | |
| WIS_WD_OPERATION_MATERIALS_N5 | Non Unique | Default | SUPPLY_LOCATOR_ID | |
| WIS_WD_OPERATION_MATERIALS_N6 | Non Unique | Default | WD_OPERATION_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID | |
| WIS_WD_OPERATION_MATERIALS_N7 | Non Unique | Default | WD_OPERATION_ID, ORGANIZATION_ID, COMPONENT_SEQUENCE_ID | |
| WIS_WD_OPERATION_MATERIALS_N8 | Non Unique | Default | WD_OPERATION_ID, SUPPLY_TYPE | |
| WIS_WD_OPERATION_MATERIALS_U1 | Unique | Default | WD_OPERATION_MATERIAL_ID |