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 607: FROM mtl_serial_numbers msn

603: l_fulfill_base varchar2(1):='P';
604:
605: CURSOR get_rsv_serials (rsv_id NUMBER) IS
606: SELECT reservation_id, serial_number
607: FROM mtl_serial_numbers msn
608: WHERE reservation_id = rsv_id
609: AND current_status = 3
610: AND NOT EXISTS (Select serial_number
611: From mtl_serial_numbers_temp msnt

Line 611: From mtl_serial_numbers_temp msnt

607: FROM mtl_serial_numbers msn
608: WHERE reservation_id = rsv_id
609: AND current_status = 3
610: AND NOT EXISTS (Select serial_number
611: From mtl_serial_numbers_temp msnt
612: Where msn.serial_number between msnt.fm_serial_number and nvl(msnt.to_serial_number,msnt.fm_serial_number)
613: and (msn.group_mark_id = msnt.transaction_temp_id
614: OR msn.group_mark_id = msnt.group_header_id
615: )