select distinct 'PR' HEADER, null ACTION, null LABEL, prop.updator_date UPDATE_DATE, to_char(prop.updator_date, 'HH24MI') UPDATE_TIME, ac.ori_number AGENCY, inc.inc_report_number INCIDENT_NUMBER, prop.property_id PROPERTY_UNIQUE_ID, incprop.status_code PROPERTY_LOSS_TYPE, prop.property_type_code PROPERTY_DESCRIPTION_TYPE, prop.description PROPERTY_DESCRIPTION, prop.quantity NUMBER_OF_ITEMS, prop.value VALUE_OF_PROPERTY, prop.make PROPERTY_BRAND, prop.model PROPERTY_MODEL, prop.serial_number SERIAL_NUMBER, null OWNER_APPLIED_NUMBER, incprop.date_recovered RECOVERY_DATE, null RECOVERY_LOCATION, --Not in EJS. evid.evidence_id EVIDENCE_NUMBER, inc.incident_id INCIDENT_SYSTEM_NUMBER from properties prop, incident_properties incprop, incident_supplements incsupp, incidents inc, agency_codes ac, evidence evid where incprop.property_id = prop.property_id and incsupp.inc_incident_id = incprop.incsup_incident_id and incsupp.supp_seq = incprop.incsup_supp_seq and inc.incident_id = incsupp.inc_incident_id and ac.agency_code = inc.agncy_cd_agency_code and evid.pro_property_id (+) = prop.property_id and incsupp.isc_status_code = 'A' and prop.document <> 'D'