Vendor Extract Query

SELECT ven.segment1 vendor_num
,ven.vendor_name
,sites.vendor_site_code
,sites.vendor_site_code_alt
,sites.creation_date
,sites.inactive_date
, sites.address_line1
|| ' '
|| sites.address_line2
|| ' '
|| sites.address_line3
|| ' '
|| sites.city
|| ' '
|| sites.province
|| ' '
|| sites.state
|| ' '
|| sites.zip address
,sites.purchasing_site_flag purchasing_site
,sites.pay_site_flag pay_to_site, t.NAME "Terms"
FROM po_vendor_sites_all sites, po_vendors ven, ap_terms_tl t
WHERE sites.vendor_id = ven.vendor_id AND sites.pay_group_lookup_code <> 'EMPLOYEE'
and t.TERM_ID = sites.TERMS_ID and t.LANGUAGE = 'US'