SELECT DISTINCT USER || IC.INC_CASE_ID AS ID, UPPER (USER) AS county, IC.INC_CASE_ID AS INC_CASE_ID, IC.INC_CASE_NUMBER AS INC_CASE_NUMBER, AC.AGENCY_CODE AS AGENCY_CODE, AC.AGENCY_DESC AS AGENCY_DESC, IC.SECURITY_LEVEL AS SECURITY_LEVEL, EJS_GET_EJS_CODE_DESCR(IC.CASE_STATUS_CODE_TYPE , IC.CASE_STATUS_CODE) AS Case_Status_Desc, EJS_GET_EJS_CODE_DESCR(IC.RSC_STATUS_CODE_TYPE , IC.RSC_STATUS_CODE) AS Review_Status, TO_CHAR(NEXT_UPDATE_DATE,'MM/DD/YYYY') AS Next_Review_Date, EJS_GET_IC_ASSIGN_DATES(IC.INC_CASE_ID) AS DATE_ASSIGNED, TO_CHAR(IC.CREATOR_DATE,'MM/DD/YYYY') AS EJS_CREATION_DATE, EJS_GET_IC_LEA_INVESTIGATOR(IC.INC_CASE_ID) AS LEA_INVESTGATOR, EJS_GET_IC_INC_REPORT_NUMBERS(IC.INC_CASE_ID) AS Incident_Report, EJS_GET_IC_INCIDENT_SUMMARY(IC.INC_CASE_ID) AS Incident_Summary, EJS_GET_IC_PER_SUM_NO_RACE_SEX(IC.INC_CASE_ID) AS PERSON_SUMMARY1 FROM INCIDENT_CASES IC INNER JOIN AGENCY_CODES AC ON IC.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN INCIDENT_CASE_OFFICERS ICO ON IC.INC_CASE_ID = ICO.INC_CASE_ID AND ICO.OFFICER_STATUS = 'Y' LEFT OUTER JOIN INC_CASE_ACTIVITIES ICA ON IC.INC_CASE_ID = ICA.INC_CASE_ID