207:
208: -- First check if the multiple serial entry exists
209: SELECT COUNT(*)
210: INTO l_exist_temp
211: FROM DUAL
212: WHERE EXISTS
213: (SELECT 'multiple-serial'
214: FROM mtl_serial_numbers
215: WHERE inventory_item_id = p_inventory_item_id
294:
295: -- First check if the multiple serial entry exists
296: SELECT COUNT(*)
297: INTO l_exist_temp
298: FROM DUAL
299: WHERE EXISTS
300: (SELECT 'multiple-serial'
301: FROM mtl_serial_numbers
302: WHERE inventory_item_id = p_inventory_item_id