[Home] [Help]
View: MTL_ITEM_LOCATIONS_VIEW
View Text
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
Columns
Name |
LOCATOR_ID |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
TOTAL_QUANTITY |
SUBINVENTORY_CODE |