magritton
6/6/2015 - 2:21 AM

Oracle SQL vendor site terms with vendor name

Oracle SQL vendor site terms with vendor name

SQL Vendor Site Terms.sql
content_copyfile_download
select assa.terms_id,att.term_ID,att.name, aps.vendor_name, aps.vendor_id from ap_supplier_sites_all assa
,AP_TERMS_TL att,ap_suppliers aps
where assa.terms_id = att.TERM_ID
and att.LANGUAGE = 'US'
and
assa.vendor_id = aps.vendor_id
and assa.vendor_id = 1116616;