SELECT CC.ID, CC.CRIMINAL_COMPLAINT_NUM, CC.COMPLAINT_DATETIME, CT.DESCRIPTION AS COMPLAINT_TYPE_DESC, STATUS.DESCRIPTION AS STATUS_DESC, SUBMIT.DESCRIPTION AS SUBMIT_STATUS_DESC, AC.AGENCY_DESC, MN.LNAME || ', ' || MN.FNAME AS PERSON_NAME, CC.OBTN_NUMBER FROM CRIMINAL_COMPLAINTS CC LEFT OUTER JOIN EJS_CODES CT ON CT.CODE_TYPE = CC.COMPLAINT_TYPE_CODE_TYPE AND CT.CODE = CC.COMPLAINT_TYPE_CODE LEFT OUTER JOIN EJS_CODES STATUS ON STATUS.CODE_TYPE = CC.STATUS_CODE_TYPE AND STATUS.CODE = CC.STATUS_CODE LEFT OUTER JOIN EJS_CODES SUBMIT ON SUBMIT.CODE_TYPE = CC.SUBMIT_STATUS_CODE_TYPE AND SUBMIT.CODE = CC.SUBMIT_STATUS_CODE LEFT OUTER JOIN AGENCY_CODES AC ON CC.COMPLAINTANT_AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN MASTER_NAMES MN ON CC.MN_MN_ID = MN.MN_ID