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.INV_RECEIVING_TRANSACTION dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1075: DELETE FROM mtl_transaction_lots_temp

1071: DELETE FROM mtl_transaction_lots_interface
1072: WHERE product_code = 'RCV'
1073: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1074:
1075: DELETE FROM mtl_transaction_lots_temp
1076: WHERE product_code = 'RCV'
1077: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1078:
1079: DELETE FROM mtl_serial_numbers_interface

Line 1383: -- Delete/Clear mtl_transaction_lots_temp rows

1379: END IF;
1380:
1381:
1382: -- Delete/Clear mtl_serial_numbers_temp rows
1383: -- Delete/Clear mtl_transaction_lots_temp rows
1384: -- If the Transaction Fails
1385:
1386: IF (l_debug = 1) THEN
1387: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 1',4);

Line 1405: from mtl_transaction_lots_temp mtlt

1401:
1402: delete from mtl_serial_numbers_temp msnt
1403: where msnt.transaction_temp_id in
1404: ( select mtlt.serial_transaction_temp_id
1405: from mtl_transaction_lots_temp mtlt
1406: where mtlt.transaction_temp_id in (
1407: select interface_transaction_id
1408: from rcv_transactions_interface
1409: where group_id = p_group_id )

Line 1416: delete from mtl_transaction_lots_temp mtlt

1412: IF (l_debug = 1) THEN
1413: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup mtlt 3',4);
1414: END IF;
1415:
1416: delete from mtl_transaction_lots_temp mtlt
1417: where mtlt.transaction_temp_id
1418: in ( select interface_transaction_id
1419: from rcv_transactions_interface
1420: where group_id = p_group_id );