SELECT supp.vendor_name
,supp.segment1 vendor_number
,supp.exclude_freight_from_discount vendor_freight_discount_excld
,supp_site.vendor_site_code
,supp_site.exclude_freight_from_discount vend_sit_freight_dis_excld
FROM ap_suppliers supp
,ap_supplier_sites_all supp_site
WHERE supp.vendor_id = supp_site.vendor_id
AND supp.exclude_freight_from_discount IS NULL
AND supp_site.exclude_freight_from_discount IS NULL
ORDER BY supp.vendor_name
Thanks for sharing knowledge.
ReplyDeleteOptumflex.com
ReplyDelete