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,
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 iv.incident_id = i.incident_id
AND isupp.inc_incident_id = iv.incident_id
AND isupp.supp_seq = iv.supp_seq
AND iv.vehicle_id = v.vehicle_id
AND v.vehicle_id = vd.vehicle_id
AND isupp.inc_incident_id = oi.inc_incident_id(+)
AND isupp.supp_seq = oi.supp_seq(+)
AND isupp.inc_incident_id = ip.inc_incident_id(+)
AND isupp.supp_seq = ip.supp_seq(+)
AND isupp.inc_incident_id = ofns.inc_incident_id(+)
AND isupp.supp_seq = ofns.supp_seq(+)
AND isupp.inc_incident_id = iprop.incsup_incident_id(+)
AND isupp.supp_seq = iprop.incsup_supp_seq(+)
AND ip.per_person_id = p.person_id(+)
AND p.person_id = m.per_person_id(+)
AND p.master_person_id = mp.master_person_id(+)
AND i.incident_id = ia.incident_id(+)
AND ia.address_id = a.address_id(+)
AND oi.off1_officer_id = ofcr.officer_id(+)
AND iprop.property_id = prop.property_id(+)
