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, i.summary, isupp.isc_status_code "STATUS", isupp.responsible_user_id, isupp.supp_seq, isupp.agency_only, isupp.cid, isupp.security_level, a.street_name, a.city "ADRS_CITY", a.state_cd_state_code "STATE", mp.sex_code "SEX_CODE", mp.race_code "RACE_CODE", ipr.role_type, prop.property_type_code, iprop.status_code, ofns.bias_code "OFFENSE_BIAS_CODE", ofns.offns_cd_offense_code "OFFENSE_CODE", ofns.place_place_code "OFFENSE_PLACE_CODE", ofns.offnse_cd_offense_status_code "OFFENSE_STATUS_CODE", vd.bottom_color "VEH_BOTTOM_COLOR_CODE", vd.top_color "VEH_TOP_COLOR_CODE", v.vma_vehicle_make_code "VEH_MAKE_CODE", v.vst_vehicle_style_code "VEH_STYLE_CODE", mo.means_code, mo.method_of_entry_code, mo.point_of_entry_code, mo.trademark_code, mo.mo_comment, ejsn.narrative, ia.beat, a.geo_city, ia.sub_beat, b.business_name, b.btc_type_code, mo.point_of_exit_code FROM incidents i, incident_supplements isupp, inc_supp_narratives isn, officer_incidents oi, addresses a, offenses ofns, master_names m, incident_people ip, incident_person_roles ipr, people p, master_people mp, incident_properties iprop, properties prop, vehicles v, incident_vehicles iv, vehicle_descriptions vd, incident_addresses ia, modus_operandi mo, incident_businesses ib, businesses b, ejs_notes ejsn WHERE isupp.inc_incident_id = i.incident_id AND mo.incident_id = isupp.inc_incident_id AND mo.supp_seq = isupp.supp_seq AND isn.incident_id = isupp.inc_incident_id AND isn.supp_seq = isupp.supp_seq AND ejsn.note_id = isn.note_id AND ofns.inc_incident_id = mo.incident_id_offense AND ofns.supp_seq = mo.supp_seq_offense AND ofns.offense_number = mo.offense_number AND i.incident_id = ia.incident_id(+) AND ia.address_id = a.address_id AND isupp.inc_incident_id = ip.inc_incident_id(+) AND isupp.supp_seq = ip.supp_seq(+) AND isupp.inc_incident_id = oi.inc_incident_id(+) AND isupp.supp_seq = oi.supp_seq(+) AND isupp.inc_incident_id = iprop.incsup_incident_id(+) AND isupp.supp_seq = iprop.incsup_supp_seq(+) AND iprop.property_id = prop.property_id(+) AND isupp.inc_incident_id = iv.incident_id(+) AND isupp.supp_seq = iv.supp_seq(+) AND ip.per_person_id = p.person_id(+) AND ip.inc_per_id = ipr.inc_per_id(+) AND p.person_id = m.per_person_id(+) AND p.master_person_id = mp.master_person_id(+) AND iv.vehicle_id = v.vehicle_id(+) AND v.vehicle_id = vd.vehicle_id(+) AND i.incident_id = ib.inc_incident_id(+) AND ib.busns_business_number = b.business_number(+)