Using script to submit INV Manager to process MTI/MMTT

最新推荐文章于 2022-01-25 09:59:42 发布

田攀

最新推荐文章于 2022-01-25 09:59:42 发布

阅读量5.1k

点赞数 1

本文链接：https://blog.csdn.net/pan_tian/article/details/7711155

版权

本文介绍如何使用脚本自动提交INV Manager来处理MMTT任务，提高工作效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.Using script to submit INV Manager to process MMTT

/*
* When prompted for user_id, resp_id and resp_appl_id, ask ct enter the correct values for 
* these variables. The values can be obtained by logging into Inventory 
* reponsibility and from menu Help->Diagnostics->Examine, select block as 
* $PROFILES and field as the 3 variables and note down the values of each. 
*/
SET SEVEROUTPUT ON
declare
 l_header_id number;
 p_userid  NUMBER := &user_id;
 p_respid NUMBER  := &resp_id;
 p_applid NUMBER  := &resp_appl_id;
 retmsg varchar2(240);
 retval number;
 prnmsg varchar2(256);
 
 
 begin

    select mtl_material_transactions_s.nextval 
    into l_header_id from dual;

    update mtl_material_transactions_temp
    set process_flag = 'Y', lock_flag = NULL, transaction_mode = 3,
        error_code = NULL, error_explanation = NULL,
        transaction_header_id = l