<pre name="code" class="sql">--处理物料搬运单
--如果物料没有启用序列控制,可参考:
--http://blog.csdn.net/cunxiyuan108/article/details/6006961
DECLARE
l_mo_line_detail_rec inv_mo_line_detail_util.g_mmtt_rec;
l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
x_mmtt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
p_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
l_mesg_len NUMBER;
--
l_transaction_temp_id NUMBER; --临时表的id
p_line_id NUMBER := 334214;
p_header_id NUMBER := 107313;
p_inventory_item_id NUMBER := 143116;
l_transaction_header_id NUMBER;
l_return_status NUMBER;
--
x_return_status VARCHAR2(1);
x_number_of_rows NU
处理物料搬运单 -- 物料启用序列控制
最新推荐文章于 2022-05-22 09:58:18 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)