View: MTL_NEGATIVE_VIEW

Product:	INV - Inventory
Description:	View of onhand negative inventory
Implementation/DBA Data:	APPS.MTL_NEGATIVE_VIEW

View Text

SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY_CODE
, LOCATOR_ID
, LOT_NUMBER
, SUM(PRIMARY_TRANSACTION_QUANTITY) QUANTITY
FROM MTL_ONHAND_QUANTITIES_DETAIL GROUP BY ORGANIZATION_ID
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY_CODE
, LOCATOR_ID
, LOT_NUMBER HAVING SUM(PRIMARY_TRANSACTION_QUANTITY) < 0

Columns