取校验可用量

inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0

,p_init_msg_lst => fnd_api.g_false

,x_return_status => l_return_status

,x_msg_count => l_msg_count

,x_msg_data => l_msg_data

,p_organization_id => p_organization_id

,p_inventory_item_id => p_inventory_item_id

,p_tree_mode => 1

, --inv_quantity_tree_pub.g_loose_only_mode

p_is_revision_control => FALSE

,p_is_lot_control => TRUE

,p_is_serial_control => TRUE

,p_revision => NULL

,p_lot_number => NULL

,p_subinventory_code => p_subinventory_code

,p_locator_id => NULL

,x_qoh => l_onhand_qty

,x_rqoh => l_rqoh

,x_qr => l_qr

,x_qs => l_qs

,x_att => l_available_qty

,x_atr => l_atr);