销售发运相关API

最新推荐文章于 2023-12-28 16:11:01 发布
最新推荐文章于 2023-12-28 16:11:01 发布
阅读量193 收藏
点赞数
文章标签： 数据库
创建批
  v_batch_rec.order_header_id := rec.header_id;
      -- v_batch_rec.order_type_id   := rec.order_type_id;
      --- v_batch_rec.ship_
      --  v_rule_id                   := rec.rule_id;
    
      --p_batch_rec.default_stage_subinventory := 'STAGING';
    
      wsh_picking_batches_pub.create_batch(p_api_version   => 1.0,
                                           p_init_msg_list => fnd_api.g_false,
                                           p_commit        => fnd_api.g_false, --p_commit,
                                           x_msg_count     => x_msg_count,
                                           x_return_status => x_return_status,
                                           x_msg_data      => x_msg_data,
                                           p_batch_rec     => v_batch_rec,
                                           p_rule_id       => v_rule_id,
                                           p_rule_name     => p_rule_name,
                                           --  p_batch_prefix  => p_batch_prefix,
                                           
                                           x_batch_id => x_batch_id);
释放批行
wsh_picking_batches_pub.release_batch(p_api_version   => 1.0,
                                              p_init_msg_list => fnd_api.g_false,
                                              p_commit        => fnd_api.g_false,
                                              x_msg_count     => x_msg_count,
                                              x_return_status => x_return_status,
                                              x_msg_data      => x_msg_data,
                                              p_batch_id      => v_batch_id,
                                              --    p_batch_name    => p_batch_name,
                                              p_log_level    => 0,
                                              p_release_mode => 'ONLINE', -- 'CONCURRENT', --'ONLINE',
                                              x_request_id   => x_request_id);
     
   分配搬运单
        inv_replenish_detail_pub.line_details_pub(p_line_id               => cur_line_res.line_id,
                                                  x_number_of_rows        => x_number_of_rows,
                                                  x_detailed_qty          => x_detailed_qty,
                                                  x_return_status         => x_return_status,
                                                  x_msg_count             => x_msg_count,
                                                  x_msg_data              => x_msg_data,
                                                  x_revision              => x_revision,
                                                  x_locator_id            => x_locator_id,
                                                  x_transfer_to_location  => x_transfer_to_location,
                                                  x_lot_number            => x_lot_number,
                                                  x_expiration_date       => x_expiration_date,
                                                  x_transaction_temp_id   => x_transaction_temp_id,
                                                  p_transaction_header_id => NULL,
                                                  p_transaction_mode      => NULL,
                                                  p_move_order_type       => 1,
                                                  p_serial_flag           => fnd_api.g_true,
                                                  p_plan_tasks            => NULL,
                                                  p_auto_pick_confirm     => NULL,
                                                  p_commit                => NULL);
      
        --  END LOOP;
        log_msg('分配行搬运行x_return_status = ' || x_return_status || x_revision);

更新发货仓库和批次 货位 序列号
 v_trolin_tbl_type(1) := inv_trolin_util.query_row(p_line_id => cur_line_res.line_id); --Move Order Line ID
        v_trolin_tbl_type(1).db_flag := fnd_api.g_true;
        v_trolin_tbl_type(1).from_subinventory_code := p_subinvetory_code;
        v_trolin_tbl_type(1).from_locator_id := p_locator_id;
        v_trolin_tbl_type(1).quantity := p_ship_qty; ---   v_trolin_tbl_type(1).s := p_locator_id;
        /* v_trolin_tbl_type(i).lot_number := l_lot_number;
        v_trolin_tbl_type(1).serial_number_start := l_serial_number;
        v_trolin_tbl_type(1).serial_number_end := l_serial_number;*/
        v_trolin_tbl_type(1).attribute1 := 'update move order test!';
        v_trolin_tbl_type(1).operation := inv_globals.g_opr_update;
        inv_move_order_pub.process_move_order_line(p_api_version_number => 1.0,
                                                   p_init_msg_list      => fnd_api.g_false,
                                                   p_return_values      => x_return_status,
                                                   p_commit             => fnd_api.g_false,
                                                   x_return_status      => x_return_status,
                                                   x_msg_count          => x_msg_count,
                                                   x_msg_data           => x_msg_data,
                                                   p_trolin_tbl         => v_trolin_tbl_type,
                                                   p_trolin_old_tbl     => l_trolin_tbl,
                                                   x_trolin_tbl         => x_trolin_tbl);
  插入多行SN
 l_success := inv_trx_util_pub.insert_ser_trx(p_trx_tmp_id       => rec_mmtt.transaction_temp_id,
                                                       p_user_id          => rec_mmtt.created_by,
                                                       p_fm_ser_num       => l_fm_serial,
                                                       p_to_ser_num       => l_fm_serial,
                                                       p_validation_level => NULL,
                                                       p_quantity         => 1,
                                                       x_proc_msg         => l_proc_msg);
  log_msg('--------自动挑库确认开始----------');
      inv_pick_wave_pick_confirm_pub.pick_confirm(p_api_version_number => 1.0,
                                                  p_init_msg_list      => fnd_api.g_false,
                                                  p_commit             => fnd_api.g_false,
                                                  x_return_status      => x_return_status,
                                                  x_msg_count          => x_msg_count,
                                                  x_msg_data           => x_msg_data,
                                                  p_move_order_type    => 1,
                                                  p_transaction_mode   => 1,
                                                  p_trolin_tbl         => v_trolin_tbl_type,
                                                  p_mold_tbl           => l_mold_tbl,
                                                  x_mmtt_tbl           => x_mmtt_tbl,
                                                  x_trolin_tbl         => x_trolin_tbl,
                                                  p_transaction_date   => p_transaction_date);
发运确认
  wsh_deliveries_pub.delivery_action(p_api_version_number      => 1.0,
                                         p_init_msg_list           => fnd_api.g_true,
                                         x_return_status           => x_return_status,
                                         x_msg_count               => x_msg_count,
                                         x_msg_data                => x_msg_data,
                                         p_action_code             => 'CONFIRM',
                                         p_delivery_id             => l_delivery_id,
                                         p_sc_rule_id              => 1, --发运规则 select * from wsh_ship_confirm_rules
                                         p_sc_action_flag          => 'S', --s/a/c/o: Ship entered quantity--option - 'S', 'B', 'T', 'A', 'C'
                                         p_sc_stage_del_flag       => 'Y', --ship confirm create delivery for staged quantity flag
                                         p_sc_actual_dep_date      => p_transaction_date, --ship confirm actual departure date
                                         p_sc_intransit_flag       => 'Y', --ship confirm set in-transit flag
                                         p_sc_close_trip_flag      => 'Y', --ship confirm close trip flag
                                         p_sc_create_bol_flag      => 'N', --ship confirm create BOL flag
                                         p_sc_defer_interface_flag => 'Y', --ship confirm defer interface flag  --为‘Y’，手动运行连接停靠站
                                         --p_sc_report_set_id        => 6, --Ship Confirm Documents:from wsh_report_sets where usage_code='SHIP_CONFIRM'
                                         x_trip_id   => l_trip_id,
                                         x_trip_name => l_trip_name);
                 或者 提交请求  发运确认
               /* l_request_id := fnd_request.submit_request('WSH',
    'WSHASCSRS',
    '',
    to_char(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'),
    FALSE,
    1,
    to_char(p_transaction_date, 'YYYY/MM/DD HH24:MI:SS'),
    'WEBADI',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL);*/
    log_msg('--------结束自动发运确认结束----------');
           

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24023385/viewspace-2147649/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24023385/viewspace-2147649/

cimai9222
关注
Oracle EBS Interface/API(44)- 销售订单发运明细行拆分
陈显平的专栏-Oracle EBS
12-04 503
Oracle EBS 销售订单发运明细行拆分API介绍
Oracle EBS Interface/API(45)- 销售发运自动创建交货单
陈显平的专栏-Oracle EBS
12-04 508
Oracle EBS 销售发运自动创建交货单API介绍
订单发运确认api
cmn83251的博客
05-04 210
declare p_Delivery_Id Number := 2593105; x_Return_Status Varchar2(1); x_Msg_Count Number; x_Msg_Data...
ORACLE EBS 销售订单发运全流程及API详解（下）
最新发布
qq_43649830的博客
12-28 1656
EBS OM模块发运API
API实现批次序列号的销售出库
zhanzhibo的专栏
11-25 2845
转：http://blog.csdn.net/shishun123/article/details/5836525       随着制造企业对生产销售的控制越来越高，越来越多的制造型企业增加了对物料的批次、序列号的控制。我们可以在库存职责中的：物料 –> 主组织物料/组织产品 -> 库存TAB页：来这只某个库存组织中是否启用序列或者是批次。              启用物料的批次
销售订单 挑库 发放 wsh_picking_batches_pub
Oralce Ebs 专栏
08-07 4745
<br />  DECLARE<br />    <br />    l_api_name                       VARCHAR2(30) := 'sale_order_pick';<br />    l_api_version                   NUMBER   := 1.0;<br />    l_batch_info_rec                 wsh_picking_batches_pub.Batch_Info_rec;<br />    <br
销售订单 出库 发运确认
Oralce Ebs 专栏
08-07 3636
<br />DECLARE<br />  --PARAMETER FOR "WSH_DELIVERIES_PUB.Delivery_Action"<br />  p_api_version_number      NUMBER := 1.0;<br />  p_init_msg_list           VARCHAR2(30);<br />  x_msg_count               NUMBER;<br />  x_msg_data                VARCHAR2(2000
oracle多次发运,EBS 发运管理操作实例11——延迟交货（Backorder）
weixin_32767301的博客
04-03 964
延迟交货，简称延交，是指卖方没有严格按照合同所规定的时间完成交货任务，而是在合同规定的交货期后一段时间才履行交货义务。延迟交货的订单又可简称为延交订单，是未完成的客户订单或承诺量。Oracle Order Management 允许根据已发放订单行自动或人工创建延交订单。第1步：创建销售单(Sales Order)Responsibility: Order Management Super Use...
EBS开发_收款核销API
蜗牛先生快跑的博客
07-03 1733
--收款注销 Tony环境实现 20190703 DECLARE l_org_id NUMBER; x_return_status VARCHAR2(60); x_msg_count NUMBER; g_pkg_name VARCHAR2(60) := 'cux_test_scripts'; g_api_type VARCHAR2(60...
Oracle EBS子库存转移,项目转移whole LPN
经验分享--我们都在成长
08-28 3975
WMS中整箱进行子库存转移和项目转移： 将货位上的物料整箱的进行转移 IF l_status = fnd_api.g_ret_sts_success THEN         dbms_output.put_line( 'start subtransfer');         l_trx_hdr_id     := mtl_material_transacti
处理物料搬运单 -- 物料启用序列控制
chosen1brain的专栏
08-18 1687
--处理物料搬运单 --如果物料没有启用序列控制，可参考： --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_
WIP 投料报 Invalid Serial Number
weixin_30364325的博客
07-24 140
1.接口表数据检查无误 2.同样数据界面能正常完成 界面做trace SQL ID: b2mw8gjyv7guh Plan Hash: 2015965341 DELETE FROM MTL_SERIAL_NUMBERS_TEMP WHERE TRANSACTION_TEMP_ID = :b1 call count cpu...
EBS: Inventory 模块的两个 package: INV_TXN_MANAGER_PUB & INV_LPN_TRX_PUB
专栏
10-16 2774
EBS Inventory public API.
EBS API及接口
qq_32445015的博客
03-08 1892
EBS API及接口 转载 模块 应用场景 类型 API/接口 AP 付款核销 API ap_pay_invoice_pkg.ap_pay_invoice AP 应付发票审批 API ap_approval_pkg.approval AP 预付款核销 API ap_prepay_pkg.apply_prepay_fr_prepay AP 创建应付发票 API ap_import_invoices_p
ebs oracle,Oracle数据库之Oracle EBS APIs
weixin_36221941的博客
04-03 487
本文主要向大家介绍了Oracle数据库之Oracle EBS APIs，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。APIToFindSalesOrder‘sSubtotal,discount,chargesandTax(OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)APIforCancellingthePurchaseOrd...
OM模块功能&API详解
weixin_30823683的博客
01-27 396
（一）销售订单概述1.1 与车间模块关系当使用ATO类型订单时，订单管理模块会直接在车间模块中产生任务1.2 与库存模块关系在销售订单中使用的物料，单位等信息均来自库存模块，在订单执行过程中，按订单保留及销售发运等功能也会对库存模块起作用1.3 与应收模块关系销售完成后，订单管理模块会在应收接口中产生INVOICE信息，影响应收模块中销售订单对应的应收INVOICE处理操作1.4...
ORACLE EBS Sales Order销售订单【Open Interface、Open API】
热门推荐
Jane Chiu
03-31 1万+
Oracle EBS 常用接口开发参考 之 销售订单
Batch Pick Release 客制化完成
04-16 152
1.批次属性设置(FORM)2.产生批次挑库请求(一个VIEW， 两个table ),过程见DEMO PICK RELEASE ,比较复杂的请求3.批次挑库处理FORM 4. 通过API 进行结果导入[@more@]不能正常跑的...
sap销售发运单对应的后台表
09-18
SAP销售发运单对应的后台表包括以下几个： 1. VBAK：这是销售销售凭证的主要表。它存储了销售发运单的整体信息，如客户、销售区域、销售组织、交货日期等。VBAK表的关键字段是销售凭证号（VBELN）。 2. VBAP：这是销售凭证的项目表。它存储了销售订单中的每个项目的详细信息，如物料号、数量、单价等。对于一个销售发运单来说，可以有多个项目。VBAP表的关键字段是销售凭证号（VBELN）和项目号（POSNR）。 3. LIKP：这是交货凭证的主要表。它存储了销售发运单的交货相关信息，如发货日期、运输方式、运输码等。LIKP表的关键字段是交货凭证号（VBELN）。 4. LIPS：这是交货凭证的项目表。它存储了销售发运单中每个交货项目的详细信息，如物料号、数量、批次号等。对于一个销售发运单来说，可以有多个交货项目。LIPS表的关键字段是交货凭证号（VBELN）和项目号（POSNR）。 以上是一些常见的与SAP销售发运单相关的后台表，它们用于存储销售发运单的各个层面的信息，方便用户查询和管理销售发运单数据。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值