SELECT DISTINCT i.inc_report_number, i.report_date, i.summary, o.offns_cd_offense_code || ' - ' || oc.offense_desc FROM incidents i, incident_supplements isupp, offenses o, offense_codes oc WHERE i.incident_id = isupp.inc_incident_id AND isupp.inc_incident_id = o.inc_incident_id (+) AND isupp.supp_seq = o.supp_seq (+) AND o.offns_cd_offense_code = oc.offense_code(+) AND isupp.isc_status_code = 'A' AND i.summary IS NOT NULL AND i.report_date >= SYSDATE -1