View Definition:
SELECT DISTINCT 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, 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,
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
WHERE i.incident_id = isupp.inc_incident_id
AND isupp.inc_incident_id = mo.incident_id
AND isupp.supp_seq = mo.supp_seq
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.master_person_id = mp.master_person_id(+)
AND p.person_id = m.per_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(+)
