eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVTTMTX dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 337: mtl_serial_numbers_temp

333:
334: DECLARE
335: -- Delete lot and serial records from temp tables
336: cursor c3 is select group_header_id from
337: mtl_serial_numbers_temp
338: where group_header_id = v_trx_header_id
339: for update of group_header_id nowait;
340: BEGIN
341: open c3 ;

Line 342: delete mtl_serial_numbers_temp

338: where group_header_id = v_trx_header_id
339: for update of group_header_id nowait;
340: BEGIN
341: open c3 ;
342: delete mtl_serial_numbers_temp
343: where group_header_id = v_trx_header_id;
344: close c3 ;
345: EXCEPTION
346: WHEN OTHERS then

Line 416: DELETE FROM mtl_serial_numbers_temp

412: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.transaction_temp_id
413: IS NOT NULL AND mmtt.transaction_header_id IS NOT NULL);
414:
415:
416: DELETE FROM mtl_serial_numbers_temp
417: WHERE group_header_id = hdr_id AND
418: transaction_temp_id NOT IN
419: (SELECT mmtt.transaction_temp_id FROM
420: mtl_material_transactions_temp mmtt