DBA Data[Home] [Help]

APPS.INV_CYC_SERIALS dependencies on DUAL

Line 176: FROM DUAL

172:
173: -- First check if the multiple serial entry exists
174: SELECT COUNT(*)
175: INTO l_exist_temp
176: FROM DUAL
177: WHERE EXISTS
178: (SELECT 'multiple-serial'
179: FROM mtl_serial_numbers
180: WHERE inventory_item_id = p_inventory_item_id

Line 250: FROM DUAL

246:
247: -- First check if the multiple serial entry exists
248: SELECT COUNT(*)
249: INTO l_exist_temp
250: FROM DUAL
251: WHERE EXISTS
252: (SELECT 'multiple-serial'
253: FROM mtl_serial_numbers
254: WHERE inventory_item_id = p_inventory_item_id