VIEW: APPS.IGSFV_STUDENT_UNIT_TRANSFERS

Source

View Text - Preformatted

SELECT SUT.PERSON_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, SUT.COURSE_CD, CRV1.TITLE, SUT.TRANSFER_COURSE_CD, CRV2.TITLE, SUT.TRANSFER_DT, SUT.UNIT_CD, UV.TITLE, UOO.VERSION_NUMBER, SUT.CAL_TYPE, SUT.CI_SEQUENCE_NUMBER, CI.START_DT, CI.END_DT, CI.DESCRIPTION, UOO.LOCATION_CD, LOC.DESCRIPTION, UOO.UNIT_CLASS, UC.DESCRIPTION, SUT.UOO_ID, SUT.CREATED_BY, SUT.CREATION_DATE, SUT.LAST_UPDATED_BY, SUT.LAST_UPDATE_DATE FROM IGS_PS_STDNT_UNT_TRN SUT, HZ_PARTIES HP, IGS_EN_STDNT_PS_ATT_ALL SCA1, IGS_EN_STDNT_PS_ATT_ALL SCA2, IGS_PS_VER_ALL CRV1, IGS_PS_VER_ALL CRV2, IGS_EN_SU_ATTEMPT_ALL SUA, IGS_PS_UNIT_VER_ALL UV, IGS_PS_UNIT_OFR_OPT_ALL UOO, IGS_CA_INST_ALL CI, IGS_AD_LOCATION_ALL LOC, IGS_AS_UNIT_CLASS_ALL UC WHERE SUT.PERSON_ID = HP.PARTY_ID AND SUT.PERSON_ID = SCA1.PERSON_ID AND SUT.COURSE_CD = SCA1.COURSE_CD AND SUT.COURSE_CD = CRV1.COURSE_CD AND SCA1.VERSION_NUMBER = CRV1.VERSION_NUMBER AND SUT.PERSON_ID = SCA2.PERSON_ID AND SUT.COURSE_CD = SCA2.COURSE_CD AND SUT.COURSE_CD = CRV2.COURSE_CD AND SCA2.VERSION_NUMBER = CRV2.VERSION_NUMBER AND SUT.PERSON_ID = SUA.PERSON_ID AND SUT.COURSE_CD = SUA.COURSE_CD AND SUT.UOO_ID = SUA.UOO_ID AND SUT.UOO_ID = UOO.UOO_ID AND SUA.UNIT_CD = UV.UNIT_CD AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER AND SUT.CAL_TYPE = CI.CAL_TYPE AND SUT.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND UOO.LOCATION_CD = LOC.LOCATION_CD AND UOO.UNIT_CLASS = UC.UNIT_CLASS WITH READ ONLY

View Text - HTML Formatted

SELECT SUT.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SUT.COURSE_CD
, CRV1.TITLE
, SUT.TRANSFER_COURSE_CD
, CRV2.TITLE
, SUT.TRANSFER_DT
, SUT.UNIT_CD
, UV.TITLE
, UOO.VERSION_NUMBER
, SUT.CAL_TYPE
, SUT.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO.UNIT_CLASS
, UC.DESCRIPTION
, SUT.UOO_ID
, SUT.CREATED_BY
, SUT.CREATION_DATE
, SUT.LAST_UPDATED_BY
, SUT.LAST_UPDATE_DATE
FROM IGS_PS_STDNT_UNT_TRN SUT
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA1
, IGS_EN_STDNT_PS_ATT_ALL SCA2
, IGS_PS_VER_ALL CRV1
, IGS_PS_VER_ALL CRV2
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_CA_INST_ALL CI
, IGS_AD_LOCATION_ALL LOC
, IGS_AS_UNIT_CLASS_ALL UC
WHERE SUT.PERSON_ID = HP.PARTY_ID
AND SUT.PERSON_ID = SCA1.PERSON_ID
AND SUT.COURSE_CD = SCA1.COURSE_CD
AND SUT.COURSE_CD = CRV1.COURSE_CD
AND SCA1.VERSION_NUMBER = CRV1.VERSION_NUMBER
AND SUT.PERSON_ID = SCA2.PERSON_ID
AND SUT.COURSE_CD = SCA2.COURSE_CD
AND SUT.COURSE_CD = CRV2.COURSE_CD
AND SCA2.VERSION_NUMBER = CRV2.VERSION_NUMBER
AND SUT.PERSON_ID = SUA.PERSON_ID
AND SUT.COURSE_CD = SUA.COURSE_CD
AND SUT.UOO_ID = SUA.UOO_ID
AND SUT.UOO_ID = UOO.UOO_ID
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SUT.CAL_TYPE = CI.CAL_TYPE
AND SUT.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UC.UNIT_CLASS WITH READ ONLY