Supplier Details

Select A.SEGMENT1,A.VENDOR_NAME,B.VENDOR_SITE_CODE
FROM AP_SUPPLIERS A,AP_SUPPLIER_SITES_ALL B
WHERE A.VENDOR_ID=B.VENDOR_ID