Counting the on hand quantities by API inv_quantity_tree_pub.query_quantities

Oracle ERP R11

DECLARE

x_return_status VARCHAR2 (1);

x_msg_data VARCHAR2 (4000);

x_msg_count NUMBER;

x_qoh NUMBER;

x_rqoh NUMBER;

x_qr NUMBER;

x_qs NUMBER;

x_att NUMBER;

x_atr NUMBER;

x_sqoh NUMBER;

x_srqoh NUMBER;

x_sqr NUMBER;

x_sqs NUMBER;

x_satt NUMBER;

x_sqtr NUMBER;

BEGIN

inv_globals.set_org_id (7324);

inv_quantity_tree_pub.clear_quantity_cache;

inv_quantity_tree_pub.query_quantities

(p_api_version_number => 1.0,

x_return_status => x_return_status,

x_msg_count => x_msg_count,

x_msg_data => x_msg_data,

p_organization_id => 7324,

p_inventory_item_id => 884054,

p_tree_mode => 2,

p_is_revision_control => FALSE,

p_is_lot_control => TRUE,

p_is_serial_control => FALSE,

p_revision => NULL,

p_lot_number => NULL,

p_subinventory_code =>'WH',

p_locator_id => NULL,

x_qoh => x_qoh,

x_rqoh => x_rqoh,

x_qr => x_qr,

x_qs => x_qs,

x_att => x_att,

x_atr => x_atr

);

DBMS_OUTPUT.put_line (x_return_status);

DBMS_OUTPUT.put_line (x_msg_count);

DBMS_OUTPUT.put_line (x_qoh);

DBMS_OUTPUT.put_line (x_rqoh);

DBMS_OUTPUT.put_line (x_qr);

DBMS_OUTPUT.put_line (x_qs);

DBMS_OUTPUT.put_line (x_att);

DBMS_OUTPUT.put_line (x_atr);

END;

 

x_att   ======>  available to transact

 x_atr  ======>  available to reserve

 

 

Oracle ERP R12

DECLARE
x_return_status VARCHAR2 (1);
x_msg_data VARCHAR2 (4000);
x_msg_count NUMBER;
x_qoh NUMBER;
x_rqoh NUMBER;
x_qr NUMBER;
x_qs NUMBER;
x_att NUMBER;
x_atr NUMBER;
x_sqoh NUMBER;
x_srqoh NUMBER;
x_sqr NUMBER;
x_sqs NUMBER;
x_satt NUMBER;
x_sqtr NUMBER;
BEGIN
inv_globals.set_org_id (207);
inv_quantity_tree_pub.clear_quantity_cache;
inv_quantity_tree_pub.query_quantities (p_api_version_number => 1.0
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_organization_id => 207
, p_inventory_item_id => 167742
, p_tree_mode => 1
, p_is_revision_control => FALSE
, p_is_lot_control => TRUE
, p_is_serial_control => TRUE
, p_grade_code => NULL
, p_revision => NULL
, p_lot_number => NULL
, p_subinventory_code => NULL
, p_locator_id => NULL
, x_qoh => x_qoh
, x_rqoh => x_rqoh
, x_qr => x_qr
, x_qs => x_qs
, x_att => x_att
, x_atr => x_atr
, x_sqoh => x_sqoh
, x_srqoh => x_srqoh
, x_sqr => x_sqr
, x_sqs => x_sqs
, x_satt => x_satt
, x_satr => x_sqtr
);
DBMS_OUTPUT.put_line (x_return_status);
DBMS_OUTPUT.put_line (x_msg_count);
DBMS_OUTPUT.put_line (x_qr);
DBMS_OUTPUT.put_line (x_qoh);
DBMS_OUTPUT.put_line (x_rqoh);
END;