SELECT
    v.vehicle_id,
    v.company_nr,
    v.numberplate,
    v.brand,
    v.model,
    vc.name,
    esp.name,
    vc.graphical_symbol,
    esp.equipment_store_place_id,
    kc.key_string,
    kc.key_code_usage_id
FROM
    vehicle               v,
    vo_vehicle_category   vc,
    equipment_store_place esp,
    gu_vehicle            gv,
    key_code              kc
WHERE
    v.vehicle_id = kc.vehicle_id (+)
    AND v.vo_vehicle_category_id = vc.vo_vehicle_category_id
    AND vc.is_object = 'Y'
    AND gv.gui_user_id = 102737
    AND gv.vehicle_id = v.vehicle_id
    AND ( kc.active_until >= SYSDATE
          OR kc.active_until IS NULL )
    AND NVL(v.vehicle_status_id,0) = 0
    AND v.last_equipment_store_place_id = esp.equipment_store_place_id(+)
    AND NVL(v.last_equipment_store_place_id, 0) != 100015;