SELECT IC.INC_CASE_ID, IC.INC_CASE_NUMBER, CS.CODE AS STATUS_CODE, CS.DESCRIPTION AS STATUS_DESC, RC.CODE AS REVIEW_STATUS_CODE, RC.DESCRIPTION AS REVIEW_STATUS_DESC, AC.AGENCY_CODE, AC.AGENCY_DESC, IC.NEXT_UPDATE_DATE, IC.CREATOR_DATE, IC.RESTRICT_SG_EXCLSV_FLAG, O.BIAS_CODE, O.OFFNSE_CD_OFFENSE_STATUS_CODE, O.OFFNS_CD_OFFENSE_CODE, O.PLACE_PLACE_CODE, O.AC_CODE, O.REMARKS FROM INCIDENT_CASES IC LEFT OUTER JOIN EJS_CODES CS ON IC.CASE_STATUS_CODE = CS.CODE AND IC.CASE_STATUS_CODE_TYPE = CS.CODE_TYPE LEFT OUTER JOIN EJS_CODES RC ON IC.RSC_STATUS_CODE = RC.CODE AND IC.RSC_STATUS_CODE_TYPE = RC.CODE_TYPE INNER JOIN AGENCY_CODES AC ON IC.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN INC_CASE_INCIDENTS ICI ON IC.INC_CASE_ID = ICI.INC_CASE_ID LEFT OUTER JOIN INCIDENT_SUPPLEMENTS ISUP ON ICI.INCIDENT_ID = ISUP.INC_INCIDENT_ID AND ICI.SUPP_SEQ = ISUP.SUPP_SEQ LEFT OUTER JOIN INCIDENTS I ON ISUP.INC_INCIDENT_ID = I.INCIDENT_ID INNER JOIN OFFENSES O ON O.INC_INCIDENT_ID = I.INCIDENT_ID