CREATE OR REPLACE FORCE EDITIONABLE VIEW "OF_OWNER"."V_MOBILITY_GROUPS_V2" ("PERSON_ID", "VEHICLE_OWNER_ID", "COMPANY_NR", "DATE_DAY", "TOTAL_EUROCENT", "TOT_PASSENGER_KM", "TOT_DRIVER_WITH_P_KM", "STR") AS
  SELECT "PERSON_ID",
    "VEHICLE_OWNER_ID",
    "COMPANY_NR",
    "DATE_DAY",
    "TOTAL_EUROCENT",
    "TOT_PASSENGER_KM",
    "TOT_DRIVER_WITH_P_KM",
    "STR"
  FROM v_mobility_groups_bam
  UNION
  SELECT "PERSON_ID",
    "VEHICLE_OWNER_ID",
    "COMPANY_NR",
    "DATE_DAY",
    "TOTAL_EUROCENT",
    "TOT_PASSENGER_KM",
    "TOT_DRIVER_WITH_P_KM",
    "STR"
  FROM v_mobility_groups_franki
  UNION
  SELECT "PERSON_ID",
    "VEHICLE_OWNER_ID",
    "COMPANY_NR",
    "DATE_DAY",
    "TOTAL_EUROCENT",
    "TOT_PASSENGER_KM",
    "TOT_DRIVER_WITH_P_KM",
    "STR"
  FROM v_prestation_groups_gerny
  WHERE vehicle_owner_id=100764
  UNION
  SELECT "PERSON_ID",
    "VEHICLE_OWNER_ID",
    "COMPANY_NR",
    "DATE_DAY",
    "TOTAL_EUROCENT",
    "TOT_PASSENGER_KM",
    "TOT_DRIVER_WITH_P_KM",
    "STR"
  FROM v_prestation_groups_putman;