[Home] [Help] [Dependency Information]
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.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
MRP.MRP_RESERVATIONS does not reference any database object
MRP.MRP_RESERVATIONS is referenced by following:
|
|
|