View Definition:
SELECT DISTINCT p.property_id,
p.property_type_code,
p.evidence,
p.document,
p.type_of_quantity,
p.primary_color,
p.secondary_color,
p.drug_type,
P.drug_type_type,
p.quantity,
p.description,
p.make,
p.model,
p.serial_number,
p.VALUE,
p.misc,
p.document_number,
p.bank,
p.document_date,
p.account_name,
p.account_number,
p.payable_to,
p.amount,
p.endorsee,
p.barrel_length,
p.calgag_code,
p.gun_act_code,
p.gun_typ_code,
i.incident_id,
i.inc_report_number,
i.report_date,
i.start_date,
i.end_date,
i.summary,
isupp.supp_agency_code "AGNCY_CD_AGENCY_CODE",
(SELECT INITCAP (ec.description)
FROM ejs_codes ec
WHERE UPPER (ec.code) =
UPPER (isupp.isc_status_code)
AND ec.code_type = 'INCIDENT_STATUS_CODES')
AS "STATUS_DESC",
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,
ip.status_code,
ip.prop_loss_code,
ip.inc_prop_id,
p.currency_code,
p.currency_code_type,
p.indx_sec_level_code,
pc.denomination_code,
pc.denomination_code_type,
pc.quantity AS pro_cash_quantity,
pc.sub_total,
(SELECT ptc.property_type_desc
FROM property_type_codes ptc
WHERE ptc.property_type =
p.property_type_code)
AS property_type_desc,
P.CREATOR_ID AS CREATOR_ID,
P.CREATOR_DATE AS CREATOR_DATE,
P.UPDATOR_ID AS UPDATOR_ID,
P.UPDATOR_DATE AS UPDATOR_DATE,
p.rec_id as rec_id,
ip.creator_id as incident_creator_id,
ip.updator_id as incident_updator_id,
isupp.approving_agency_code,
isupp.approval_date,
ip.property_hold_id,
ip.evidence_id,
i.inc_disp_code,
i.inc_disp_code_type
FROM properties p,
incident_properties ip,
incident_supplements isupp,
incidents i,
property_cash pc
WHERE p.property_id = ip.property_id
AND ip.incsup_incident_id = isupp.inc_incident_id
AND ip.incsup_supp_seq = isupp.supp_seq
AND i.incident_id = isupp.inc_incident_id
AND p.property_id = pc.property_id(+)
