View: MTL_ITEM_LOT_QUANTITIES_VIEW

Product:	INV - Inventory
Description:	Item lot quantities under subinventory and locator
Implementation/DBA Data:	APPS.MTL_ITEM_LOT_QUANTITIES_VIEW

View Text

SELECT Q.ORGANIZATION_ID
, Q.INVENTORY_ITEM_ID
, Q.SUBINVENTORY_CODE
, Q.LOCATOR_ID
, Q.REVISION
, L.EXPIRATION_DATE
, Q.LOT_NUMBER
, SUM(PRIMARY_TRANSACTION_QUANTITY) QUANTITY
FROM MTL_ONHAND_QUANTITIES_DETAIL Q
, MTL_LOT_NUMBERS L
WHERE Q.ORGANIZATION_ID = L.ORGANIZATION_ID
AND Q.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
AND Q.LOT_NUMBER = L.LOT_NUMBER GROUP BY Q.ORGANIZATION_ID
, Q.INVENTORY_ITEM_ID
, Q.SUBINVENTORY_CODE
, Q.REVISION
, Q.LOCATOR_ID
, Q.LOT_NUMBER
, L.EXPIRATION_DATE

Columns