SELECT IC.INC_INCIDENT_ID, I.agncy_cd_agency_code, ISUPP.SUPP_SEQ, I.INC_REPORT_NUMBER, I.REPORT_DATE, I.START_DATE AS OCCURRENCE_DATE, ISUPP.APPROVAL_DATE, I.SUMMARY, ISUPP.ISC_STATUS_CODE, ISUPP.ISC_STATUS_CODE_TYPE, CI.CITATION_ID, CI.TICKET_NUMBER, CI.CITATION_TYPE_CODE, CTC.DESCRIPTION AS CITATION_TYPE_DESC, CI.FILED_DATE, CI.CITATION_DATE, CI.AGENCY_CODE, CAC.AGENCY_DESC, CI.PLAINTIFF, CI.CITY_CODE, CI.STATE_DIST_CODE, I.INC_DISP_CODE, I.INC_DISP_CODE_TYPE FROM INCIDENT_CITATIONS IC INNER JOIN INCIDENTS I ON I.INCIDENT_ID = IC.INC_INCIDENT_ID INNER JOIN CITATIONS CI ON CI.CITATION_ID = IC.CITATION_ID INNER JOIN INCIDENT_SUPPLEMENTS ISUPP ON ISUPP.INC_INCIDENT_ID = IC.INC_INCIDENT_ID AND ISUPP.SUPP_SEQ = IC.SUPP_SEQ INNER JOIN CITATION_TYPE_CODES CTC ON CI.CITATION_TYPE_CODE = CTC.CITATION_TYPE_CODE INNER JOIN AGENCY_CODES CAC ON CI.AGENCY_CODE = CAC.AGENCY_CODE