select distinct 'DR' 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 DRUG_UNIQUE_ID, prop.drug_type DRUG_TYPE, prop.description DRUG_DESCRIPTION, prop.type_of_quantity DRUG_MEASUREMENT_TYPE, prop.quantity DRUG_QUANTITY, prop.value DRUG_VALUE, 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 prop.document='D' and 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'