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