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;