Inventory Onhand Quantity Report

SELECT msib.segment1,
       msib.description,
       msib.primary_uom_code uom,
       mp.organization_code,
       moq.subinventory_code,
       SUM(moq.transaction_quantity) ONHAND_QTY
  FROM MTL_SYSTEM_ITEMS_B msib,
       MTL_PARAMETERS MP,
       MTL_ONHAND_QUANTITIES MOQ
 WHERE 1=1--SEGMENT1 = 'DELL LCD 22"'
   AND msib.mtl_transactions_enabled_flag = 'N'
   AND msib.organization_id = mp.organization_id
   AND msib.inventory_item_id = moq.inventory_item_id
   AND msib.organization_id = moq.organization_id
GROUP BY msib.segment1,
         msib.description,
         msib.primary_uom_code ,
         mp.organization_code,
         moq.subinventory_code
ORDER BY mp.organization_code,
         moq.subinventory_code,
         msib.segment1