Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT FixedUnit.FIXED_UNIT_ID,
- FixedUnit.VO_FIXED_UNIT_CATEGORY_ID,
- FixedUnit.NAME,
- FixedUnit.MODEL,
- FixedUnit.VERSION,
- FixedUnit.REMOTE_UNIT_ID,
- FixedUnit.AUTO_DEFINE_POI,
- FixedUnit.AUTO_DEFINE_POI_CAT_ID,
- FixedUnit.AUTO_DEFINE_FIXED_UNIT_POI,
- FixedUnit.LAST_RU_DATA_ID,
- FixedUnit.LAST_BUT_ONE_RU_DATA_ID,
- FixedUnit.CREATION_DATE,
- FixedUnit.LM_DATE,
- FixedUnit.LM_COMMENT,
- VehicleOwner.COMPANY_NAME,
- VehicleOwner.VEHICLE_OWNER_ID,
- VehicleData.DATE_DAY,
- VehicleData.VEHICLE_DATA_ID,
- FixedUnit.STREET,
- FixedUnit.STREET_NR,
- FixedUnit.LOCATION,
- FixedUnit.POST_CODE,
- FixedUnit.COUNTRY,
- FixedUnit.WGS84_LATITUDE,
- FixedUnit.WGS84_LONGITUDE,
- VoFixedUnitCategory.GRAPHICAL_SYMBOL,
- VoFixedUnitCategory.VO_FIXED_UNIT_CATEGORY_ID AS VO_FIXED_UNIT_CATEGORY_ID1,
- VehicleData.WGS84_LATITUDE AS WGS84LATITUDE1,
- VehicleData.WGS84_LONGITUDE AS WGS84LONGITUDE1,
- FixedUnit.FIXED_UNIT_USAGE_ID,
- FixedUnit.FIXED_UNIT_STATUS_ID
- FROM FIXED_UNIT FixedUnit, VO_FIXED_UNIT_CATEGORY VoFixedUnitCategory, VEHICLE_DATA VehicleData, V_UPDATABLE_VEHICLE_OWNER VehicleOwner
- WHERE FixedUnit.VO_FIXED_UNIT_CATEGORY_ID = VoFixedUnitCategory.VO_FIXED_UNIT_CATEGORY_ID
- AND VoFixedUnitCategory.VEHICLE_OWNER_ID = VehicleOwner.VEHICLE_OWNER_ID
- AND VehicleData.VEHICLE_DATA_ID(+) = FixedUnit.LAST_RU_DATA_ID
Advertisement
Add Comment
Please, Sign In to add comment