To find Supplier site

select

pov.vendor_name Supplier,

povs.vendor_site_id,

povs.vendor_site_code Site,

povs.address_line1 A1ddress,

povs.address_line2 A2ddress,

povs.address_line3 A3ddress,

povs.city||', '||

povs.state||' '||

povs.zip A4ddress,

povs.ship_to_location_id,

povs.bill_to_location_id,

povs.ship_via_lookup_code,

povs.freight_terms_lookup_code,

povs.fob_lookup_code

from po_vendors pov,

po_vendor_sites povs

where pov.vendor_id=601

and pov.vendor_id=povs.vendor_id

order by 1;