[Home] [Help] [Dependency Information]
Object Name: | MRP_ONHAND_QUANTITIES |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_ONHAND_QUANTITIES |
Subobject Name: | |
Status: | VALID |
The MRP_ONHAND_QUANTITIES table stores on hand information which is
snapshot for MRP, MPS or DRP plans.
For each item in the plan, the nettable and nonnettable on hand
quantities are stored in this table by project/task/subinventory.
If a subinventory has locators with different project references,
this table contains multiple records with the same subinventory code
but different project references.
Data in this table can be viewed in the on hand window of the
Planner's Workbench form.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_ONHAND_QUANTITIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID COMPILE_DESIGNATOR SUB_INVENTORY_CODE |
MRP_ONHAND_QUANTITIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
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 |
SUB_INVENTORY_CODE | VARCHAR2 | (10) | Yes | Subinventory code |
NETTABLE_QUANTITY | NUMBER | Nettable on hand quantity | ||
NONNETTABLE_QUANTITY | NUMBER | Non nettable on hand quantity | ||
PROJECT_ID | NUMBER | Project identifier | ||
TASK_ID | NUMBER | Task identifier | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PLANNING_GROUP | VARCHAR2 | (30) | Planning group | |
TRANSACTION_ID | NUMBER | Unique identifier | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Unit number |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, SUB_INVENTORY_CODE
, NETTABLE_QUANTITY
, NONNETTABLE_QUANTITY
, PROJECT_ID
, TASK_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PLANNING_GROUP
, TRANSACTION_ID
, END_ITEM_UNIT_NUMBER
FROM MRP.MRP_ONHAND_QUANTITIES;
MRP.MRP_ONHAND_QUANTITIES does not reference any database object
MRP.MRP_ONHAND_QUANTITIES is referenced by following:
|
|
|