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 947: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,

943: wdr.status_msg STATUSMSG, wdr.last_update_date timestamp,
944: wdr.business_event_id bus_event_id
945: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
946: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
947: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
948: mtl_system_items_kfv msik
949: WHERE ml1.lookup_type(+)= 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
950: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
951: AND ml2.lookup_code(+) = wdr.business_event_id

Line 984: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn1, --Added for Bug#8512121

980: wdr.serial_number||l_seperator||wdr.status_msg||l_seperator||wdr.last_update_date
981: CSV_LINE
982: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
983: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
984: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn1, --Added for Bug#8512121
985: mtl_system_items_kfv msik
986: WHERE ml1.lookup_type(+) = 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
987: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
988: AND ml2.lookup_code(+) = wdr.business_event_id