07 2019 档案
摘要:decode(ap_invoices_pkg.get_posting_status(i.invoice_id),'Y','是','N','否') posting_flag, --会计/已入账 函数 FUNCTION get_posting_status(l_invoice_id IN NUMBER)
阅读全文
摘要:select cpp.period_name 期间名称, ccga.organization_id 组织ID, ood.ORGANIZATION_CODE 组织代码, OOD.ORGANIZATION_NAME 组织名称, msib.inventory_item_id 物料ID, msib.segm
阅读全文
摘要: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_
阅读全文