SELECT locator_id, organization_id, inventory_item_id, nvl(sum(primary_transaction_quantity),0) total_quantity, subinventory_code FROM MTL_ONHAND_QUANTITIES_DETAIL group by locator_id, organization_id,inventory_item_id, subinventory_code
SELECT LOCATOR_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, NVL(SUM(PRIMARY_TRANSACTION_QUANTITY)
, 0) TOTAL_QUANTITY
, SUBINVENTORY_CODE
FROM MTL_ONHAND_QUANTITIES_DETAIL GROUP BY LOCATOR_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SUBINVENTORY_CODE
|
|
|