账户别名接收事务处理

最新推荐文章于 2025-04-18 00:39:27 发布

置顶

萌虫小焕焕

最新推荐文章于 2025-04-18 00:39:27 发布

阅读量2.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle EBS 接口文章标签：事务处理账户接收 oracle ebs

本文链接：https://blog.youkuaiyun.com/gh320/article/details/39530157

--账户别名接收
SELECT mtl_material_transactions_s.nextval
INTO l_mtl_txn_itf_rec.transaction_interface_id
FROM dual;
l_mtl_txn_itf_rec.transaction_header_id := l_mtl_txn_itf_rec.transaction_interface_id;
l_mtl_txn_itf_rec.transaction_mode      := 3;
l_mtl_txn_itf_rec.process_flag          := 1;
l_mtl_txn_itf_rec.transaction_type_id   := 41;
l_mtl_txn_itf_rec.transaction_source_id := i.disposition_id;
l_mtl_txn_itf_rec.organization_id       := i.organization_id;
l_mtl_txn_itf_rec.inventory_item_id     := i.n_inventory_item_id; --l_mtl_txn_int_rec.inventory_item_id;
l_mtl_txn_itf_rec.subinventory_code     := i.n_subinventory_code; --l_mtl_txn_int_rec.subinventory_code;
l_mtl_txn_itf_rec.locator_id            := i.n_locator_id; --l_mtl_txn_int_rec.locator_id;
l_mtl_txn_itf_rec.transaction_quantity := i.n_onhand_quantity; --l_mtl_txn_int_rec.transaction_quantity;
l_mtl_txn_itf_rec.transaction_uom       := i.uom_code; --l_mtl_txn_int_rec.uom_code;
l_mtl_txn_itf_rec.transaction_date      := nvl(i.transaction_date, SYSDATE); --l_mtl_txn_int_rec.onhand_creation_date /*g_date*/

/*l_mtl_txn_itf_rec.source_header_id := null;--l_mtl_txn_itf_rec.transaction_header_id;
&nb