VIEW: APPS.IGS_PR_COHORT_INST_RANK_V

Source

View Text - Preformatted

SELECT cohir.rowid , cohi.cohort_name , cohi.load_cal_type , cohi.load_ci_sequence_number , cohir.person_id , hz.party_number , hz.party_name , cohir.course_cd , ps.title , cohir.as_of_rank_gpa, cohir.cohort_rank , cohir.cohort_override_rank, cohir.comments , cohir.created_by , cohir.creation_date , cohir.last_updated_by , cohir.last_update_date , cohir.last_update_login , cohir.request_id , cohir.program_application_id , cohir.program_id , cohir.program_update_date FROM IGS_PR_COHINST_RANK cohir, IGS_PR_cohort_inst cohi, hz_parties hz, igs_ps_ver ps, igs_en_stdnt_ps_att spa, igs_ps_ofr_opt poo WHERE cohir.person_id = hz.party_id AND cohir.course_cd = ps.course_cd AND ps.version_number = poo.version_number AND ps.course_cd = poo.course_cd AND spa.coo_id = poo.coo_id AND spa.course_cd = cohir.course_cd AND spa.person_id = cohir.person_id AND cohi.cohort_name = cohir. cohort_name AND cohi.load_cal_type = cohir.load_cal_type AND cohi.load_ci_sequence_number = cohir. load_ci_sequence_number

View Text - HTML Formatted

SELECT COHIR.ROWID
, COHI.COHORT_NAME
, COHI.LOAD_CAL_TYPE
, COHI.LOAD_CI_SEQUENCE_NUMBER
, COHIR.PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, COHIR.COURSE_CD
, PS.TITLE
, COHIR.AS_OF_RANK_GPA
, COHIR.COHORT_RANK
, COHIR.COHORT_OVERRIDE_RANK
, COHIR.COMMENTS
, COHIR.CREATED_BY
, COHIR.CREATION_DATE
, COHIR.LAST_UPDATED_BY
, COHIR.LAST_UPDATE_DATE
, COHIR.LAST_UPDATE_LOGIN
, COHIR.REQUEST_ID
, COHIR.PROGRAM_APPLICATION_ID
, COHIR.PROGRAM_ID
, COHIR.PROGRAM_UPDATE_DATE
FROM IGS_PR_COHINST_RANK COHIR
, IGS_PR_COHORT_INST COHI
, HZ_PARTIES HZ
, IGS_PS_VER PS
, IGS_EN_STDNT_PS_ATT SPA
, IGS_PS_OFR_OPT POO
WHERE COHIR.PERSON_ID = HZ.PARTY_ID
AND COHIR.COURSE_CD = PS.COURSE_CD
AND PS.VERSION_NUMBER = POO.VERSION_NUMBER
AND PS.COURSE_CD = POO.COURSE_CD
AND SPA.COO_ID = POO.COO_ID
AND SPA.COURSE_CD = COHIR.COURSE_CD
AND SPA.PERSON_ID = COHIR.PERSON_ID
AND COHI.COHORT_NAME = COHIR. COHORT_NAME
AND COHI.LOAD_CAL_TYPE = COHIR.LOAD_CAL_TYPE
AND COHI.LOAD_CI_SEQUENCE_NUMBER = COHIR. LOAD_CI_SEQUENCE_NUMBER