调用API验证库存现用量和可用量代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】调用API验证库存现用量和可用量

作者:Dezai.CN / 发布于2013/1/5/ 608

inv_quantity_tree_pub.query_quantities(p_api_version_number  => 1.0,
                                             x_return_status       => l_return_status,
                                             x_msg_count           => l_msg_count,
                                             x_msg_data            => l_msg_data,
                                             p_organization_id     => l_organization_id,
                                             p_inventory_item_id   => rec_data.item_id,--item id
                                             p_tree_mode           => 2,
                                             p_is_revision_control => FALSE,
                                             p_is_lot_control      => l_lot_control_flag,
                                             p_lot_expiration_date => rec_data.transaction_date,
                                             p_is_serial_control   => FALSE,
                                             p_grade_code          => NULL, -- INVCONV      NOT NEEDED NOW                                        
                                             p_revision            => NULL,
                                             p_lot_number          => NULL,
                                             p_subinventory_code   => rec_data.pick_from_subinventory,
                                             p_locator_id          => l_locator_id,
                                             x_qoh                 => l_qoh,
                                             x_rqoh                => l_rqoh,
                                             x_qr                  => l_qr,
                                             x_qs                  => l_qs,
                                             x_att                 => l_att,
                                             x_atr                 => l_atr,
                                             x_sqoh                => l_sqoh, -- INVCONV                                  
                                             x_srqoh               => l_srqoh, -- INVCONV
                                             x_sqr                 => l_sqr, -- INVCONV
                                             x_sqs                 => l_sqs, -- INVCONV
                                             x_satt                => l_satt, -- INVCONV
                                             x_satr                => l_satr); -- INVCONV
      IF nvl(l_atr,0) = 0 THEN
        GOTO end_loop;
      END IF;

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　库存现用量　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)