INSERT INTO po.po_headers_interface (interface_header_id,---sequence(po_headers_interfa ce_s) batch_id,---￥i￥HàH?K¤@-ó??|r -- process_code, action,---original,replace,update org_id,--- -- Your operating unit id document_type_code,---standard,blanket currency_code,---currenc...
INSERT INTO po.po_headers_interface (interface_header_id,---sequence(po_headers_interface_s) batch_id,---¥i¥HÀH«K¤@ӼƦr -- process_code, action,---original,replace,update org_id,--- -- Your operating unit id document_type_code,---standard,...
v_po_distributions_tbl po_distributions_interface%rowtype;--固定参数v_process_code po.po_headers_interface.process_code%type :='PENDING';--ORIGINAL 意义是生成新的PO即NEW POv_action po.po_headers_interface.action%type :='ORIGINAL'; v_approval_status po.po_headers_interface.approval_status%type...
/* BEGIN INPUT PO_HEADERS_INTERFACE TABLE */ FOR r4 IN c4 LOOP SELECT po.po_headers_interface_s.NEXTVAL INTO header_seq FROM DUAL; INSERT INTO po.po_headers_interface (batch_id, interface_header_id, action, document_type_code, process_code, reference_num, vendor_id, vendor_site_id, cu...
这个要看你用的哪一种ERP，如果是EBS，接口表参考如下信息：AP接口表：AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE 涉及的请求：应付款管理系统开放接口导入 涉及案例： 运费导AP、费用导AP PO接口表：申请：PO_REQUISITIONS_INTERFACE_ALL 涉及请求：导入申请 采购：po_headers_interface po_lines_...
接口Interface: po_requisitions_interface_all 接口API: 案例: (2). 数据库表 select * from po_requisition_headers_all where segment1 = '14304' and type_lookup_code = 'PURCHASE' and wf_item_type = 'REQAPPRV' select * from po_requisition_lines_all ...
INSERT INTO rcv_headers_interface VALUES l_iface_hdr_rec; SELECT rcv_transactions_interface_s.NEXTVAL INTO l_iface_rcv_rec.interface_transaction_id FROM dual; --l_requisition_line_id := l_req_data.requisition_line_id; l_iface_rcv_rec.header_interface_id := l_iface_hdr_rec.header_interfac...
CODE_OF_CONDUCT.md COPYING GIT-VERSION-GEN INSTALL LGPL-2.1 Makefile README.md RelNotes SECURITY.md abspath.c abspath.h aclocal.m4 add-interactive.c add-interactive.h add-patch.c advice.c advice.h alias.c alias.h alloc.c alloc.h apply.c apply.h archive-tar.c archive-zip.c archive....
CODE_OF_CONDUCT.md COPYING GIT-VERSION-GEN INSTALL LGPL-2.1 Makefile README.md RelNotes SECURITY.md abspath.c abspath.h aclocal.m4 add-interactive.c add-interactive.h add-patch.c advice.c advice.h alias.c alias.h alloc.c alloc.h apply.c apply.h archive-tar.c archive-zip.c archive....
CST_INTERFACE_STD_COST_HEADERS CST_INTERFACE_STD_DTLS_GT CST_INTERFACE_STD_HDRS_GT CST_INTERNAL_TXN_TYPES_B CST_INTERNAL_TXN_TYPES_TL CST_INTR_DOC_GT CST_INTR_ONHAND_DETAILS CST_INTR_ONHAND_VALUATIONS CST_INTR_ONHAND_VALUATIONS_GT CST_INVOICE_TO_EXP_ACCTG CST_INVOICE_TO_EXP_TXNS CST_IN...