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
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
|
|
|