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 2145: from mtl_serial_numbers MSN,

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

Line 2562: FROM mtl_serial_numbers msn, wms_license_plate_numbers wlpn

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