1. SELECT GuVehicleOwner.GU_VEHICLE_OWNER_ID,
  2.        GuVehicleOwner.GUI_USER_ID,
  3.        GuVehicleOwner.ORDER_NUM,
  4.        GuVehicleOwner.RIGHT_GRANTED,
  5.        GuVehicleOwner.VEHICLE_OWNER_ID,
  6.        GuVehicleOwner.VO_GROUP_ID,
  7.        GuVehicleOwner.VO_PERSON_CATEGORY_ID,
  8.        GuVehicleOwner.VO_VEHICLE_CATEGORY_ID,
  9.        VoGroup.NAME,
  10.        VoGroup.VO_GROUP_ID AS VO_GROUP_ID1,
  11.        VoPersonCategory.NAME AS NAME1,
  12.        VoPersonCategory.VO_PERSON_CATEGORY_ID AS VO_PERSON_CATEGORY_ID1,
  13.        VoVehicleCategory.NAME AS NAME2,
  14.        VoVehicleCategory.VO_VEHICLE_CATEGORY_ID AS VO_VEHICLE_CATEGORY_ID1,
  15.        (VoGroup.NAME) AS VIEW_ATTR,
  16.        (VoPersonCategory.NAME) AS VIEW_ATTR,
  17.        (VoVehicleCategory.NAME) AS VIEW_ATTR,
  18.        (OcPoiCategory.NAME) AS VIEW_ATTR,
  19.        OcPoiCategory.OC_POI_CATEGORY_ID,
  20.        GuVehicleOwner.OC_POI_CATEGORY_ID AS OC_POI_CATEGORY_ID1,
  21.        GuVehicleOwner.GU_PERSON_GENERATION_TYPE_ID,
  22.        NVL2 (OBS.short_name,  OBS.short_name || ' ' || OBS.name,  OBS.name) AS OBS,
  23.        NVL2 (VoProfessionalGroup.short_code, VoProfessionalGroup.name, VoProfessionalGroup.short_code ||  ' ' || VoProfessionalGroup.name) AS VIEW_ATTR,
  24.        NVL2 (VoLegalEntity.Short_code, VoLegalEntity.Short_code || ' ' || VoLegalEntity.name, VoLegalEntity.name) AS VIEW_ATTR,
  25.        GuVehicleOwner.VO_LEGAL_ENTITY_ID,
  26.        GuVehicleOwner.OBS_ID,
  27.        GuVehicleOwner.VO_PROFESSIONAL_GROUP_ID,
  28.        GuVehicleOwner.HIRING_P_OC_POI_ID,
  29.        GuVehicleOwner.ACCOUNTING_HIRING_P_OC_POI_ID,
  30.        (OcPoi.name) AS VIEW_ATTR,
  31.        (OcPoi1.name) AS VIEW_ATTR,
  32.        OcPoi1.POI_ID,
  33.        OcPoi.POI_ID AS POI_ID1,
  34.        GuVehicleOwner.VO_ROLE_ID
  35. 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
  36. WHERE GuVehicleOwner.VO_PERSON_CATEGORY_ID = VoPersonCategory.VO_PERSON_CATEGORY_ID(+)
  37. AND GuVehicleOwner.VO_VEHICLE_CATEGORY_ID = VoVehicleCategory.VO_VEHICLE_CATEGORY_ID(+)
  38. AND GuVehicleOwner.VO_GROUP_ID = VoGroup.VO_GROUP_ID(+)
  39. AND GuVehicleOwner.OC_POI_CATEGORY_ID = OcPoiCategory.OC_POI_CATEGORY_ID(+)
  40. AND GuVehicleOwner.obs_id = Obs.obs_id (+)
  41. AND GuVehicleOwner.VO_LEGAL_ENTITY_ID = VoLegalEntity.VO_LEGAL_ENTITY_ID(+)
  42. AND GuVehicleOwner.VO_PROFESSIONAL_GROUP_ID = VoProfessionalGroup.VO_PROFESSIONAL_GROUP_ID(+)
  43. AND GuVehicleOwner.accounting_hiring_p_oc_poi_id = OcPoi.POI_ID(+)
  44. AND GuVehicleOwner.HIRING_P_OC_POI_ID = OcPoi1.POI_ID(+)