SELECT 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.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, i.summary, a.street_name, a.city "ADRS_CITY", a.state_cd_state_code "ADRS_STATE ", m.lname, m.fname, mp.sex_code "SEX_CODE", mp.race_code "RACE_CODE", prop.property_type_code, ofns.bias_code "OFFENSE_BIAS_CODE", ofns.offns_cd_offense_code "OFFENSE_CODE", ofns.place_place_code "OFFENSE_PLACE_CODE", ofcr.officer_id, ofcr.lname "OFFICER_LNAME", ofcr.fname "OFFICER_FNAME", ofcr.agncy_cd_agency_code "OFFICER_AGENCY_CODE", vd.bottom_color "VEH_COLOR_CODE", vd.top_color "VEH_TOP_COLOR_CODE", v.vma_vehicle_make_code "VEH_MAKE_CODE", v.vmo_vehicle_model_code "VEH_MODEL_CODE" FROM incidents i, incident_supplements isupp, officer_incidents oi, addresses a, offenses ofns, officers ofcr, master_names m, incident_people ip, people p, master_people mp, incident_properties iprop, properties prop, vehicles v, incident_vehicles iv, vehicle_descriptions vd, incident_addresses ia WHERE isupp.inc_incident_id = i.incident_id AND ip.inc_incident_id(+) = isupp.inc_incident_id AND ip.supp_seq(+) = isupp.supp_seq AND ip.per_person_id = p.person_id(+) AND p.master_person_id = mp.master_person_id(+) AND m.per_person_id(+) = p.person_id AND ia.incident_id = i.incident_id AND ia.address_id = a.address_id AND ofns.inc_incident_id(+) = isupp.inc_incident_id AND ofns.supp_seq(+) = isupp.supp_seq AND oi.inc_incident_id(+) = isupp.inc_incident_id AND oi.supp_seq(+) = isupp.supp_seq AND oi.off1_officer_id = ofcr.officer_id AND iprop.incsup_incident_id(+) = isupp.inc_incident_id AND iprop.incsup_supp_seq(+) = isupp.supp_seq AND iprop.property_id = prop.property_id(+) AND iv.incident_id(+) = isupp.inc_incident_id AND iv.supp_seq(+) = isupp.supp_seq AND v.vehicle_id(+) = iv.vehicle_id AND vd.vehicle_id(+) = v.vehicle_id