VIEW: APPS.IGSFV_AS_SUA_REFERENCE_CODES

Source

View Text - Preformatted

SELECT hp.party_name, hp.party_number, suarc.course_cd, crv.title, sua.unit_cd, uv.title, sua.cal_type, sua.ci_sequence_number, ci.description, suarc.reference_cd_type, suarc.reference_cd, suarc.applied_course_cd, crv1.title, suarc.person_id,sua.version_number, sca.version_number, suarc.reference_code_id, suarc.created_by, suarc.creation_date, suarc.last_updated_by, suarc.last_update_date, suarc.uoo_id FROM igs_as_sua_ref_cds suarc, hz_parties hp, igs_en_stdnt_ps_att_all sca, igs_ps_ver_all crv, igs_en_su_attempt_all sua, igs_ps_unit_ver_all uv, igs_ca_inst_all ci, igs_en_stdnt_ps_att_all sca1, igs_ps_ver_all crv1 WHERE suarc.person_id = hp.party_id AND suarc.person_id = sca.person_id AND suarc.course_cd = sca.course_cd AND sca.course_cd = crv.course_cd AND sca.version_number = crv.version_number AND suarc.person_id = sua.person_id AND suarc.course_cd = sua.course_cd AND suarc.uoo_id = sua.uoo_id AND sua.unit_cd = uv.unit_cd AND sua.version_number = uv.version_number AND sua.cal_type = ci.cal_type AND sua.ci_sequence_number = ci.sequence_number AND suarc.person_id = sca1.person_id AND suarc.applied_course_cd = sca1.course_cd AND sca1.course_cd = crv1.course_cd AND sca1.version_number = crv1.version_number WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, SUARC.COURSE_CD
, CRV.TITLE
, SUA.UNIT_CD
, UV.TITLE
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SUARC.REFERENCE_CD_TYPE
, SUARC.REFERENCE_CD
, SUARC.APPLIED_COURSE_CD
, CRV1.TITLE
, SUARC.PERSON_ID
, SUA.VERSION_NUMBER
, SCA.VERSION_NUMBER
, SUARC.REFERENCE_CODE_ID
, SUARC.CREATED_BY
, SUARC.CREATION_DATE
, SUARC.LAST_UPDATED_BY
, SUARC.LAST_UPDATE_DATE
, SUARC.UOO_ID
FROM IGS_AS_SUA_REF_CDS SUARC
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL CRV
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI
, IGS_EN_STDNT_PS_ATT_ALL SCA1
, IGS_PS_VER_ALL CRV1
WHERE SUARC.PERSON_ID = HP.PARTY_ID
AND SUARC.PERSON_ID = SCA.PERSON_ID
AND SUARC.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUARC.PERSON_ID = SUA.PERSON_ID
AND SUARC.COURSE_CD = SUA.COURSE_CD
AND SUARC.UOO_ID = SUA.UOO_ID
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SUA.CAL_TYPE = CI.CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SUARC.PERSON_ID = SCA1.PERSON_ID
AND SUARC.APPLIED_COURSE_CD = SCA1.COURSE_CD
AND SCA1.COURSE_CD = CRV1.COURSE_CD
AND SCA1.VERSION_NUMBER = CRV1.VERSION_NUMBER WITH READ ONLY