WIS_KBN_PLAN_LOWLEVEL_CODES_GT
This is a global temporary table that stores the low level codes for each item/location combination that is planned. The column LEVELS_BELOW stores the number of levels in the bill of material that exist beneath a given item. The column LOW_LEVEL_CODE is populated based on where an item or item/location combination occurs in the bill of material/ kanban replenishment chain. This table is then used by the Kanban planning engine to determine the demand flow from an item/location combination to the component item/location combination(s).
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_KBN_PLAN_LL_CODES_GT_PK |
TEMPORARY_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPORARY_ROW_ID | NUMBER | 18 | Yes | The unique identifier of the Kanban plan low level codes record. | |
| KANBAN_PLAN_ID | NUMBER | 18 | Yes | The unique identifier assigned to each Kanban plan within the system. It's a foreign key to the WIS_KANBAN_PLANS_B table. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier represents the manufacturing plant to which this Kanban demand belongs. | |
| COMPONENT_ITEM_ID | NUMBER | 18 | Yes | Represents the unique identifier of the component item. | |
| ASSEMBLY_ITEM_ID | NUMBER | 18 | Yes | Represents the unique identifier of the parent item of the component. | |
| COMPONENT_SUBINVENTORY_CODE | VARCHAR2 | 10 | Represents the name of the subinventory where the component item is stored or managed. | ||
| COMPONENT_LOCATOR_ID | NUMBER | 18 | Represents the identifier of the locator of the component item. | ||
| FROM_SUBINVENTORY_CODE | VARCHAR2 | 10 | Represents the name of the source subinventory in an intra-organization replenishment chain. | ||
| FROM_LOCATOR_ID | NUMBER | 18 | Represents the identifier of the source locator in an intra-organization replenishment chain. | ||
| LOW_LEVEL_CODE | NUMBER | Arbitrary number associated to the component in the BOM by level in the BOM hierarchy. | |||
| LEVELS_BELOW | NUMBER | Represents the levels beneath this component in the BOM. | |||
| COMPONENT_QUANTITY | NUMBER | Represents the quantity of component in bill of material. | |||
| COMPONENT_YIELD_FACTOR | NUMBER | Represents the yield of component in bill of material. | |||
| PLANNING_FACTOR | NUMBER | Represents the planning percentage of component in bill of material. | |||
| KANBAN_ITEM_FLAG | VARCHAR2 | 1 | Flag to indicate if this item is replenished using Kanbans. Valid values are Y/N. | ||
| OPERATION_YIELD | NUMBER | Represents the operation yield of the operation to which this item is associated in the work definition. | |||
| WIP_SUPPLY_TYPE | VARCHAR2 | 30 | Indicates the supply type code of the item. Valid values exist in the lookup with lookup type = EGP_WIP_SUP_TYPE. | ||
| 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. | ||
| ASSEMBLY_WORK_DEFINITION_ID | NUMBER | 18 | Reference to the work definition to which this item is associated. | ||
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Reference to the item structure component (EGP_COMPONENTS_B). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| WIS_KBN_PLAN_LL_CODES_GT_N01 | Non Unique | ORGANIZATION_ID, COMPONENT_ITEM_ID, ASSEMBLY_ITEM_ID |
| WIS_KBN_PLAN_LL_CODES_GT_U01 | Unique | TEMPORARY_ROW_ID |