output with total item = 0

[ahbo01]

Hi friends,
really appreciate if anyone could help me on below queries

SELECT nvl(sum(Prl.quantity),0) Quantity, msi.segment1 item
FROM
po_requisition_lines_ALL PRL,
mtl_system_items_b msi,
invfg_onhand_balances iob
where
msi.inventory_item_id = iob.inventory_item_id (+) and
msi.organization_id = iob.organization_id (+) and
msi.inventory_item_id = prl.item_id(+)
and msi.organization_id = prl.destination_organization_id(+)
and msi.segment1 like 'Z%'
group by msi.segment1
order by msi.segment1

i only need the output for item with sum(Prl.quantity) = 0
currently the output will list all the items even total > 0.
thanks.

[davey23uk]

and sum(prl.quantity) = 0

[LKBrwn_DBA]

Try this:

Select SUM(NVL(Prl.Quantity,0)) Quantity, Msi.Segment1 Item
  From Po_Requisition_Lines_All Prl
     , Mtl_System_Items_B Msi
     , Invfg_Onhand_Balances Iob
 Where
       Msi.Inventory_Item_Id = Iob.Inventory_Item_Id (+) 
   And Msi.Organization_Id = Iob.Organization_Id (+) 
   And Msi.Inventory_Item_Id = Prl.Item_Id(+) 
   And Msi.Organization_Id = Prl.Destination_Organization_Id(+)
   And Msi.Segment1 Like 'Z%'
 Group By Msi.Segment1
Having Sum(Nvl(Prl.Quantity,0)) = 0
 Order By Msi.Segment1