SO保留库存

最新推荐文章于 2024-01-30 11:11:47 发布
最新推荐文章于 2024-01-30 11:11:47 发布
阅读量210 收藏
点赞数

-- Created on 2013-7-8 by ADMINISTRATOR
declare
  -- Local variables here
  l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
  l_dummy_sn inv_reservation_global.serial_number_tbl_type;
  x_dummy_sn inv_reservation_global.serial_number_tbl_type;
  l_org_id number := 4555;
  l_item_id number := 212959;
  l_header_id number := 3556857; /*mtl_sales_orders.sales_order_id,注意不是oe_order_headers_all.header_id*/
  l_line_id number := 389037;
  x_qty_reserved number;
  x_reserved_id number;
  x_msg_count number;
  x_return_status varchar2(1);
  x_msg_data varchar2(2000);
begin
  -- Test statements here
     mo_global.init('AR');
    mo_global.set_policy_context('S', 4555);
    fnd_global.apps_initialize(1013475,
                               59166,
                               660);
 
    mo_global.init('ONT');
    oe_msg_pub.initialize;
     /*l_rsv_rec.requirement_date := sysdate;
    l_rsv_rec.organization_id := l_org_id;
    l_rsv_rec.inventory_item_id := l_item_id;
    l_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_oe; 
    l_rsv_rec.demand_source_name := null;
    l_rsv_rec.demand_source_header_id := l_header_id;
    l_rsv_rec.demand_source_line_id := l_line_id;
  --  l_rsv_rec.primary_uom_code := 'Ea';
  --  l_rsv_rec.reservation_uom_code := 'Ea';
    l_rsv_rec.reservation_quantity := 1;
    l_rsv_rec.primary_reservation_quantity := 1;
    l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
   l_rsv_rec.ship_ready_flag := null;
    l_rsv_rec.attribute15 := null;
    l_rsv_rec.attribute14 := null;
    l_rsv_rec.attribute13 := null;
    l_rsv_rec.attribute12 := null;
    l_rsv_rec.attribute11 := null;
    l_rsv_rec.attribute10 := null;
    l_rsv_rec.attribute9 := null;
    l_rsv_rec.attribute8 := null;
    l_rsv_rec.attribute7 := null;
    l_rsv_rec.attribute6 := null;
    l_rsv_rec.attribute5 := null;
    l_rsv_rec.attribute4 := null;
    l_rsv_rec.attribute3 := null;
    l_rsv_rec.attribute2 := null;
    l_rsv_rec.attribute1 := null;
    l_rsv_rec.attribute_category := null;
    l_rsv_rec.lpn_id := null;
    l_rsv_rec.pick_slip_number := null;
    l_rsv_rec.lot_number_id := null;
    l_rsv_rec.lot_number := null;
    l_rsv_rec.locator_id := null;
    l_rsv_rec.subinventory_id := null;
    l_rsv_rec.subinventory_code := null;
    l_rsv_rec.revision := null;
    l_rsv_rec.supply_source_line_detail := null;
    l_rsv_rec.supply_source_name := null;
    l_rsv_rec.supply_source_line_id := null;
    l_rsv_rec.supply_source_header_id := null;
    l_rsv_rec.external_source_line_id := null;
    l_rsv_rec.external_source_code := null;
    l_rsv_rec.autodetail_group_id := null;
    l_rsv_rec.reservation_uom_id := null;
    l_rsv_rec.reservation_uom_code := null;
    l_rsv_rec.primary_uom_id := null;
    l_rsv_rec.demand_source_delivery := null;*/
   /* inv_reservation_pub.create_reservation(p_api_version_number => 1.0
                                          ,p_init_msg_lst => fnd_api.G_TRUE
                                          ,x_return_status => x_return_status
                                          ,x_msg_count => x_msg_count
                                          ,x_msg_data => x_msg_data
                                          ,p_rsv_rec => l_rsv_rec
                                          ,p_serial_number => l_dummy_sn
                                          ,x_serial_number => x_dummy_sn
                                          ,x_quantity_reserved => x_qty_reserved
                                          ,x_reservation_id => x_reserved_id);*/
      inv_quantity_tree_pub.clear_quantity_cache; --明明系统上查询物料有保留量,但是保留的时候确说没有保留量,加此语句                                  
      inv_reservation_form_pkg.create_reservation(p_api_version_number   => 1.0,
                                                      p_init_msg_lst         => fnd_api.g_true,
                                                      x_return_status        => x_return_status,
                                                      x_msg_count            => x_msg_count,
                                                      x_msg_data             => x_msg_data,
                                                      p_requirement_date     => SYSDATE,
                                                      p_organization_id      => l_org_id,
                                                      p_inventory_item_id    => l_item_id,
                                                      p_demand_type_id       =>inv_reservation_global.g_source_type_oe,
                                                      p_demand_name          => null, --'Sales order',
                                                      p_demand_header_id     => l_header_id, --MT_SALES_ORDERS --sales_order_id
                                                      p_demand_line_id       => l_line_id, --so_line_id
                                                      p_demand_delivery_id   => NULL,
                                                      p_primary_uom_code     => NULL, --'PCS',
                                                      p_primary_uom_id       => NULL,
                                                      p_reservation_uom_code => NULL, --'PCS',
                                                      p_reservation_uom_id   => NULL,
                                                      p_reservation_quantity => 1,
                                                      p_primary_rsv_quantity => 1,
                                                      p_autodetail_group_id  => NULL,
                                                      p_external_source_code => NULL,
                                                      p_external_source_line => NULL,
                                                      p_supply_type_id       => inv_reservation_global.g_source_type_inv, --17, --pr
                                                      --po_header_id--                                             
                                                      p_supply_header_id => null,
                                                      -- po lication_id
                                                      -- pr requisition_line_id
                                                      p_supply_line_id           => null,
                                                      p_supply_name              => NULL,
                                                      p_supply_line_detail       => NULL,
                                                      p_revision                 => NULL,
                                                      p_subinventory_code        => NULL,
                                                      p_subinventory_id          => NULL,
                                                      p_locator_id               => NULL,
                                                      p_lot_number               => NULL,
                                                      p_lot_number_id            => NULL,
                                                      p_pick_slip_number         => NULL,
                                                      p_lpn_id                   => NULL,
                                                      p_ship_ready_flag          => NULL,
                                                      p_attribute_category       => NULL,
                                                      p_attribute1               => NULL,
                                                      p_attribute2               => NULL,
                                                      p_attribute3               => NULL,
                                                      p_attribute4               => NULL,
                                                      p_attribute5               => NULL,
                                                      p_attribute6               => NULL,
                                                      p_attribute7               => NULL,
                                                      p_attribute8               => NULL,
                                                      p_attribute9               => NULL,
                                                      p_attribute10              => NULL,
                                                      p_attribute11              => NULL,
                                                      p_attribute12              => NULL,
                                                      p_attribute13              => NULL,
                                                      p_attribute14              => NULL,
                                                      p_attribute15              => NULL,
                                                      p_partial_reservation_flag => fnd_api.g_false,
                                                      p_force_reservation_flag   => fnd_api.g_false,
                                                      p_validation_flag          => fnd_api.g_true,
                                                      x_quantity_reserved        => x_qty_reserved,
                                                      x_reservation_id           => x_reserved_id);                                     
    if x_return_status = 'S' then
      dbms_output.put_line('qty reserved:'||x_qty_reserved);
      dbms_output.put_line('reservation id:'||x_reserved_id);
    else
      fnd_msg_pub.Count_And_Get(p_encoded => fnd_api.G_FALSE
                                ,p_count => x_msg_count
                                ,p_data => x_msg_data);
      dbms_output.put_line('msg data:'||x_msg_data);  
      if x_msg_count > 0 then
        for i in 1 .. x_msg_count loop
          dbms_output.put_line(i||':'||substr(fnd_msg_pub.Get(p_msg_index => i,p_encoded => fnd_api.G_FALSE),1,255));
        end loop;
      end if;                      
    end if;                                                             
end;

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

转载于:http://blog.itpub.net/13387766/viewspace-766489/

cizha3055
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
API及接口清单
kelly_yun的博客
10-28 1388
API及接口清单
Oracle EBS API及接口清单
Tina_ZYT的博客
02-01 568
------------------------------------------------------------------------------------原文链接：https://www.cnblogs.com/lizicheng/p/9521742.html
Oracle EBS INV创建保留
weixin_30539625的博客
11-26 377
CREATE or REPPLACE PROCEDURE CreateReservation AS -- Common Declarations l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(2) := FND_API.G_TRUE; ...
Inventory API Related Nots
田攀的日志
06-19 7220
Note 729998.1:Oracle Inventory Management Application Program Interface (APIs)Note.729261.1How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header APINote.729263.1How To Cr
ebs - api
weixin_30414155的博客
12-29 297
--保留 inv_reservation_pub.query_reservation --查询 inv_reservation_pub.create_reservation --创建 inv_reservation_pub.relieve_reservation--释放，释放时先查询保留 --动态创建货位 inv_loc_wms_pub.create_locator ...
libsqlite.so 下载文件
09-20
《libsqlite.so：Android系统中的SQLite数据库引擎》 在Android应用开发中，SQLite是一个不可或缺的组件，它是一个轻量级的、开源的、基于事务的SQL数据库引擎。libsqlite.so是SQLite在Android系统中的动态链接库，...
libsnappyjava.so
最新发布
04-05
libsnappyjava.so
libpthread.so.0
05-31
《深入理解Linux系统库：libpthread.so.0》 在Linux操作系统中，`libpthread.so.0`是一个至关重要的共享库，它包含了实现线程功能的接口和代码。这个库是POSIX线程（通常称为pthreads）在Linux上的实现，是多线程...
liblicense.so
02-06
so库文件示例
douyin 23.3.0 so
12-08
douyin 23.3.0 libsscronet.so
Oracle EBS 销售时物料保留出错相关症状和处理方法
陈显平的专栏-Oracle EBS
09-07 9632
之前,我在Oracle EBS R12版本中遇到过销售订单发运时"物料保留出错",伴随着物料事处处理接口错误和发运事务处事处理不了 背景: 销售订单发运事务处理或销售订发放,子库存的保留和物料事务处理出错. 主要症状: 1.INV:物料保留窗体中的题头的值为空 2.IN
ORACLE EBS 销售订单发运全流程及API详解（上）
kikiwhq的专栏
01-30 785
ORACLE EBS 销售订单发运全流程及API详解（上）
取物料工作台-现有量
章
05-10 627
电子表—取现有量 物料工作台 现有量 inv_quantity_tree_pub.clear_quantity_cache;         inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0                                               ,p_init_m...
EBS INV计算现有量(标准API)
夏日青草
11-08 4844
在OracleApplication中，standard 功能是调用下面API来计算Onhand Quantity的： inv_quantity_tree_pub.query_quantities         ( p_api_version_number  => 1.0,          p_init_msg_lst        => 'F',          x_return_
OM模块功能&API详解
weixin_30823683的博客
01-27 394
（一）销售订单概述1.1 与车间模块关系当使用ATO类型订单时，订单管理模块会直接在车间模块中产生任务1.2 与库存模块关系在销售订单中使用的物料，单位等信息均来自库存模块，在订单执行过程中，按订单保留及销售发运等功能也会对库存模块起作用1.3 与应收模块关系销售完成后，订单管理模块会在应收接口中产生INVOICE信息，影响应收模块中销售订单对应的应收INVOICE处理操作1.4...
客制化物料搬运单流程
mia502908009的专栏
01-25 2819
1.首先对制做需要处理的搬运单对应的料号批次数量信息，然后通过excel导入临时表     ----2016.1.7整理导入Excel的临时数据： --STP1:切换到系统管理员(或者应用开发员)-->通用文件管理器-->加载 功能，将要上传的Excel文档加载上去。 --STP2:直接在Toad执行下面的语句，读取Excel的内容。 DECLARE    L_BLOB BLOB;
Oracle EBS INV更新保留
weixin_30345577的博客
11-26 231
CREATE or REPPLACE PROCEDURE UpdateReservation AS -- Common Declarations l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(2) := FND_API.G_TRUE; ...
EBS API及接口
qq_32445015的博客
03-08 1845
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
在Oracle中计算Onhand Quantity
weixin_33720452的博客
11-23 421
在Oracle Application中，standard 功能是调用下面API来计算Onhand Quantity的： inv_quantity_tree_pub.query_quantities         ( p_api_version_number  => 1.0,          p_init_msg_lst        => 'F',          x_ret...
Android SO加载深度探索：从加载到链接
"Android so加载深入分析" 这篇文档详细剖析了Android系统中动态链接库（SO文件）的加载过程，从Java层到Native层的各个环节。作者ManyFace在2016年2月7日发布了这份深入分析，主要针对Android L版本的源码进行了...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值