View Definition:
SELECT DISTINCT
i.incident_id,
i.inc_report_number,
isupp.supp_agency_code
"SUPP_AGENCY_CODE",
i.report_date,
i.start_date,
i.end_date,
isupp.isc_status_code
"REPORT_STATUS",
isupp.supp_seq,
isupp.responsible_user_id
"REPORT_OWNER",
isupp.agency_only,
isupp.cid,
isupp.security_level,
i.summary
"REPORT_SUMMARY",
a.address_id,
ejs_addresses.address_summary (a.address_id)
address_summary,
a.street_number,
a.dirct_cd_direction_code
"STREET_DIRECTION_CODE",
a.street_name,
a.street_cd_street_type_code
"STREET_TYPE_CODE",
a.sub_number
"STREET_SUB_NUMBER",
a.city
"ADDR_CITY",
a.state_cd_state_code
"ADDR_STATE_CODE",
a.zip5,
a.zip4,
ia.beat
"REPORT_ADDR_BEAT",
ia.sub_beat
"REPORT_ADDR_SUB_BEAT",
m.lname,
m.fname,
m.mname,
TRIM (m.lname || ', ' || m.fname || ' ' || m.mname)
person_name_lfm,
IP.APPROX_AGE,
IPR.ROLE_TYPE,
mp.sex_code,
ec_sex.description
"SEX_DESC",
mp.race_code,
ec_race.description
"RACE_DESC",
ofcr.officer_id,
ofcr.lname
"OFFICER_LNAME",
ofcr.fname
"OFFICER_FNAME",
ofcr.agncy_cd_agency_code
"OFFICER_AGENCY_CODE",
ofcr.internal_id
"BADGE_NO",
ofcr.title
"OFFICER_TITLE",
io_vw.offense_number,
io_vw.offns_cd_offense_code
"OFFENSE_CODE",
io_vw.offense_desc
"OFFENSE_DESC",
io_vw.place_place_code
"OFFENSE_PLACE_CODE",
io_vw.place_code_desc
"OFFENSE_PLACE_DESC",
io_vw.offnse_cd_offense_status_code
"OFFENSE_STATUS_CODE",
io_vw.bias_bias_code
"OFFENSE_BIAS_CODE",
io_vw.bias_code_desc
"OFFENSE_BIAS_DESC",
io_vw.fec_forced_entry_code
"OFFENSE_FORCED_ENTRY_CODE",
io_vw.csau_csau_code
"OFFENSE_CSAU_CODE"
FROM incidents i,
incident_supplements isupp,
officer_incidents oi,
addresses a,
officers ofcr,
master_names m,
incident_people ip,
people p,
master_people mp,
incident_addresses ia,
ejs_codes ec_race,
ejs_codes ec_sex,
incident_person_roles ipr,
incident_offense_vw io_vw
WHERE isupp.inc_incident_id = i.incident_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 i.incident_id = ia.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 ia.address_id = a.address_id
AND oi.off1_officer_id = ofcr.officer_id(+)
AND mp.race_code = ec_race.code
AND mp.race_code_type = ec_race.code_type
AND mp.sex_code = ec_sex.code
AND mp.sex_code_type = ec_sex.code_type
AND isupp.inc_incident_id = io_vw.incident_id
AND isupp.supp_seq = io_vw.supp_seq
AND IP.INC_PER_ID = IPR.INC_PER_ID
