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_SYSTEM_ITEMS

Object Details

Object Name:	MRP_SYSTEM_ITEMS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_SYSTEM_ITEMS
Subobject Name:
Status:	VALID

MRP_SYSTEM_ITEMS stores a copy of items planned by the planning
process. Most of the columns in MRP_SYSTEM_ITEMS correspond to
columns from the Oracle Inventory item master table, MTL_SYSTEM_ITEMS.
.
LOW_LEVEL_CODE stores the low level code of the item. This is
used to determine the order in which items are planned during the
planning process (see MRP_LOW_LEVEL_CODES for details).
.
Lead time is stored in several columns. The static leadtime, which is
based upon the lead time lot size and calculated by the lead time
rollup, is stored in the columns PREPROCESSING_LEAD_TIME,
POSTPROCESSING_LEAD_TIME and FULL_LEAD_TIME. The lead time rollup
also calculates CUMULATIVE_TOTAL_LEAD_TIME and
CUM_MANUFACTURING_LEAD_TIME.
.
PLAN_MAKE_BUY_CODE determines whether the planning process will plan
this item as a purchased item or a manufactured item.
.
The columns PLAN_START_DATE, PLAN_COMPLETION_DATE,
PLANNER_BATCH_NUMBER and PLANNER_STATUS_FLAG are used internally by
the Planner to coordinate the planning of items done by multiple
Planner Workers running in parallel.
.
The column INVENTORY_USE_UP_DATE is the date that the planning process
will exhaust current nettable inventories, based on projected gross
requirements.
.
This table is populated by the Snapshot, and is used by the Planner.
This table is derived mainly from MTL_SYSTEM_ITEMS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_SYSTEM_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR INVENTORY_ITEM_ID
MRP_SYSTEM_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR LOW_LEVEL_CODE PLANNER_BATCH_NUMBER
MRP_SYSTEM_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLANNER_CODE COMPILE_DESIGNATOR ORGANIZATION_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
IN_SOURCE_PLAN	NUMBER			Whether the item is planned in the source plan or not
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
INVENTORY_TYPE	NUMBER		Yes	Inventory type code
MRP_PLANNING_CODE	NUMBER		Yes	Item MPS schedule type code
INVENTORY_PLANNING_CODE	NUMBER		Yes	Inventory planning code
LOW_LEVEL_CODE	NUMBER		Yes	Inventory item identifier low level code
PREPROCESSING_LEAD_TIME	NUMBER			Preprocessing lead time
POSTPROCESSING_LEAD_TIME	NUMBER			Postprocessing lead time
FULL_LEAD_TIME	NUMBER		Yes	Full lead time
CUMULATIVE_TOTAL_LEAD_TIME	NUMBER			Cumulative total lead time
CUM_MANUFACTURING_LEAD_TIME	NUMBER			Cumulative manufacturing lead time
FIXED_LEAD_TIME	NUMBER			The fixed portion of lead time
VARIABLE_LEAD_TIME	NUMBER			The variable portion of lead time
UOM_CODE	VARCHAR2	(3)	Yes	Unit of measure code
BUILD_IN_WIP_FLAG	NUMBER		Yes	Flag to indicate if this item can be built in WIP
PURCHASING_ENABLED_FLAG	NUMBER		Yes	Purchasing enabled flag
PLANNING_MAKE_BUY_CODE	NUMBER		Yes	Plan this item as either a make item or a buy item
REPETITIVE_TYPE	NUMBER		Yes	Is this item built repetitively?
STANDARD_COST	NUMBER			Standard cost
LOT_CONTROL_CODE	NUMBER		Yes	Lot control code
ROUNDING_CONTROL_TYPE	NUMBER		Yes	Order rounding control type code
CALCULATE_ATP	NUMBER		Yes	Calculate ATP when planning this part
END_ASSEMBLY_PEGGING	NUMBER		Yes	Peg to the end assembly on reports
NETTABLE_INVENTORY_QUANTITY	NUMBER		Yes	Nettable inventory quantity on hand
NONNETTABLE_INVENTORY_QUANTITY	NUMBER		Yes	Nonnettable inventory quantity on hand
ENGINEERING_ITEM_FLAG	NUMBER		Yes	Engineering item flag
WIP_SUPPLY_TYPE	NUMBER			WIP supply type
OVERRUN_PERCENTAGE	NUMBER			Repetitive overrun percentage
ACCEPTABLE_RATE_INCREASE	NUMBER			Acceptable rate increase
ACCEPTABLE_RATE_DECREASE	NUMBER			Acceptable rate decrease
SAFETY_STOCK_CODE	NUMBER		Yes	Safety stock code
SAFETY_STOCK_PERCENT	NUMBER			Percent for dynamically calculated safety stock
SAFETY_STOCK_BUCKET_DAYS	NUMBER			Days over which to average demand for MRP Planned Safety Stock Percent
SAFETY_STOCK_QUANTITY	NUMBER			Safety stock quantity
PLAN_LAST_REVISION_DATE	DATE			Last plan revision date
DESCRIPTION	VARCHAR2	(240)		Inventory item identifier description
CATEGORY_ID	NUMBER			Category id for the planning category set
BUYER_ID	NUMBER	(9)		Buyer identifier
BUYER_NAME	VARCHAR2	(240)		Buyer Name
PLANNER_CODE	VARCHAR2	(10)		Planner code
ABC_CLASS	NUMBER			Inventory item identifier ABC class
REVISION	VARCHAR2	(3)		Item revision
FIXED_DAYS_SUPPLY	NUMBER			Fixed days supply
FIXED_ORDER_QUANTITY	NUMBER			Fixed order quantity
FIXED_LOT_MULTIPLIER	NUMBER			Fixed lot multiplier
MINIMUM_ORDER_QUANTITY	NUMBER			Minimum order quantity
MAXIMUM_ORDER_QUANTITY	NUMBER			Maximum order quantity
PLANNING_TIME_FENCE_DAYS	NUMBER			Planning time fence days
PLANNING_TIME_FENCE_DATE	DATE			Planning time fence date
DEMAND_TIME_FENCE_DAYS	NUMBER			Demand time fence days
INVENTORY_USE_UP_DATE	DATE			The date that inventory will be exhausted based upon projected gross requirements
ACCEPTABLE_EARLY_DELIVERY	NUMBER			Acceptable early days delivery
PLANNER_BATCH_NUMBER	NUMBER			Batch identifier for use by the Planner
PLANNER_STATUS_CODE	NUMBER			Status of the item for the Planner
PLAN_START_DATE	DATE			Date planning of this item was started
PLAN_COMPLETION_DATE	DATE			Date planning for this item was completed
SHRINKAGE_RATE	NUMBER			Expected loss due to scrap
PLANNING_EXCEPTION_SET	VARCHAR2	(10)		Planning exception set to use to generate exception messages
EXCESS_QUANTITY	NUMBER			Excess quantity
REPETITIVE_VARIANCE	NUMBER			Repetitive variance
EXCEPTION_SHORTAGE_DAYS	NUMBER			Exception shortage days
EXCEPTION_EXCESS_DAYS	NUMBER			Exception excess days
EXCEPTION_REP_VARIANCE_DAYS	NUMBER			Exception repetitive variance days
EXCEPTION_OVERPROMISED_DAYS	NUMBER			Exception overpromised days
BASE_ITEM_ID	NUMBER			Base model for this configuration
BOM_ITEM_TYPE	NUMBER			Bom item type
ATO_FORECAST_CONTROL	NUMBER			Forecast control
EXCEPTION_CODE	VARCHAR2	(5)		Exception message code (internal use only)
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
PRIMARY_VENDOR_ID	NUMBER			Primary supplier identifier
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
DEMAND_TIME_FENCE_DATE	DATE			Demand time fence date
FULL_PEGGING	NUMBER			Not currently used
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
EFFECTIVITY_CONTROL	NUMBER			Effectivity Control, Unit or date effective

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      IN_SOURCE_PLAN
,      LAST_UPDATE_LOGIN
,      INVENTORY_TYPE
,      MRP_PLANNING_CODE
,      INVENTORY_PLANNING_CODE
,      LOW_LEVEL_CODE
,      PREPROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      CUMULATIVE_TOTAL_LEAD_TIME
,      CUM_MANUFACTURING_LEAD_TIME
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      UOM_CODE
,      BUILD_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      REPETITIVE_TYPE
,      STANDARD_COST
,      LOT_CONTROL_CODE
,      ROUNDING_CONTROL_TYPE
,      CALCULATE_ATP
,      END_ASSEMBLY_PEGGING
,      NETTABLE_INVENTORY_QUANTITY
,      NONNETTABLE_INVENTORY_QUANTITY
,      ENGINEERING_ITEM_FLAG
,      WIP_SUPPLY_TYPE
,      OVERRUN_PERCENTAGE
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      SAFETY_STOCK_CODE
,      SAFETY_STOCK_PERCENT
,      SAFETY_STOCK_BUCKET_DAYS
,      SAFETY_STOCK_QUANTITY
,      PLAN_LAST_REVISION_DATE
,      DESCRIPTION
,      CATEGORY_ID
,      BUYER_ID
,      BUYER_NAME
,      PLANNER_CODE
,      ABC_CLASS
,      REVISION
,      FIXED_DAYS_SUPPLY
,      FIXED_ORDER_QUANTITY
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      MAXIMUM_ORDER_QUANTITY
,      PLANNING_TIME_FENCE_DAYS
,      PLANNING_TIME_FENCE_DATE
,      DEMAND_TIME_FENCE_DAYS
,      INVENTORY_USE_UP_DATE
,      ACCEPTABLE_EARLY_DELIVERY
,      PLANNER_BATCH_NUMBER
,      PLANNER_STATUS_CODE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      SHRINKAGE_RATE
,      PLANNING_EXCEPTION_SET
,      EXCESS_QUANTITY
,      REPETITIVE_VARIANCE
,      EXCEPTION_SHORTAGE_DAYS
,      EXCEPTION_EXCESS_DAYS
,      EXCEPTION_REP_VARIANCE_DAYS
,      EXCEPTION_OVERPROMISED_DAYS
,      BASE_ITEM_ID
,      BOM_ITEM_TYPE
,      ATO_FORECAST_CONTROL
,      EXCEPTION_CODE
,      PROGRAM_UPDATE_DATE
,      PRIMARY_VENDOR_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      DEMAND_TIME_FENCE_DATE
,      FULL_PEGGING
,      ORGANIZATION_CODE
,      EFFECTIVITY_CONTROL
FROM MRP.MRP_SYSTEM_ITEMS;

Dependencies

[top of page]

MRP.MRP_SYSTEM_ITEMS does not reference any database object

MRP.MRP_SYSTEM_ITEMS is referenced by following:

MRP: MRP_SYSTEM_ITEMS#