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

Line 566: FROM mtl_serial_numbers msn

562: l_pri_sec_conv NUMBER;
563:
564: CURSOR get_rsv_serials (rsv_id NUMBER) IS
565: SELECT reservation_id, serial_number
566: FROM mtl_serial_numbers msn
567: WHERE reservation_id = rsv_id
568: AND current_status = 3
569: AND NOT EXISTS (Select serial_number
570: From mtl_serial_numbers_temp msnt

Line 570: From mtl_serial_numbers_temp msnt

566: FROM mtl_serial_numbers msn
567: WHERE reservation_id = rsv_id
568: AND current_status = 3
569: AND NOT EXISTS (Select serial_number
570: From mtl_serial_numbers_temp msnt
571: Where msnt.fm_serial_number = msn.serial_number);
572: -- Possible Performance improvement
573: -- Select serials for this item into a table and use that table
574: