item on hand qty query

/* Formatted on 2020/01/18 15:54 (Formatter Plus v4.8.8) */
SELECT   subinventory_code, item.segment1 item_code,
         item.description item_description, SUM (on_hand.on_hand) on_hand
    FROM apps.mtl_system_items_b item, apps.mtl_onhand_total_mwb_v on_hand
   WHERE item.organization_id = 130                                   --ORG ID
     AND item.inventory_item_id = on_hand.inventory_item_id
     --AND on_hand.subinventory_code = 'zzz'  --sub inventory
     AND item.segment1 IN
                         ('TCPGPGBG00025032', 'TCPGPGBG00500046') ---item name
GROUP BY item.segment1, item.description, subinventory_code;