SELECT P.PERMIT_ID , P.PERMIT_NO , P.PERMIT_TYPE_CODE , (SELECT TYP.DESCRIPTION FROM EJS_CODES TYP WHERE TYP.CODE = P.PERMIT_TYPE_CODE AND TYP.CODE_TYPE = P.PERMIT_TYPE_CODE_TYPE) , P.PERMIT_STATUS_CODE , (SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE = P.PERMIT_STATUS_CODE AND ST.CODE_TYPE = P.PERMIT_STATUS_CODE_TYPE) , P.PERMIT_REASON_CODE , (SELECT RSN.DESCRIPTION FROM EJS_CODES RSN WHERE RSN.CODE = P.PERMIT_REASON_CODE AND RSN.CODE_TYPE = P.PERMIT_REASON_CODE_TYPE) , P.APP_DATE , P.ISSUED_BY , P.ISSUE_DATE , P.PROCESS_DATE , P.PROCESSED_BY , P.EXPIRE_DATE , P.REVIEW_DATE , P.REVIEWED_BY , P.COMMENTS , P.CREATOR_ID , P.CREATOR_DATE , P.UPDATOR_ID , P.UPDATOR_DATE --, PERMIT_REASON_CODE_TYPE --, PERMIT_STATUS_CODE_TYPE --, PERMIT_TYPE_CODE_TYPE , P.REC_ID , P.AGENCY_CODE , (SELECT AG.AGENCY_DESC FROM AGENCY_CODES AG WHERE AG.AGENCY_CODE = P.AGENCY_CODE) --, P.PURCHASE_TYPE_CODE_TYPE , P.PURCHASE_TYPE_CODE , (SELECT PUR.DESCRIPTION FROM EJS_CODES PUR WHERE PUR.CODE = P.PURCHASE_TYPE_CODE AND PUR.CODE_TYPE = P.PURCHASE_TYPE_CODE_TYPE) , P.NEXT_INSPECTION_DATE , P.INSPECTED_DATE , P.INSPECTED_BY , P.NEXT_REVIEW_DATE , pv.vehicle_id , pv.date_of_info , vd.lic_number , vd.lic_month , vd.lic_year , vd.lic_type_code , (SELECT LT.DESCRIPTION FROM EJS_CODES LT WHERE LT.CODE = VD.LIC_TYPE_CODE AND LT.CODE_TYPE = VD.LIC_TYPE_CODE_TYPE) , vd.lic_state_code , (SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE = VD.LIC_STATE_CODE AND ST.CODE_TYPE = VD.LIC_STATE_CODE_TYPE) , vd.cond_code , (SELECT CON.DESCRIPTION FROM EJS_CODES CON WHERE CON.CODE = VD.COND_CODE AND CON.CODE_TYPE = VD.COND_CODE_TYPE) , vd.misc_id , vd.VALUE , vd.bottom_color , (SELECT B.DESCRIPTION FROM EJS_CODES B WHERE B.CODE = VD.BOTTOM_COLOR AND B.CODE_TYPE = VD.BOTTOM_COLOR_TYPE) , vd.top_color , (SELECT T.DESCRIPTION FROM EJS_CODES T WHERE T.CODE = VD.TOP_COLOR AND T.CODE_TYPE = VD.TOP_COLOR_TYPE) , vd.damage , vd.odometer_reading , vd.damage_code , (SELECT DC.DESCRIPTION FROM EJS_CODES DC WHERE DC.CODE = VD.DAMAGE_CODE AND DC.CODE_TYPE = VD.DAMAGE_CODE_TYPE) , v.vin , v.YEAR , v.vma_vehicle_make_code , (SELECT VEHICLE_MAKE_DESC FROM VEHICLE_MAKES VMA WHERE VMA.VEHICLE_MAKE_CODE = V.VMA_VEHICLE_MAKE_CODE) , v.vmo_vehicle_model_code , (SELECT VEHICLE_MODEL_DESC FROM VEHICLE_MODELS VMO WHERE VMO.VEHICLE_MODEL_CODE = V.VMO_VEHICLE_MODEL_CODE AND VMO.VMA_VEHICLE_MAKE_CODE = V.VMA_VEHICLE_MAKE_CODE) , v.vst_vehicle_style_code , (SELECT VEHICLE_STYLE_DESC FROM VEHICLE_STYLES VSC WHERE VSC.VEHICLE_STYLE_CODE = V.VST_VEHICLE_STYLE_CODE AND VSC.VTC_TYPE_CODE = V.VTC_TYPE_CODE) , v.vtc_type_code , (SELECT TYPE_DESC FROM VEHICLE_TYPE_CODES VTC WHERE VTC.TYPE_CODE = V.VTC_TYPE_CODE) FROM PERMITS P INNER JOIN PERMIT_VEHICLES PV ON P.PERMIT_ID = PV.PERMIT_ID INNER JOIN VEHICLES V ON PV.VEHICLE_ID = V.VEHICLE_ID LEFT OUTER JOIN VEHICLE_DESCRIPTIONS VD ON V.VEHICLE_ID = VD.VEHICLE_ID