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: INV.MTL_ONHAND_QUANTITIES_DETAIL

Object Details

Object Name:	MTL_ONHAND_QUANTITIES_DETAIL
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_ONHAND_QUANTITIES_DETAIL
Subobject Name:
Status:	VALID

MTL_ONHAND_QUANTITIES stores quantity on hand information by control
level and location.
.
.
.
MTL_ONHAND_QUANTITIES is maintained as a stack of receipt records,
which are consumed by issue transactions in FIFO order. The quantity
on hand of an item at any particular control level and location can be
found by summing TRANSACTION_QUANTITY for all records that match the
criteria. Note that any transactions which are committed to the table
MTL_MATERIAL_TRANSACTIONS_TEMP are considered to be played out as far
as quantity on hand is concerned in Inventory transaction forms. All
our Inquiry forms and ABC compile are only based on
MTL_ONHAND_QUANTITIES.
.
.
.
MTL_ONHAND_QUANTITIES has two columns, CREATE_TRANSACTION_ID
and UPDATE_TRANSACTION_IDs to join to
MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID the transactions that
created the row and the transaction that last updated a row.
.
.
.
.
.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ONHAND_QUANTITIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID SUBINVENTORY_CODE PRIMARY_TRANSACTION_QUANTITY
MTL_ONHAND_QUANTITIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID SUBINVENTORY_CODE LOCATOR_ID LPN_ID
MTL_ONHAND_QUANTITIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID COST_GROUP_ID
MTL_ONHAND_QUANTITIES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IS_CONSIGNED

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
DATE_RECEIVED	DATE			Date received
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
PRIMARY_TRANSACTION_QUANTITY	NUMBER		Yes	Transaction quantity in the primary unit of measure of the item
SUBINVENTORY_CODE	VARCHAR2	(10)	Yes	Subinventory code
REVISION	VARCHAR2	(3)		Item revision code
LOCATOR_ID	NUMBER			Locator identifier
CREATE_TRANSACTION_ID	NUMBER			Transaction identifier of the transaction that created this row
UPDATE_TRANSACTION_ID	NUMBER			Transaction identifier of the transaction that last updated this row
LOT_NUMBER	VARCHAR2	(80)		Lot number
ORIG_DATE_RECEIVED	DATE			Date originally recieved
COST_GROUP_ID	NUMBER			Cost Group ID - Used by WMS only
CONTAINERIZED_FLAG	NUMBER			Containerized Flag
PROJECT_ID	NUMBER			Project Id (For future use)
TASK_ID	NUMBER			Task Id (For future use)
ONHAND_QUANTITIES_ID	NUMBER		Yes	Sequence Column for the rows based on MTL_ONHAND_QUANTITIES_S
ORGANIZATION_TYPE	NUMBER		Yes	Organization Type. The values are based on MTL_TP_TYPES lookup.
OWNING_ORGANIZATION_ID	NUMBER		Yes	Owning organization identifier
OWNING_TP_TYPE	NUMBER		Yes	Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
PLANNING_ORGANIZATION_ID	NUMBER		Yes	Planning organization identifier
PLANNING_TP_TYPE	NUMBER		Yes	Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
TRANSACTION_UOM_CODE	VARCHAR2	(3)	Yes	Transaction unit of measure which created this transaction
TRANSACTION_QUANTITY	NUMBER		Yes	Transaction quantity
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary unit of measure that may have been used to do the material transaction
SECONDARY_TRANSACTION_QUANTITY	NUMBER			Secondary quantity
IS_CONSIGNED	NUMBER		Yes	Check if the row is owned, planned and physically belongs to the inventory organization. If it is 1 then this material is consigned
LPN_ID	NUMBER			LPN Identifier
STATUS_ID	NUMBER			Onhand material status Identifier

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      DATE_RECEIVED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PRIMARY_TRANSACTION_QUANTITY
,      SUBINVENTORY_CODE
,      REVISION
,      LOCATOR_ID
,      CREATE_TRANSACTION_ID
,      UPDATE_TRANSACTION_ID
,      LOT_NUMBER
,      ORIG_DATE_RECEIVED
,      COST_GROUP_ID
,      CONTAINERIZED_FLAG
,      PROJECT_ID
,      TASK_ID
,      ONHAND_QUANTITIES_ID
,      ORGANIZATION_TYPE
,      OWNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      PLANNING_ORGANIZATION_ID
,      PLANNING_TP_TYPE
,      TRANSACTION_UOM_CODE
,      TRANSACTION_QUANTITY
,      SECONDARY_UOM_CODE
,      SECONDARY_TRANSACTION_QUANTITY
,      IS_CONSIGNED
,      LPN_ID
,      STATUS_ID
FROM INV.MTL_ONHAND_QUANTITIES_DETAIL;

Dependencies

[top of page]

INV.MTL_ONHAND_QUANTITIES_DETAIL does not reference any database object

INV.MTL_ONHAND_QUANTITIES_DETAIL is referenced by following:

APPS: MTL_ONHAND_QUANTITIES_DETAIL