SELECT DISTINCT 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, AL.LOG_ID, AL.LOG_STATUS, AL.OFFICER_ID, AL.EJS_EMP_ID, AL.EMPLOYEE_ID, AL.STATUS_CODE, AL.START_DATE_TIME, AL.END_DATE_TIME, O.LNAME, O.FNAME, O.INTERNAL_ID, O.LNAME ||', '|| O.FNAME ||' ('||O.INTERNAL_ID ||')' , EMP.ENC_LNAME, EMP.ENC_FNAME, EMP.EMPLOYEE_ID, EMP.ENC_LNAME ||', '|| EMP.ENC_FNAME ||' ('||EMP.EMPLOYEE_ID ||')', CASE WHEN AL.OFFICER_ID IS NOT NULL THEN O.LNAME ||', '|| O.FNAME ||' ('||O.INTERNAL_ID ||')' ELSE EMP.ENC_LNAME ||', '|| EMP.ENC_FNAME ||' ('||EMP.EMPLOYEE_ID ||')' END AS ASSOCIATE_NM_ID, AV.VEHICLE_ID, AV.MILEAGE_IN, AV.MILEAGE_OUT, NVL(NVL(av.mileage_out,av.mileage_in) - NVL(av.mileage_in,av.mileage_out),0), AV.FUEL_USED, AV.OIL_USED, AV.FUEL_COST, AV.OIL_COST, AV.REPAIR_COST, NVL(AV.FUEL_COST,0) + NVL(AV.OIL_COST,0) + NVL(AV.REPAIR_COST,0) as TOTAL_COST, AV.COMMENTS, DV.UNIT_NUMBER, DV.VIN, DV.YEAR, DV.VEHICLE_MAKE_CODE, VMA.VEHICLE_MAKE_DESC, DV.VEHICLE_MODEL_CODE, VMO.VEHICLE_MODEL_DESC, DV.LICENSE_NUMBER, DV.DESCRIPTION, AE.EQUIPMENT_ID, AE.COMMENTS, AE.START_DATE_TIME, AE.END_DATE_TIME, DE.DESCRIPTION, DE.SERIAL_NUMBER, DE.MAKE, DE.MODEL, DE.EQUIPMENT_TYPE, SB.SUB_BEAT, AH.ACTIVITY_HEADER_ID, AH.ATC_CODE, ATCC.DESCRIPTION, AH.ACTIVITY_COMMENT, AH.DISPATCH_ID, AH.DISPATCH_DATE_TIME, AH.START_DATE_TIME, AH.END_DATE_TIME, 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 FROM ASSIGNMENTS A INNER JOIN AGENCY_CODES ACO ON A.AGENCY_CODE = ACO.AGENCY_CODE INNER JOIN ASSIGNMENT_SHIFT_CODES SHFT ON A.SHIFT_CODE = SHFT.SHIFT_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 LEFT OUTER JOIN ASSIGNMENT_LOGS AL ON A.ASSIGN_ID = AL.ASSIGN_ID LEFT OUTER JOIN OFFICERS O ON AL.OFFICER_ID = O.OFFICER_ID LEFT OUTER JOIN EMPLOYEES EMP ON AL.EJS_EMP_ID = EMP.EJS_EMP_ID LEFT OUTER JOIN ASSIGNMENT_VEHICLES AV ON A.ASSIGN_ID = AV.ASSIGN_ID LEFT OUTER JOIN DEPARTMENT_VEHICLES DV ON AV.VEHICLE_ID = DV.VEHICLE_ID LEFT OUTER JOIN VEHICLE_MAKES VMA ON DV.VEHICLE_MAKE_CODE = VMA.VEHICLE_MAKE_CODE LEFT OUTER JOIN VEHICLE_MODELS VMO ON DV.VEHICLE_MODEL_CODE = VMO.VEHICLE_MODEL_CODE AND DV.VEHICLE_MAKE_CODE = VMO.VMA_VEHICLE_MAKE_CODE LEFT OUTER JOIN ASSIGNMENT_EQUIPMENT AE ON A.ASSIGN_ID = AE.ASSIGN_ID LEFT OUTER JOIN DEPARTMENT_EQUIPMENT DE ON AE.EQUIPMENT_ID = DE.EQUIPMENT_ID LEFT OUTER JOIN ASSIGNMENT_SUB_BEATS SB ON A.ASSIGN_ID = SB.ASSIGN_ID LEFT OUTER JOIN ACTIVITY_HEADERS AH ON A.ASSIGN_ID = AH.ASSIGN_ID 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