SELECT OcPoiCategory.NAME,
       OcPoiCategory.OPERATION_CENTER_ID,
       OcPoiCategory.OC_POI_CATEGORY_ID,
       OcPoiCategory.GRAPHICAL_SYMBOL,
       GuVehicleOwner.GUI_USER_ID,
       GuVehicleOwner.GU_VEHICLE_OWNER_ID,
       OcPoiCategory.SHORT_NAME
FROM OC_POI_CATEGORY OcPoiCategory,
(SELECT * FROM gu_vehicle_owner
                     WHERE gui_user_id = ?
                       AND vehicle_owner_id = ?) GuVehicleOwner, VEHICLE_OWNER VehicleOwner
WHERE OcPoiCategory.OC_POI_CATEGORY_ID = GuVehicleOwner.OC_POI_CATEGORY_ID(+)
AND OcPoiCategory.OPERATION_CENTER_ID = VehicleOwner.DEFAULT_OPERATION_CENTER_ID
AND VehicleOwner.VEHICLE_OWNER_ID = ?
AND OcPoiCategory.IS_HOME_POI_CATEGORY != 'Y'
ORDER BY 1