SELECT OcDayAggreg.PARENT_OC_DAY_AGGREG_ID,
       OcDayAggreg.OC_DAY_AGGREG_ID,
       OcDayAggreg.OPERATION_CENTER_ID,
       OcDayAggreg.VEHICLE_OWNER_ID,
       OcDayAggreg.VO_PERSON_CATEGORY_ID,
       OcDayAggreg.VO_VEHICLE_CATEGORY_ID,
       OcDayAggreg.OC_POI_CATEGORY_ID,
       OcDayAggreg.DEFAULT_WORK_CODE_ID,
       OcDayAggreg.DEFAULT_ADMIN_STATUS_ID,
       OcDayAggreg.OC_CALENDAR_ID,
       OcDayAggreg.IS_ACTIVE,
       OcDayAggreg.START_DATE,
       OcDayAggreg.LIMIT_TO_VD_POI_DAY,
       OcDayAggreg.WORK_AREA_POI_ID,
       OcDayAggreg.STOP_AREA_POI_ID,
       OcDayAggreg.WORK_PERIOD_POI_ID,
       OcDayAggreg.PRIVATE_STOP_AREA_POI_ID,
       OcDayAggreg.WORK_PERIOD_OUT_BH_POI_ID,
       OcDayAggreg.SHORT_WORK_PERIOD_POI_ID,
P_GUI_USER.getCalendarName(OcDayAggreg.OC_CALENDAR_ID) OC_CALENDAR_NAME,
P_GUI_USER.getOperationCenterName(OcDayAggreg.OPERATION_CENTER_ID) OPERATION_CENTER_NAME,
P_POI.getPoiName(OcDayAggreg.PRIVATE_STOP_AREA_POI_ID) PRIVATE_STOP_AREA_POI_NAME,
P_POI.getPoiName(OcDayAggreg.SHORT_WORK_PERIOD_POI_ID) SHORT_WORK_PERIOD_POI_NAME,
P_POI.getPoiName(OcDayAggreg.STOP_AREA_POI_ID) STOP_AREA_POI_NAME,
P_GUI_USER.getVehicleOwnerName(OcDayAggreg.VEHICLE_OWNER_ID) VEHICLE_OWNER_NAME, --OK
P_POI.getPoiName(OcDayAggreg.WORK_AREA_POI_ID) WORK_AREA_POI_NAME,
P_GUI_USER.getWorkCodeName(OcDayAggreg.DEFAULT_WORK_CODE_ID) WORK_CODE_NAME,
P_POI.getPoiName(OcDayAggreg.WORK_PERIOD_OUT_BH_POI_ID) WORK_PERIOD_OUT_BH_POI_NAME,
P_POI.getPoiName(OcDayAggreg.WORK_PERIOD_POI_ID) WORK_PERIOD_POI_NAME,
P_GUI_USER.getPersonCategoryName(OcDayAggreg.VO_PERSON_CATEGORY_ID) VO_PERSON_CATEGORY_NAME, --OK
P_GUI_USER.getVehicleCategoryName(OcDayAggreg.VO_VEHICLE_CATEGORY_ID) VO_VEHICLE_CATEGORY_NAME,
P_GUI_USER.getPoiCategoryName(OcDayAggreg.OC_POI_CATEGORY_ID) OC_POI_CATEGORY_NAME, --OK
P_GUI_USER.getOcAggregAdminStatusName(OcDayAggreg.DEFAULT_ADMIN_STATUS_ID) DEFAULT_ADMIN_STATUS_NAME --OK
FROM OC_DAY_AGGREG OcDayAggreg
WHERE OcDayAggreg.vehicle_owner_id = 100718
START WITH OcDayAggreg.parent_oc_day_aggreg_id IS NULL
CONNECT BY OcDayAggreg.parent_oc_day_aggreg_id = PRIOR OcDayAggreg.oc_day_aggreg_id
ORDER siblings BY OcDayAggreg.start_date;