SELECT A.ASSIGN_ID, A.ASSIGN_NUMBER, A.ASSIGN_DATE, A.ASSIGN_COMMENT, A.POSTED, A.AGENCY_CODE, ACO.AGENCY_DESC, A.ASSIGN_CODE, AC.DESCRIPTION, A.SHIFT_CODE, SHFT.DESCRIPTION, A.ASSIGN_STATUS, EC.DESCRIPTION, A.CREATOR_ID, A.UPDATOR_ID, ASB.SUB_BEAT, AH.ACTIVITY_HEADER_ID, AH.ATC_CODE, ATCC.DESCRIPTION, AH.DISPATCH_ID, AH.DISPATCH_DATE_TIME, AH.START_DATE_TIME, AH.END_DATE_TIME, AH.ACTIVITY_COMMENT, AH.INCIDENT_ID, AH.SUPP_SEQ, CASE WHEN I.INC_REPORT_NUMBER IS NOT NULL THEN 'Y' ELSE 'N' END AS LOCKED_INCIDENT, AH.INC_REPORT_NUMBER AS FT_INC_REPORT_NUMBER, I.INC_REPORT_NUMBER, CI.TICKET_NUMBER, AH.CITATION_ID, CASE WHEN CI.TICKET_NUMBER IS NOT NULL THEN 'Y' ELSE 'N' END AS LOCKED_CITATION, AH.TICKET_NUMBER AS FT_TICKET_NUMBER, AH.SUB_BEAT, AH.CREATOR_ID, AH.CREATOR_DATE, AH.UPDATOR_ID, AH.UPDATOR_DATE, ACT.ACTIVITY_ID, ACT.ACTIVITY_COUNT, ACT.ACTIVITY_CODE, ACTC.DESCRIPTION, ACTC.CATEGORY_CODE, ACC.DESCRIPTION, (SELECT EJS_COMMENT FROM EJS_COMMENTS WHERE REC_ID = ACT.REC_ID) FROM ASSIGNMENTS A INNER JOIN AGENCY_CODES ACO ON A.AGENCY_CODE = ACO.AGENCY_CODE LEFT OUTER JOIN ASSIGNMENT_SUB_BEATS ASB ON A.ASSIGN_ID = ASB.ASSIGN_ID INNER JOIN ACTIVITY_HEADERS AH ON A.ASSIGN_ID = AH.ASSIGN_ID INNER JOIN ACTIVITIES ACT ON AH.ACTIVITY_HEADER_ID = ACT.ACTIVITY_HEADER_ID LEFT OUTER JOIN ACTIVITY_CODES ACTC ON ACT.ACTIVITY_CODE = ACTC.ACTIVITY_CODE LEFT OUTER JOIN ACTIVITY_CATEGORY_CODES ACC ON ACTC.CATEGORY_CODE = ACC.CATEGORY_CODE INNER JOIN ASSIGNMENT_CODES AC ON A.ASSIGN_CODE = AC.ASSIGNMENT_CODE INNER JOIN EJS_CODES EC ON A.ASSIGN_STATUS = EC.CODE AND A.ASSIGN_STATUS_TYPE = EC.CODE_TYPE INNER JOIN ASSIGNMENT_SHIFT_CODES SHFT ON A.SHIFT_CODE = SHFT.SHIFT_CODE LEFT OUTER JOIN ACTIVITY_TIME_CATEGORY_CODES ATCC ON AH.ATC_CODE = ATCC.ATC_CODE LEFT OUTER JOIN INCIDENT_SUPPLEMENTS ISUP ON AH.INCIDENT_ID = ISUP.INC_INCIDENT_ID AND AH.SUPP_SEQ = ISUP.SUPP_SEQ LEFT OUTER JOIN INCIDENTS I ON ISUP.INC_INCIDENT_ID = I.INCIDENT_ID LEFT OUTER JOIN CITATIONS CI ON AH.CITATION_ID = CI.CITATION_ID