[Home] [Help] [Dependency Information]
Object Name: | MRP_INVENTORY_LOTS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_INVENTORY_LOTS |
Subobject Name: | |
Status: | VALID |
MRP_INVENTORY_LOTS stores information regarding inventory lots for
items in an MPS, MRP or DRP plan. It is used primarily to represent
information about lots that are expected to expire before they are
fully used. If a lot is expected to expire before it is fully used,
EXPIRED_LOT_QUANTITY will store the quantity of that lot that is
expected to go unused.
.
This table is populated during the Snapshot. The column
EXPIRED_LOT_QUANTITY is set by the Planner. This table is derived
from MTL_ONHAND_QUANTITIES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_INVENTORY_LOTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
TASK_ID ORGANIZATION_ID COMPILE_DESIGNATOR INVENTORY_ITEM_ID LOT_SUB_INVENTORY_CODE INVENTORY_LOT_NUMBER |
MRP_INVENTORY_LOTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
ORGANIZATION_ID INVENTORY_ITEM_ID EXPIRED_LOT_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 |
INVENTORY_LOT_NUMBER | VARCHAR2 | (30) | Yes | Inventory lot number |
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 | ||
LOT_QUANTITY | NUMBER | Yes | Inventory lot quantity | |
LOT_EXPIRATION_DATE | DATE | Inventory lot expiration date | ||
EXPIRED_LOT_QUANTITY | NUMBER | Inventory expired lot quantity | ||
LOT_SUB_INVENTORY_CODE | VARCHAR2 | (10) | Inventory lot secondary inventory | |
EXPIRED_LOT_ID | NUMBER | Not currently used | ||
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 | |
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | End item unit number |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, INVENTORY_LOT_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LOT_QUANTITY
, LOT_EXPIRATION_DATE
, EXPIRED_LOT_QUANTITY
, LOT_SUB_INVENTORY_CODE
, EXPIRED_LOT_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, TASK_ID
, PLANNING_GROUP
, END_ITEM_UNIT_NUMBER
FROM MRP.MRP_INVENTORY_LOTS;
MRP.MRP_INVENTORY_LOTS does not reference any database object
MRP.MRP_INVENTORY_LOTS is referenced by following:
|
|
|