SELECT i.incident_id, isu.supp_seq, i.report_date, i.start_date, i.end_date, isu.isc_status_code, i.summary, de.dispatch_id, de.dispatch_date, de.dispatch_time, de.close_date, de.agency, de.call_type, DEC.inc_report_number, DEC.agency, DEC.assigned_to, deo.cad_persid, deo.dispatch_date, deo.officer_agency, deo.officer_fname, deo.officer_lname, deo.officer_title, deo.unit, deo.unit_agency, de.street_number, de.street_direction, de.street_dir_suffix, de.street_name, de.street_cd_street_type_code, de.sub_type, de.sub_number, de.city, de.state, de.zip4, de.zip5, de.beat, de.sub_beat, de.latitude, de.longitude, de.boundary_street, de.cross_street, de.cross_street_direction, de.cross_street_number, de.cross_street_dir_suffix, de.cross_street_type_code, DEC.assigned_incident, de.updator_date, de.common_place_name FROM incidents i, incident_supplements isu, dispatch_events de, dispatch_event_cases DEC, dispatch_event_officers deo WHERE de.dispatch_id = DEC.dispatch_id(+) AND de.dispatch_id = deo.dispatch_id(+) AND DEC.inc_report_number = i.inc_report_number AND DEC.agency = i.agncy_cd_agency_code AND i.incident_id = isu.inc_incident_id