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

it2022-05-07  8

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;

转载于:https://www.cnblogs.com/lanminghuai/p/11239900.html


最新回复(0)