供应商类型为“员工”,计税这个地方为“否”的清单,
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;
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。