欢迎投稿

今日深度:

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

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


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;

www.htsjk.Com true http://www.htsjk.com/oracle/29795.html NewsArticle 供应商类型为“员工”,计税这个地方为“否”的清单, select hou.name, vendor_namefrom po_vendor_sites_all pvs, ap_suppliers ass, hr_operating_units houwhere pvs.auto_tax_calc_flag = 'N'and pvs.vendor_id = ass.vendor_i...
相关文章
    暂无相关文章
评论暂时关闭