[Home] [Help] [Dependency Information]
Object Name: | MRP_LOW_LEVEL_CODES |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_LOW_LEVEL_CODES |
Subobject Name: | |
Status: | VALID |
MRP_LOW_LEVEL_CODES 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 used by the Kanban planning engine to determine
the demand flow from an item/location combination to the
component item/location combination(s).
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_LOW_LEVEL_CODES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ASSEMBLY_ITEM_ID TO_SUBINVENTORY TO_LOCATOR_ID |
MRP_LOW_LEVEL_CODES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
LEVELS_BELOW |
MRP_LOW_LEVEL_CODES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
LOW_LEVEL_CODE |
MRP_LOW_LEVEL_CODES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID COMPONENT_ITEM_ID |
MRP_LOW_LEVEL_CODES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID LOW_LEVEL_CODE ASSEMBLY_ITEM_ID |
MRP_LOW_LEVEL_CODES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID LOW_LEVEL_CODE COMPONENT_ITEM_ID |
MRP_LOW_LEVEL_CODES_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID KANBAN_ITEM_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Unique identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
ASSEMBLY_ITEM_ID | NUMBER | Yes | Assembly item identifier | |
TO_SUBINVENTORY | VARCHAR2 | (10) | Subinventory where assembly item is stored | |
TO_LOCATOR_ID | NUMBER | Assembly item locator identifier | ||
COMPONENT_ITEM_ID | NUMBER | Yes | Component Item Identifier | |
FROM_SUBINVENTORY | VARCHAR2 | (10) | Subinventory where component item is stored | |
FROM_LOCATOR_ID | NUMBER | Component item locator identifier | ||
LOW_LEVEL_CODE | NUMBER | Low level code | ||
LEVELS_BELOW | NUMBER | Levels beneath this part in the BOM | ||
COMPONENT_USAGE | NUMBER | Quantity of component in bill of material | ||
COMPONENT_YIELD | NUMBER | Component yield factor | ||
OPERATION_YIELD | NUMBER | Operation yield factor | ||
SUPPLY_SOURCE_TYPE | NUMBER | Type of supply specified in the Kanban pull sequence | ||
REPLENISHMENT_LEAD_TIME | NUMBER | Replenishment lead time specified in the Kanban pull sequence | ||
SELECTED_FLAG | VARCHAR2 | (1) | Not currently used | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATED_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
NET_PLANNING_PERCENT | NUMBER | Net Planning Percentage | ||
ALTERNATE_DESIGNATOR | VARCHAR2 | (10) | Holds alternate bom designator | |
KANBAN_ITEM_FLAG | VARCHAR2 | (1) | Whether Item is kanban Planned Item or not | |
COMPONENT_CATEGORY_ID | NUMBER | Category identifier of the component item | ||
PLANNING_FACTOR | NUMBER | Planning factor | ||
ITEM_NUM | NUMBER | Item number | ||
WIP_SUPPLY_TYPE | NUMBER | WIP Supply Type | ||
BASIS_TYPE | NUMBER | Basis Type |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ORGANIZATION_ID
, ASSEMBLY_ITEM_ID
, TO_SUBINVENTORY
, TO_LOCATOR_ID
, COMPONENT_ITEM_ID
, FROM_SUBINVENTORY
, FROM_LOCATOR_ID
, LOW_LEVEL_CODE
, LEVELS_BELOW
, COMPONENT_USAGE
, COMPONENT_YIELD
, OPERATION_YIELD
, SUPPLY_SOURCE_TYPE
, REPLENISHMENT_LEAD_TIME
, SELECTED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, NET_PLANNING_PERCENT
, ALTERNATE_DESIGNATOR
, KANBAN_ITEM_FLAG
, COMPONENT_CATEGORY_ID
, PLANNING_FACTOR
, ITEM_NUM
, WIP_SUPPLY_TYPE
, BASIS_TYPE
FROM MRP.MRP_LOW_LEVEL_CODES;
MRP.MRP_LOW_LEVEL_CODES does not reference any database object
MRP.MRP_LOW_LEVEL_CODES is referenced by following:
|
|
|