CST_WIS_WD_OP_MTLS_V_GT
This GT table is used in the cost roll up background job process to improve performance in a set-based processing implementation.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| WD_OPERATION_MATERIAL_ID | NUMBER | The unique identifier of a work definition operation material. Its value is an application generated unique id. | ||
| MATERIAL_SEQ_NUMBER | NUMBER | Indicates the sequence of this material line within this operation. | ||
| MATERIAL_TYPE | VARCHAR2 | 30 | Type of material either produced or consumed by the operation. For materials being consumed, valid values exist in the lookup with lookup type = ORA_WIS_WD_INPUT_MATERIAL. For materials being produced, valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL. | |
| ADHOC_FLAG | VARCHAR2 | 4 | Flag used to indicate whether this material line is based on the item structure. | |
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | The unique identifier of a component sequence. | |
| COMPONENT_SEQUENCE_ID_PATH | VARCHAR2 | 4000 | 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. | |
| WD_OPERATION_ID | NUMBER | 18 | Reference to the operation to which this material line is assigned. | |
| WORK_DEFINITION_ID | NUMBER | 18 | The unique identifier of a work definition. Its value is an application generated unique id. | |
| 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. | |
| YIELD_FACTOR | NUMBER | This is the percentage of material quantity incorporated into the finished good. | ||
| BASIS_TYPE | VARCHAR2 | 120 | Identifies component usage as fixed or variable. You can specify component usage as a fixed rate per job for activities such as setup and tear down, and variable rates for components whose usage depends on the number of units processed. For lot-based components you choose the Lot basis type and your usage rate is fixed, and for item based components you choose the Item basis type to indicate that your usage rate is variable. | |
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the material quantity. | |
| SUPPLY_TYPE | VARCHAR2 | 120 | Indicates the supply type code. Valid values exist in the lookup with lookup type = EGP_WIP_SUP_TYPE. | |
| 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. | ||
| INVERSE_MATERIAL_QUANTITY | NUMBER | Indicates the inverse quantity of material. | ||
| SUPPLY_SUBINVENTORY_NAME | VARCHAR2 | 10 | Indicates the sub-inventory from which this material line is consumed. | |
| SUPPLY_LOCATOR_ID | NUMBER | 18 | Physical area within a sub inventory where you store material, such as a row, aisle, bin, or shelf. | |
| OPTIONAL | NUMBER | Flag indicating if component is optional in bill | ||
| PLANNING_FACTOR | NUMBER | Factor used to multiply component quantity with to obtain planning quantity | ||
| ENFORCE_INT_REQUIREMENTS | NUMBER | Enforce integer requirement for component's calculated quantity or inverse quantity. | ||
| CHECK_ATP | NUMBER | Flag indicating if ATP check is required | ||
| EFFECTIVITY_DATE | DATE | Date at the beginning of the date range during which a given record will be available for transacting for date effective entities. | ||
| DISABLE_DATE | DATE | Date at the end of a date range during which a given record is available for transacting. Use for date effective entities only. | ||
| COMPONENT_QUANTITY | NUMBER | Quantity of component in bill of material | ||
| ITEM_NUM | NUMBER | Indicates the sequence of the item on an item structure. It is used to sort components when presenting item structure details. | ||
| QUANTITY_RELATED | NUMBER | Identifier to indicate if this component has quantity related reference designators | ||
| SO_BASIS | NUMBER | Quantity basis used by Oracle Order Management to determine how many units of component to put on an order | ||
| MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | Flag indicating if one or more children of component can be picked when taking an order | ||
| LOW_QUANTITY | NUMBER | Minimum quantity allowed on an order | ||
| HIGH_QUANTITY | NUMBER | Maximum quantity allowed on an order | ||
| BOM_ITEM_TYPE | NUMBER | Type of item (denormalized from BOM Item Type in EGP_SYSTEM_ITEMS) | ||
| OPTIONAL_ON_MODEL | NUMBER | Flag indicating if component is optional on model bill (for ATO) | ||
| ACD_TYPE | NUMBER | Add, change, or disable code for component on an engineering change order | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Unit which is primarily used to measure quantities of the item. | |
| LE_EFFECTIVITY_DATE | DATE | Legal entity date at the beginning of the date range during which a given record will be available for transacting. | ||
| LE_DISABLE_DATE | DATE | Legal entity date at the end of a date range during which a given record is available for transacting. | ||
| FIND_NUMBER | NUMBER | Unique number to identify a material used multiple times in the same level of the item structure. | ||
| WIS_MATERIAL_SEQ_NUMBER | NUMBER | Indicates the material sequence number of the material consumed in the operation performed. | ||
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WIS_WD_OP_MTLS_V_GT_N1 | Non Unique | WD_OPERATION_ID |
| CST_WIS_WD_OP_MTLS_V_GT_N2 | Non Unique | INVENTORY_ITEM_ID, ORGANIZATION_ID |