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.WMS_RFID_DEVICE_PUB dependencies on MTL_SERIAL_NUMBERS

Line 2144: from mtl_serial_numbers MSN,

2140:
2141: BEGIN
2142: select MSN.LPN_ID,WLPN.outermost_LPN_ID
2143: INTO l_lpn_id, l_serial_pallet_id
2144: from mtl_serial_numbers MSN,
2145: WMS_LICENSE_PLATE_NUMBERS wlpn
2146: WHERE MSN.inventory_item_id = l_item_id
2147: AND MSN.serial_number = l_SERIAL_NUMBER
2148: AND MSN.lpn_id = WLPN.LPN_ID;

Line 2561: FROM mtl_serial_numbers msn, wms_license_plate_numbers wlpn

2557: AND wlpn.parent_lpn_id IS NOT NULL;
2558:
2559:
2560: SELECT COUNT(1) INTO l_expected_ser_cnt
2561: FROM mtl_serial_numbers msn, wms_license_plate_numbers wlpn
2562: WHERE msn.lpn_id = wlpn.lpn_id
2563: and wlpn.outermost_lpn_id = p_pallet_lpn_id;
2564:
2565: IF (l_debug = 1) THEN