334: -- the picking base sql --
335: -- --
336: -- Input Parameters --
337: -- p_mode --
338: -- equals inv_quantity_tree_pvt.g_reservation_mode or --
339: -- inv_quantity_tree_pvt.g_transaction_mode --
340: -- p_is_lot_control --
341: -- true or false --
342: -- p_asset_sub_only --
335: -- --
336: -- Input Parameters --
337: -- p_mode --
338: -- equals inv_quantity_tree_pvt.g_reservation_mode or --
339: -- inv_quantity_tree_pvt.g_transaction_mode --
340: -- p_is_lot_control --
341: -- true or false --
342: -- p_asset_sub_only --
343: -- true or false --
953: -- You should turn on serveroutput to see the output. --
954: -- --
955: -- Input Parameters --
956: -- p_mode --
957: -- equals inv_quantity_tree_pvt.g_loose_mode or --
958: -- inv_quantity_tree_pvt.g_transaction_mode --
959: -- p_organization_id --
960: -- organization_id --
961: -- p_inventory_item_id --
954: -- --
955: -- Input Parameters --
956: -- p_mode --
957: -- equals inv_quantity_tree_pvt.g_loose_mode or --
958: -- inv_quantity_tree_pvt.g_transaction_mode --
959: -- p_organization_id --
960: -- organization_id --
961: -- p_inventory_item_id --
962: -- inventory_item_id --