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_RESERVATIONS

Object Details

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

MRP_RESERVATIONS stores information regarding material reservations
from the inventory system. Each row represents a portion of inventory
that is reserved for a demand. A reservation may be against an
inventory. If the reservation is against a nonnettable subinventory,
the NONNET_QUANTITY_RESERVED column holds the quantity. If the
reservation is against a nettable subinventory or no subinventory is
specified, the reservation quantity is stored in RESERVED_QUANTITY.
Note that the sum of RESERVED_QUANTITY cannot exceed the nettable
subinventories for a part. This could happen if the planner manually
sets subinventories to be non-reserved during the planning process.
The NONNET_QUANTITY_RESERVED will then store the quantity in excess of
the sum of the nettable reserved quantities.
.
MRP_RESERVATIONS is populated during the Snapshot and used by the
Planner. It is derived from MTL_DEMAND.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_RESERVATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID COMPILE_DESIGNATOR ORGANIZATION_ID
MRP_RESERVATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID COMPILE_DESIGNATOR ORGANIZATION_ID DISPOSITION_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Unique 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
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
RESERVATION_DATE	DATE		Yes	Effectivity date of reservation
REQUIREMENT_DATE	DATE		Yes	Date of need
RESERVED_QUANTITY	NUMBER		Yes	Quantity reserved
NONNET_QUANTITY_RESERVED	NUMBER		Yes	Quantity reserved allocated to nonnettable inventory
DISPOSITION_TYPE	NUMBER		Yes	Disposition type
DISPOSITION_ID	NUMBER		Yes	Disposition identifier
PARENT_DEMAND_ID	NUMBER		Yes	Parent demand identifier
SUBINVENTORY	VARCHAR2	(10)		Subinventory identifier
DEMAND_CLASS	VARCHAR2	(30)		Demand class
REVISION	VARCHAR2	(3)		Inventory item revision code
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
PROJECT_ID	NUMBER	(15)		Project identifier
TASK_ID	NUMBER	(15)		Task identifier
PLANNING_GROUP	VARCHAR2	(30)		Planning group

Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      RESERVATION_DATE
,      REQUIREMENT_DATE
,      RESERVED_QUANTITY
,      NONNET_QUANTITY_RESERVED
,      DISPOSITION_TYPE
,      DISPOSITION_ID
,      PARENT_DEMAND_ID
,      SUBINVENTORY
,      DEMAND_CLASS
,      REVISION
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
FROM MRP.MRP_RESERVATIONS;

Dependencies

[top of page]

MRP.MRP_RESERVATIONS does not reference any database object

MRP.MRP_RESERVATIONS is referenced by following:

MRP: MRP_RESERVATIONS#