EBS 采购订单入库

最新推荐文章于 2024-05-28 15:13:18 发布

OO好久不见OO

最新推荐文章于 2024-05-28 15:13:18 发布

阅读量3.3k

点赞数 2

文章标签： EBS 采购订单入库

本文链接：https://blog.csdn.net/longtimetoc/article/details/70653982

版权

表名	说明
rcv_headers_interface	接收单头表
rcv_transactions_interface	接收行表、接收事务、库存事务
mtl_transaction_lots_interface	批次信息
mtl_serial_numbers_interface	序列信息
mtl_supply	包括了所有可以接收入库的记录
rcv_transaction	已经接收入库的事物处理记
rcv_shipment_headers	发运头表
rcv_shipment_lines	发运行表
po_interface_errors	错误信息表

rcv_headers_interface.header_interface_id :=rcv_transactions_interface.header_interface_id

rcv_transactions_interface. interface_transaction_id

= mtl_transaction_lots_interface interface_transaction_id

 rcv_transactions_interface. interface_transaction_id

= mtl_serial_numbers_interface. interface_transaction_id

rcv_transactions_interface. interface_transaction_id

= po_interface_errors. interface_transaction_id

2.1 脚本

（该脚本12.2.6亲测可用）

DECLARE

g_group_id NUMBER :=rcv_interface_groups_s.nextval;

g_creation_date DATE:=SYSDATE;

g_created_by NUMBER:= fnd_global.user_id;

g_last_updated_by NUMBER:= fnd_global.user_id;

g_last_update_date DATE:=SYSDATE;

g_last_update_login NUMBER:= fnd_global.login_id;

l_request_id NUMBER;

l_request_flag BOOLEAN;

l_phase VARCHAR2(30);

l_dev_status VARCHAR2(30);

l_status VARCHAR2(20);

l_dev_phase VARCHAR2(200);

l_message VARCHAR2(2000);

l_header_iface rcv_headers_interface%ROWTYPE;

l_trx_iface rcv_transactions_interface%ROWTYPE;

l_rcv_lots_interface mtl_transaction_lots_interface%ROWTYPE;

BEGIN

fnd_global.apps_initialize(user_id =>1170,--fnd_global.user_id,

resp_id =>50838,--fnd_global.resp_id,

resp_appl_id =>20004);--fnd_global.resp_appl_id);

mo_global.init('PO');

mo_global.set_policy_context('S',101);

l_header_iface.last_update_date := g_last_update_date;

l_header_iface.last_updated_by := g_last_updated_by;

l_header_iface.last_update_login := g_last_update_login;

l_header_iface.creation_date := g_creation_date;

关注