879: END IF;
880:
881: SELECT reservable_type,lpn_controlled_flag
882: INTO l_reservable_type, l_lpn_controlled_flag
883: FROM mtl_secondary_inventories
884: WHERE secondary_inventory_name LIKE (p_to_subinventory_code)
885: AND organization_id = p_organization_id;
886:
887: IF (l_debug = 1) THEN
1114: END IF;
1115:
1116: SELECT reservable_type,lpn_controlled_flag
1117: INTO l_reservable_type, l_lpn_controlled_flag
1118: FROM mtl_secondary_inventories
1119: WHERE secondary_inventory_name LIKE (p_to_subinventory_code)
1120: AND organization_id = p_organization_id;
1121:
1122: IF (l_debug = 1) THEN