SELECT distinct povs.vendor_id, povs.Address_line1 || ' '||povs.address_line2 || ' '|| povs.address_line3 ||' ' || povs.city|| ' '|| povs.county || ' '|| povs.province ||' ' || povs.state || ' ' || povs.zip ||' ' || povs. country Address, povs.area_code || '-' ||phone phone, povs.vendor_site_id FROM PO_VENDOR_SITES_ALL POVS
SELECT DISTINCT POVS.VENDOR_ID
, POVS.ADDRESS_LINE1 || ' '||POVS.ADDRESS_LINE2 || ' '|| POVS.ADDRESS_LINE3 ||' ' || POVS.CITY|| ' '|| POVS.COUNTY || ' '|| POVS.PROVINCE ||' ' || POVS.STATE || ' ' || POVS.ZIP ||' ' || POVS. COUNTRY ADDRESS
, POVS.AREA_CODE || '-' ||PHONE PHONE
, POVS.VENDOR_SITE_ID
FROM PO_VENDOR_SITES_ALL POVS
|
|
|