[Home] [Help]
View: MTL_ITEM_QUANTITIES_VIEW
View Text
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, REVISION
, SUM(PRIMARY_TRANSACTION_QUANTITY) QUANTITY
FROM MTL_ONHAND_QUANTITIES_DETAIL GROUP BY ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, REVISION
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
SUBINVENTORY_CODE |
LOCATOR_ID |
REVISION |
QUANTITY |