SELECT GuVehicleOwner.GU_VEHICLE_OWNER_ID,
       GuVehicleOwner.GUI_USER_ID,
       GuVehicleOwner.ORDER_NUM,
       GuVehicleOwner.RIGHT_GRANTED,
       GuVehicleOwner.VEHICLE_OWNER_ID,
       GuVehicleOwner.VO_GROUP_ID,
       GuVehicleOwner.VO_PERSON_CATEGORY_ID,
       GuVehicleOwner.VO_VEHICLE_CATEGORY_ID,
       VoGroup.NAME,
       VoGroup.VO_GROUP_ID AS VO_GROUP_ID1,
       VoPersonCategory.NAME AS NAME1,
       VoPersonCategory.VO_PERSON_CATEGORY_ID AS VO_PERSON_CATEGORY_ID1,
       VoVehicleCategory.NAME AS NAME2,
       VoVehicleCategory.VO_VEHICLE_CATEGORY_ID AS VO_VEHICLE_CATEGORY_ID1,
       (VoGroup.NAME) AS VIEW_ATTR,
       (VoPersonCategory.NAME) AS VIEW_ATTR,
       (VoVehicleCategory.NAME) AS VIEW_ATTR,
       (OcPoiCategory.NAME) AS VIEW_ATTR,
       OcPoiCategory.OC_POI_CATEGORY_ID,
       GuVehicleOwner.OC_POI_CATEGORY_ID AS OC_POI_CATEGORY_ID1,
       GuVehicleOwner.GU_PERSON_GENERATION_TYPE_ID,
       NVL2 (OBS.short_name,  OBS.short_name || ' ' || OBS.name,  OBS.name) AS OBS,
       NVL2 (VoProfessionalGroup.short_code, VoProfessionalGroup.name, VoProfessionalGroup.short_code ||  ' ' || VoProfessionalGroup.name) AS VIEW_ATTR,
       NVL2 (VoLegalEntity.Short_code, VoLegalEntity.Short_code || ' ' || VoLegalEntity.name, VoLegalEntity.name) AS VIEW_ATTR,
       GuVehicleOwner.VO_LEGAL_ENTITY_ID,
       GuVehicleOwner.OBS_ID,
       GuVehicleOwner.VO_PROFESSIONAL_GROUP_ID,
       GuVehicleOwner.HIRING_P_OC_POI_ID,
       GuVehicleOwner.ACCOUNTING_HIRING_P_OC_POI_ID,
       (OcPoi.name) AS VIEW_ATTR,
       (OcPoi1.name) AS VIEW_ATTR,
       OcPoi1.POI_ID,
       OcPoi.POI_ID AS POI_ID1,
       GuVehicleOwner.VO_ROLE_ID
FROM GU_VEHICLE_OWNER GuVehicleOwner, VO_GROUP VoGroup, V_UPDATABLE_VO_PERSON_CATEGORY VoPersonCategory, VO_VEHICLE_CATEGORY VoVehicleCategory, OC_POI_CATEGORY OcPoiCategory, OF_OWNER.OBS Obs, OF_OWNER.VO_LEGAL_ENTITY VoLegalEntity, OF_OWNER.VO_PROFESSIONAL_GROUP VoProfessionalGroup, OC_POI OcPoi, OC_POI OcPoi1
WHERE GuVehicleOwner.VO_PERSON_CATEGORY_ID = VoPersonCategory.VO_PERSON_CATEGORY_ID(+)
AND GuVehicleOwner.VO_VEHICLE_CATEGORY_ID = VoVehicleCategory.VO_VEHICLE_CATEGORY_ID(+)
AND GuVehicleOwner.VO_GROUP_ID = VoGroup.VO_GROUP_ID(+)
AND GuVehicleOwner.OC_POI_CATEGORY_ID = OcPoiCategory.OC_POI_CATEGORY_ID(+)
AND GuVehicleOwner.obs_id = Obs.obs_id (+)
AND GuVehicleOwner.VO_LEGAL_ENTITY_ID = VoLegalEntity.VO_LEGAL_ENTITY_ID(+)
AND GuVehicleOwner.VO_PROFESSIONAL_GROUP_ID = VoProfessionalGroup.VO_PROFESSIONAL_GROUP_ID(+)
AND GuVehicleOwner.accounting_hiring_p_oc_poi_id = OcPoi.POI_ID(+)
AND GuVehicleOwner.HIRING_P_OC_POI_ID = OcPoi1.POI_ID(+)