SELECT INCD.INCIDENT_ID, INCD.SUPP_SEQ, DE.DISPATCH_NUMBER, INCD.INC_REPORT_NUMBER, (CASE WHEN IUP.LNAME IS NULL THEN '' ELSE INITCAP(IUP.LNAME) ||', ' END ||''|| CASE WHEN IUP.FNAME IS NULL THEN '' ELSE INITCAP(IUP.FNAME) || ' ' END ||''|| CASE WHEN IUP.MNAME IS NULL THEN '' ELSE INITCAP(IUP.MNAME) END ) AS DELETED_BY, INCD.AGENCY_CODE, INCD.REPORT_DATE, (CASE WHEN O.LNAME IS NULL THEN '' ELSE INITCAP(O.LNAME) ||', ' END ||''|| CASE WHEN O.FNAME IS NULL THEN '' ELSE INITCAP(O.FNAME) || ' ' END ||''|| CASE WHEN O.MNAME IS NULL THEN '' ELSE INITCAP(O.MNAME) END ) AS OFFICER_NAME, (SELECT AC.AGENCY_DESC FROM AGENCY_CODES AC WHERE AC.AGENCY_CODE = INCD.AGENCY_CODE) AS AGENCY_DESC, O.LNAME, O.DISPTCH_DISPATCH_ID, INCD.UPDATOR_DATE AS DELETED_DATE_SORT, TO_CHAR(INCD.UPDATOR_DATE,'MM/DD/YYYY') AS DELETED_DATE, INCD.ID_COMMENT AS COMMENTS FROM INCIDENT_DELETE INCD INNER JOIN IJIS_USER_PROFILES IUP ON INCD.UPDATOR_ID = IUP.LOGIN_ID LEFT OUTER JOIN OFFICERS O ON INCD.OFFICER_ID = O.OFFICER_ID LEFT OUTER JOIN DISPATCH_EVENTS DE ON INCD.DISPATCH_ID = DE.DISPATCH_ID WHERE INCD.NEW_STATUS_CODE IS NULL AND INCD.OLD_STATUS_CODE IS NULL