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.isc_status_code_type as status_type,
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",
ia.county_code, ia.loc_agency_code,
m.lname, m.fname, mp.sex_code "SEX_CODE",
mp.race_code "RACE_CODE",
mp.INDX_SEC_LEVEL_CODE,
prop.property_type_code, PROP.CURRENCY_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",
iv.role_code,
iv.status_code,
(SELECT ptc.property_type_desc
FROM property_type_codes ptc
WHERE ptc.property_type =
prop.property_type_code)
AS property_type_desc,
prop.property_id, prop.document, m.name_type_code,
isupp.approving_agency_code,
isupp.approval_date, iprop.status_code, iprop.prop_loss_code,
CASE
WHEN IP.EXPUNGE='Y' OR MP.EXPUNGE='Y' OR I.EXPUNGE='Y' THEN 'Y'
ELSE 'N'
END,
i.inc_disp_code,
i.inc_disp_code_type,
mo.mo_id,
mo.point_of_entry_code point_of_entry_code,
mo.method_of_entry_code method_of_entry_code,
mo.means_code means_code,
mo.trademark_code trademark_code,
mo.mo_comment mo_comment,
mo.supp_seq_offense supp_seq_offense,
mo.point_of_exit_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,
modus_operandi mo
WHERE oi.inc_incident_id = i.incident_id
AND isupp.inc_incident_id = oi.inc_incident_id
AND isupp.supp_seq = oi.supp_seq
AND oi.off1_officer_id = ofcr.officer_id
AND isupp.inc_incident_id = ip.inc_incident_id(+)
AND isupp.supp_seq = ip.supp_seq(+)
AND isupp.inc_incident_id = iv.incident_id(+)
AND isupp.supp_seq = iv.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 i.incident_id = mo.incident_id (+)
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 iv.vehicle_id = v.vehicle_id(+)
AND v.vehicle_id = vd.vehicle_id(+)
AND i.incident_id = ia.incident_id(+)
AND ia.address_id = a.address_id
AND iprop.property_id = prop.property_id(+)
