825: ||','
826: ||pvs.zip
827: ||','
828: ||pvs.country
829: FROM po_vendor_sites_all pvs
830: WHERE pvs.vendor_site_id = ciih.old_location_id),
831: 'INVENTORY', (SELECT hrl.address_line_1
832: ||','
833: ||hrl.address_line_2
983: ||','
984: ||pvs.zip
985: ||','
986: ||pvs.country
987: FROM po_vendor_sites_all pvs
988: WHERE pvs.vendor_site_id = ciih.new_location_id),
989: 'INVENTORY', (SELECT hrl.address_line_1
990: ||','
991: ||hrl.address_line_2