Onhand quantity checking and sub inventory

SELECT msi.segment1, msi.organization_id, SUM (moq.transaction_quantity),moq.inventory_item_id FROM mtl_system_items_b msi, mtl_onhand_quantities moq WHERE moq.organization_id(+) = msi.organization_id AND moq.inventory_item_id(+) = msi.inventory_item_id and moq.ORGANIZATION_ID = 4 and msi.SEGMENT1 = 'B600312RML-77' GROUP BY msi.segment1, msi.organization_id,moq.inventory_item_id;