psi_mmobile

Untitled

Oct 17th, 2025
2,217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 1.50 KB | None | 0 0
  1. SELECT FixedUnit.FIXED_UNIT_ID,
  2.        FixedUnit.VO_FIXED_UNIT_CATEGORY_ID,
  3.        FixedUnit.NAME,
  4.        FixedUnit.MODEL,
  5.        FixedUnit.VERSION,
  6.        FixedUnit.REMOTE_UNIT_ID,
  7.        FixedUnit.AUTO_DEFINE_POI,
  8.        FixedUnit.AUTO_DEFINE_POI_CAT_ID,
  9.        FixedUnit.AUTO_DEFINE_FIXED_UNIT_POI,
  10.        FixedUnit.LAST_RU_DATA_ID,
  11.        FixedUnit.LAST_BUT_ONE_RU_DATA_ID,
  12.        FixedUnit.CREATION_DATE,
  13.        FixedUnit.LM_DATE,
  14.        FixedUnit.LM_COMMENT,
  15.        VehicleOwner.COMPANY_NAME,
  16.        VehicleOwner.VEHICLE_OWNER_ID,
  17.        VehicleData.DATE_DAY,
  18.        VehicleData.VEHICLE_DATA_ID,
  19.        FixedUnit.STREET,
  20.        FixedUnit.STREET_NR,
  21.        FixedUnit.LOCATION,
  22.        FixedUnit.POST_CODE,
  23.        FixedUnit.COUNTRY,
  24.        FixedUnit.WGS84_LATITUDE,
  25.        FixedUnit.WGS84_LONGITUDE,
  26.        VoFixedUnitCategory.GRAPHICAL_SYMBOL,
  27.        VoFixedUnitCategory.VO_FIXED_UNIT_CATEGORY_ID AS VO_FIXED_UNIT_CATEGORY_ID1,
  28.        VehicleData.WGS84_LATITUDE AS WGS84LATITUDE1,
  29.        VehicleData.WGS84_LONGITUDE AS WGS84LONGITUDE1,
  30.        FixedUnit.FIXED_UNIT_USAGE_ID,
  31.        FixedUnit.FIXED_UNIT_STATUS_ID
  32. FROM FIXED_UNIT FixedUnit, VO_FIXED_UNIT_CATEGORY VoFixedUnitCategory, VEHICLE_DATA VehicleData, V_UPDATABLE_VEHICLE_OWNER VehicleOwner
  33. WHERE FixedUnit.VO_FIXED_UNIT_CATEGORY_ID = VoFixedUnitCategory.VO_FIXED_UNIT_CATEGORY_ID
  34. AND VoFixedUnitCategory.VEHICLE_OWNER_ID = VehicleOwner.VEHICLE_OWNER_ID
  35. AND VehicleData.VEHICLE_DATA_ID(+) = FixedUnit.LAST_RU_DATA_ID
Advertisement
Add Comment
Please, Sign In to add comment