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_MWB_QUERY_MANAGER dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2220: where exists (select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt

2216: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial '||rec.serial);
2217:
2218: select 1 into l_serial_loaded
2219: from dual
2220: where exists (select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt
2221: where wlqv.transaction_temp_id IS NOT NULL
2222: and wlqv.transaction_temp_id = msnt.transaction_temp_id
2223: and wlqv.inventory_item_id = rec.item_id
2224: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number

Line 2226: select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt

2222: and wlqv.transaction_temp_id = msnt.transaction_temp_id
2223: and wlqv.inventory_item_id = rec.item_id
2224: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number
2225: union
2226: select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt
2227: where wlqv.serial_transaction_temp_id IS NOT NULL
2228: and wlqv.serial_transaction_temp_id = msnt.transaction_temp_id
2229: and wlqv.inventory_item_id = rec.item_id
2230: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number);