Oracle R12 - Query for fetching RFQ details

SELECT   SUM (poll.quantity) quantity, msi.segment1 item_code,
         msi.description item_desc, msi.primary_uom_code uom,
         poh.po_header_id, poh.org_id,
            SUBSTR (hou.NAME, 1, 3)
         || '/'
         || poh.attribute1
         || '/'
         || poh.segment1 rfq_num,
         TO_CHAR (TRUNC (poh.creation_date),'DD-MON-YYYY') creation_date, aps.vendor_name,
         apss.address_line1, apss.address_line2, apss.address_line3,
         apss.city, apss.zip
    FROM po_headers_all poh,
         po_lines_all pol,
         po_line_locations_all poll,
         mtl_system_items_b msi,
         hr_operating_units hou,
         po_rfq_vendors prv,
         ap_suppliers aps,
         ap_supplier_sites_all apss
   WHERE poh.type_lookup_code = 'RFQ'
     AND poh.po_header_id = :p_rfq_num
     AND prv.vendor_id = :p_vendor_id
     AND poh.po_header_id = pol.po_header_id
     AND pol.po_line_id = poll.po_line_id
     AND poll.ship_to_organization_id = msi.organization_id
     AND pol.item_id = msi.inventory_item_id
     AND poh.org_id = hou.organization_id
     AND prv.po_header_id = poh.po_header_id
     AND aps.vendor_id = prv.vendor_id
     AND apss.vendor_site_id = prv.vendor_site_id
GROUP BY msi.segment1,
         msi.description,
         msi.primary_uom_code,
         poh.po_header_id,
         poh.org_id,
         NAME,
         poh.attribute1,
         poh.segment1,
         poh.creation_date,
         aps.vendor_name,
         apss.address_line1,
         apss.address_line2,
         apss.address_line3,
         apss.city,
         apss.zip