Inventory onhand可用量查询API
考虑预留
inv_quantity_tree_pub.query_quantities
(p_api_version_number => 1
, p_init_msg_lst => 'F'
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_organization_id => to_number(c1.attribute8)--p_organization_id
, p_inventory_item_id => to_number(c1.attribute9)--p_inventory_item_id
, p_tree_mode => 1
, p_is_revision_control => v_00rev_control
, p_is_lot_control => v_00lot_control
, p_is_serial_control => null
, p_demand_source_type_id => 2--p_source_type_id
, p_demand_source_header_id => null
, p_demand_source_line_id => null
, p_demand_source_name => null
, p_lot_expiration_date => sysdate
, p_revision => c1.revision--p_revision
, p_lot_number => c1.attribute3--p_lot_number
, p_subinventory_code => c1.attribute4--p_subinventory_code
, p_locator_id => null--p_locator_id
, p_onhand_source => 3
, x_qoh => l_qoh
, x_rqoh => l_rqoh
, x_qr => l_qr
, x_qs => l_qs
, x_att => v_available_to_tran_qty--l_att
, x_atr => l_atr
, p_transfer_subinventory_code => null
, p_cost_group_id => null
, p_lpn_id => null--p_lpn_id
, p_transfer_locator_id => null
);
