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_DEVICE_INTEGRATION_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 927: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,

923: wdr.status_msg STATUSMSG, wdr.last_update_date timestamp,
924: wdr.business_event_id bus_event_id
925: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
926: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
927: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
928: mtl_system_items_kfv msik
929: WHERE ml1.lookup_type(+)= 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
930: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
931: AND ml2.lookup_code(+) = wdr.business_event_id

Line 964: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,

960: wdr.serial_number||l_seperator||wdr.status_msg||l_seperator||wdr.last_update_date
961: CSV_LINE
962: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
963: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
964: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
965: mtl_system_items_kfv msik
966: WHERE ml1.lookup_type(+) = 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
967: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
968: AND ml2.lookup_code(+) = wdr.business_event_id