APPS.WMS_TASK_SKIPPED dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 240: ,mtl_serial_numbers_temp msnt

236: ,last_updated_by = l_last_updated_by
237: WHERE serial_number IN
238: (SELECT serial_number
239: FROM mtl_serial_numbers msn
240: ,mtl_serial_numbers_temp msnt
241: WHERE msn.serial_number = msnt.fm_serial_number
242: AND msnt.transaction_temp_id in (l_task_id, l_serial_transaction_temp_id))
243: and current_organization_id = l_org_id;
244:

Line 251: delete mtl_serial_numbers_temp

247: mydebug('wms_task_skipped:: No MSN record found.');
248: END IF;
249:
250: ELSE
251: delete mtl_serial_numbers_temp
252: where transaction_temp_id in (l_task_id, l_serial_transaction_temp_id);
253:
254: IF SQL%NOTFOUND THEN
255: IF (l_debug =1 ) then