eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MRP.MRP_LOW_LEVEL_CODES

Object Details

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).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

MRP.MRP_LOW_LEVEL_CODES does not reference any database object

MRP.MRP_LOW_LEVEL_CODES is referenced by following:

APPS: MRP_LOW_LEVEL_CODES