DBA Data[Home] [Help]

APPS.INV_CYC_SERIALS dependencies on DUAL

Line 211: FROM DUAL

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

Line 298: FROM DUAL

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