SELECT DISTINCT iv.vehicle_id, i.incident_id, i.inc_report_number, isupp.supp_agency_code "AGNCY_CD_AGENCY_CODE", i.report_date, i.start_date, i.end_date, isupp.isc_status_code "STATUS", isupp.isc_status_code_type, isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, i.summary, v.vehicle_id AS veh_id, v.vma_vehicle_make_code, v.vmo_vehicle_model_code, v.vst_vehicle_style_code, v.YEAR, v.vin, v.vtc_type_code, vd.bottom_color, vd.top_color, vd.lic_type_code, vd.lic_state_code, vd.lic_year, vd.lic_number, vd.misc_id, iv.role_code, iv.status_code, vd.bottom_color_type, vd.top_color_type, isupp.isc_status_code_type, iv.updator_date, isupp.approving_agency_code, isupp.approval_date, i.inc_disp_code, i.inc_disp_code_type FROM vehicles v, incidents i, incident_supplements isupp, incident_vehicles iv, vehicle_descriptions vd WHERE iv.incident_id = i.incident_id AND iv.supp_seq = isupp.supp_seq AND isupp.inc_incident_id = i.incident_id AND v.vehicle_id = iv.vehicle_id AND vd.vehicle_id = v.vehicle_id AND iv.updator_date IN ( SELECT MAX (incv.updator_date) AS updator_date FROM incident_vehicles incv WHERE incv.incident_id = iv.incident_id GROUP BY incv.vehicle_id)