SELECT VOcDayAggregRun.FLAG_NAME,
  VOcDayAggregRun.COMPANY_NAME,
  VOcDayAggregRun.CAT_VEHICLE_NAME,
  VOcDayAggregRun.CAT_PERSON_NAME,
  VOcDayAggregRun.FROM_DATE,
  VOcDayAggregRun.TO_DATE,
  VOcDayAggregRun.START_TIME_STR,
  VOcDayAggregRun.STOP_TIME_STR,
  VOcDayAggregRun.START_TIME,
  VOcDayAggregRun.STOP_TIME,
  VOcDayAggregRun.DURATION,
  VOcDayAggregRun.NBR_ACTIVE_VEHICLE,
  VOcDayAggregRun.NBR_VD_DAY,
  VOcDayAggregRun.NBR_ACTIVE_PERSON,
  VOcDayAggregRun.NBR_PD_DAY,
  VOcDayAggregRun.ERROR_MESSAGE,
  VOcDayAggregRun.OPERATION_CENTER_ID,
  VOcDayAggregRun.VEHICLE_CATEGORY_NAME,
  VOcDayAggregRun.PERSON_CATEGORY_NAME,
  VOcDayAggregRun.VEHICLE_FILTER,
  VOcDayAggregRun.PERSON_FILTER,
  VOcDayAggregRun.OC_DAY_AGGREG_RUN_ID,
  VOcDayAggregRun.OC_DAY_AGGREG_RUN_STATUS_ID,
  VOcDayAggregRun.POI_CATEGORY_NAME,
  UPPER(VOcDayAggregRun.COMPANY_NAME
  || ' '
  || VOcDayAggregRun.CAT_VEHICLE_NAME
  || ' '
  || VOcDayAggregRun.CAT_PERSON_NAME
  || ' '
  || VOcDayAggregRun.ERROR_MESSAGE
  || ' '
  || VOcDayAggregRun.VEHICLE_CATEGORY_NAME
  || ' '
  || VOcDayAggregRun.PERSON_CATEGORY_NAME
  || ' '
  || VOcDayAggregRun.POI_CATEGORY_NAME) ID_STRING
FROM V_OC_DAY_AGGREG_RUN VOcDayAggregRun
WHERE VOcDayAggregRun.START_TIME >= ? --param fromDate
AND   VOcDayAggregRun.START_TIME <= ? --param toDate
AND (?                                 = 'true' --param isOfAdmin
OR VOcDayAggregRun.OPERATION_CENTER_ID = ?) --param operationCenterId
AND (?                                 = 'false' --param showExceptionsOnly
OR VOcDayAggregRun.FLAG_NAME          != 'green')