1. 采购订单入库表
1.1. 表
表名 |
说明 |
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 |
错误信息表 |
1.2. 关联关系
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. 采购订单入库
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;
|