SELECT aps.vendor_name
,aps.exclude_freight_from_discount vend_excd
,apss.vendor_site_code
,apss.exclude_freight_from_discount site_excd
FROM ap_suppliers aps
,ap_supplier_sites_all apss
WHERE aps.vendor_id = apss.vendor_id
AND apss.exclude_freight_from_discount IS NULL
AND aps.exclude_freight_from_discount IS NULL
--AND aps.vendor_id NOT IN (1001)
No comments:
Post a Comment