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_RESERVATION_VALIDATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 2525: -- FROM mtl_serial_numbers

2521: -- LOOP
2522: -- Modified to call common API
2523: --/*
2524: -- SELECT 'Y' INTO l_found
2525: -- FROM mtl_serial_numbers
2526: -- WHERE serial_number = p_serial_array(l_loop_index).serial_number
2527: -- AND current_status IN (1,3)
2528: -- the next line is commented out as
2529: -- currently serial number table has not been

Line 4993: FROM mtl_serial_numbers

4989: l_subinventory,
4990: l_locator_id,
4991: l_lot_number,
4992: l_lpn_id
4993: FROM mtl_serial_numbers
4994: WHERE serial_number = p_orig_serial_array(i).serial_number
4995: AND inventory_item_id =
4996: p_orig_serial_array(i).inventory_item_id;
4997: EXCEPTION

Line 5412: FROM mtl_serial_numbers

5408: l_subinventory,
5409: l_locator_id,
5410: l_lot_number,
5411: l_lpn_id
5412: FROM mtl_serial_numbers
5413: WHERE serial_number = p_to_serial_array(i).serial_number
5414: AND inventory_item_id = p_to_serial_array(i).inventory_item_id;
5415:
5416: IF (l_debug = 1) THEN