SELECT v.vehicle_id, v.REMOTE_UNIT_ID, v.VEHICLE_OWNER_ID,
        v.person_id, v.NUMBERPLATE, v.COMPANY_NR,
        v.COLOR, v.BRAND, v.MODEL,
        v.DOOR, v.FUEL, v.RU_INSTALL_DATE,
        v.LM_COMMENT, v.VO_VEHICLE_CATEGORY_ID,
        ru.IMEI, ru.MSISDN, ru.MSISDN_DATA,
        ru.REMOTE_UNIT_TYPE_ID, ru.SERIAL_NUMBER, ru.SIM_NR,
        oc_et.GRAPHICAL_SYMBOL,
        vo.COMPANY_NAME, vo.VEHICLE_OWNER_ID,
        vovc.NAME, gui.GUI_USER_ID, vovc.GRAPHICAL_SYMBOL, decode(ru.is_container, 'Y',  'is a containter', 'not a container') Container, oc_et.str_id,
        initcap(gui.first_name || ' ' || gui.last_name) Name_Person, vd.gps_full_date
FROM vehicle v, remote_unit ru, oc_event_type oc_et, vehicle_owner vo, vo_vehicle_category vovc,
        gui_users gui, admin_center ac, operation_center oc, vehicle_data vd, str str
WHERE ru.remote_unit_id = vd.remote_unit_id
AND vd.vehicle_data_id = v.last_vehicle_data_id
AND v.vehicle_owner_id = vo.vehicle_owner_id
AND vo.vehicle_owner_id = vovc.vehicle_owner_id
AND vovc.vo_vehicle_category_id = v.vo_vehicle_category_id
AND oc_et.operation_center_id = oc.operation_center_id
AND oc_et.str_id = str.str_id
AND gui_user_id = 101712
ORDER BY vd.gps_full_date;