VIEW: APPS.IGSBV_PR_COHORT_INST_RANKS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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