On hand query

Hi all, I have a report requirement from stores users on on-hand quantities for all inventory organizations.
The Item Quantities report is fine but only works for one organization at a time, and we have 32 inventory organizations(Stock points).
i have made the query below, for the same(Is this correct?).
But i cannot attach the cost value. Plz help

--------------------------------------
SELECT DISTINCT
o.organization_code,
b.segment1           ITEM_CODE   
,a.subinventory_code  LOCATION
,B.description DESCRIPTION
,B.primary_uom_code UOM
,sum(a.transaction_quantity) TRANS_QTY
FROM   MTL_MATERIAL_TRANSACTIONS A
      ,MTL_SYSTEM_ITEMS_B B
      ,MTL_PARAMETERS_VIEW d