Query to Fetch NON Serialized Quantity based on Subinventory Code, Locator Name, organization id and Item Name

Query to Fetch NON Serialized Quantity based on Sub inventory Code, Locator Name, organization id and Item Name

SELECT msi.segment1,
         SUM (mq.transaction_quantity) on_hand,
         ood.organization_id,
         mq.subinventory_code,
         mq.locator_id,
         mil.segment1
    FROM apps.org_organization_definitions ood,
         apps.mtl_onhand_quantities mq,
         apps.mtl_system_items_b msi,
         mtl_item_locations mil
   WHERE     1 = 1
         AND mq.organization_id = msi.organization_id
         AND ood.organization_id = msi.organization_id
         AND mq.inventory_item_id = msi.inventory_item_id
         AND mq.locator_id = mil.inventory_location_id
         AND msi.segment1 = 'USE'                            -- Give Item Name
         AND ood.organization_id = 128                 -- Give Organization id
         AND mil.segment1 LIKE 'LOC%'                     -- Give Locator Name
         AND msi.serial_number_control_code = 1
         AND mq.subinventory_code = 'XX-RTV'              -- Give Sub Inventory Code
GROUP BY msi.segment1,
         ood.organization_id,
         mq.subinventory_code,
         mq.locator_id,
         mil.segment1