欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

供应商类型为“员工”,计税这个地方为“否”的清单

程序员文章站 2022-04-12 11:34:29
select hou.name, vendor_name from po_vendor_sites_all pvs, ap_suppliers ass, hr_operating_units hou where pvs.auto_tax_calc_flag = 'N' and pvs.vendor_ ......
select hou.name, vendor_name
from po_vendor_sites_all pvs, ap_suppliers ass, hr_operating_units hou
where pvs.auto_tax_calc_flag = 'n'
and pvs.vendor_id = ass.vendor_id
and ass.vendor_type_lookup_code = 'meg_employee'
and pvs.org_id = hou.organization_id;