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 2401: -- FROM mtl_serial_numbers

2397: -- LOOP
2398: -- Modified to call common API
2399: --/*
2400: -- SELECT 'Y' INTO l_found
2401: -- FROM mtl_serial_numbers
2402: -- WHERE serial_number = p_serial_array(l_loop_index).serial_number
2403: -- AND current_status IN (1,3)
2404: -- the next line is commented out as
2405: -- currently serial number table has not been

Line 4829: FROM mtl_serial_numbers

4825: l_subinventory,
4826: l_locator_id,
4827: l_lot_number,
4828: l_lpn_id
4829: FROM mtl_serial_numbers
4830: WHERE serial_number = p_orig_serial_array(i).serial_number
4831: AND inventory_item_id =
4832: p_orig_serial_array(i).inventory_item_id;
4833: EXCEPTION

Line 5248: FROM mtl_serial_numbers

5244: l_subinventory,
5245: l_locator_id,
5246: l_lot_number,
5247: l_lpn_id
5248: FROM mtl_serial_numbers
5249: WHERE serial_number = p_to_serial_array(i).serial_number
5250: AND inventory_item_id = p_to_serial_array(i).inventory_item_id;
5251:
5252: IF (l_debug = 1) THEN