[Home] [Help]
View: ICX_MTL_DEMAND_ITEM_SUM_V
View Text
SELECT INVENTORY_ITEM_ID
, ITEM
, DESCRIPTION
, PRIMARY_UNIT_OF_MEASURE
, SUM(NVL(ONHAND_QUANTITY
, 0))
, SUM(NVL(DEMAND_QUANTITY
, 0))
, SUM(NVL(HARD_RESERVATION_QUANTITY
, 0))
, SUM(NVL(SUPPLY_RESERVATION_QUANTITY
, 0))
, SUM(NVL(TRANSACTABLE_QUANTITY
, 0))
, SUM(NVL(NET_AVAILABLE_QUANTITY
, 0))
FROM ICX_MTL_DEMAND_SUMMARY_V GROUP BY INVENTORY_ITEM_ID
, ITEM
, DESCRIPTION
, PRIMARY_UNIT_OF_MEASURE
Columns
Name |
INVENTORY_ITEM_ID |
ITEM |
DESCRIPTION |
PRIMARY_UNIT_OF_MEASURE |
ONHAND_QUANTITY |
DEMAND_QUANTITY |
HARD_RESERVATION_QUANTITY |
SUPPLY_RESERVATION_QUANTITY |
TRANSACTABLE_QUANTITY |
NET_AVAILABLE_QUANTITY |