SELECT CO.PERSON_ID , CO.COURSE_CD , CO.AS_OF_RANK_GPA , CO.COHORT_RANK , CO.COHORT_OVERRIDE_RANK , CO.COMMENTS , HP.PARTY_NUMBER , PS.TITLE , CO.CREATED_BY , CO.CREATION_DATE , CO.LAST_UPDATED_BY , CO.LAST_UPDATE_DATE FROM IGS_PR_COHINST_RANK CO , IGS_EN_STDNT_PS_ATT_ALL ST , HZ_PARTIES HP , IGS_PS_VER_ALL PS WHERE CO.PERSON_ID = HP.PARTY_ID AND CO.PERSON_ID = ST.PERSON_ID AND CO.COURSE_CD = ST.COURSE_CD AND PS.COURSE_CD = ST.COURSE_CD AND PS.VERSION_NUMBER = ST. VERSION_NUMBER WITH READ ONLY