SELECT NVL2 (VoPersonCategory.short_name, VoPersonCategory.NAME, VoPersonCategory.short_name || ' ' || VoPersonCategory.NAME) AS Name,
       VoPersonCategory.VEHICLE_OWNER_ID,
       VoPersonCategory.GRAPHICAL_SYMBOL AS GRAPHICAL_SYMBOL1,
       VoPersonCategory.VO_PERSON_CATEGORY_ID,
       GuVehicleOwner.GU_VEHICLE_OWNER_ID,
       GuVehicleOwner.GUI_USER_ID
FROM VO_PERSON_CATEGORY VoPersonCategory,
 (SELECT *  FROM gu_vehicle_owner
                     WHERE gui_user_id = ?
                       AND vehicle_owner_id = ?) GuVehicleOwner
WHERE VoPersonCategory.vo_person_category_id = GuVehicleOwner.vo_person_category_id(+)
AND VoPersonCategory.vehicle_owner_id = ?
ORDER BY 1