摘要:
decode(ap_invoices_pkg.get_posting_status(i.invoice_id),'Y','是','N','否') posting_flag, --会计/已入账 函数 FUNCTION get_posting_status(l_invoice_id IN NUMBER) 阅读全文
摘要:
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_ 阅读全文
摘要:
EXCEL的列:组织id,供应商编号,供应商地点,料号,最小拆分量、采购提前期、最小订购量、最小包装量 --采购导入更新MOQ四个值,若有为空的那列,会保留原来的值,不会去更新那列的值 PROCEDURE UPDATE_PO_MOQ AS CURSOR PO_MOQ_CUR IS SELECT ID 阅读全文
摘要:
PROCEDURE Get_wip_accept_item_date(p_use_id in number, p_org_id IN NUMBER, p_start_date IN DATE, p_end_date IN DATE) is cursor accept_cursor(p_org num 阅读全文