SELECT organization_id, inventory_item_id, subinventory_code, sum(primary_transaction_quantity) total_quantity FROM MTL_ONHAND_QUANTITIES_DETAIL group by organization_id, inventory_item_id, subinventory_code
View Text - HTML Formatted
SELECT ORGANIZATION_ID , INVENTORY_ITEM_ID , SUBINVENTORY_CODE , SUM(PRIMARY_TRANSACTION_QUANTITY) TOTAL_QUANTITY FROM MTL_ONHAND_QUANTITIES_DETAIL GROUP BY ORGANIZATION_ID , INVENTORY_ITEM_ID , SUBINVENTORY_CODE