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.WSH_TRX_HANDLER dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2842: -- of mtl_transaction_lots_interface to the two other tables

2838: -- If column is not NULL, child table exists
2839: IF (l_trx_interface_id is NOT NULL) THEN
2840:
2841: -- delete from mtl_serial_numbers_interface if there are mappings
2842: -- of mtl_transaction_lots_interface to the two other tables
2843: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2844: 'START',
2845: 'Delete mtl_serial_numbers_interface,
2846: if it is one of two child tables');

Line 2854: FROM mtl_transaction_lots_interface

2850: */
2851: DELETE FROM mtl_serial_numbers_interface
2852: WHERE transaction_interface_id IN
2853: ( SELECT serial_transaction_temp_id
2854: FROM mtl_transaction_lots_interface
2855: WHERE transaction_interface_id = l_trx_interface_id );
2856:
2857: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2858: 'END',

Line 2861: -- delete from mtl_transaction_lots_interface, if there is mapping

2857: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2858: 'END',
2859: 'Finish delete mtl_serial_numbers_interface, if any');
2860: */
2861: -- delete from mtl_transaction_lots_interface, if there is mapping
2862: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2863: 'START',
2864: 'Delete mtl_transaction_lots_interface, if there is mapping');
2865: */

Line 2864: 'Delete mtl_transaction_lots_interface, if there is mapping');

2860: */
2861: -- delete from mtl_transaction_lots_interface, if there is mapping
2862: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2863: 'START',
2864: 'Delete mtl_transaction_lots_interface, if there is mapping');
2865: */
2866: IF l_debug_on THEN
2867: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2868: END IF;

Line 2869: DELETE FROM mtl_transaction_lots_interface

2865: */
2866: IF l_debug_on THEN
2867: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2868: END IF;
2869: DELETE FROM mtl_transaction_lots_interface
2870: WHERE transaction_interface_id = l_trx_interface_id;
2871:
2872: IF l_debug_on THEN
2873: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);

Line 2876: -- there is no mapping to mtl_transaction_lots_interface

2872: IF l_debug_on THEN
2873: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2874: END IF;
2875: IF (SQL%NOTFOUND) THEN
2876: -- there is no mapping to mtl_transaction_lots_interface
2877: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2878: 'START',
2879: 'Delete mtl_serial_numbers_interface -- only child');
2880: */

Line 2936: -- MTL_TRANSACTION_LOTS_INTERFACE table.

2932: --
2933: -- Description:
2934: --
2935: -- Called by the client to lock a row in the
2936: -- MTL_TRANSACTION_LOTS_INTERFACE table.
2937: --
2938: -- ===========================================================================
2939:
2940: PROCEDURE Lock_Row (