VIEW: APPS.IGSBV_STUD_PRG_PRE_ENROLLMENTS

Source

View Text - Preformatted

SELECT SCAE.PERSON_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, SCAE.COURSE_CD, PSV.TITLE, SCAE.CAL_TYPE, SCAE.CI_SEQUENCE_NUMBER, CI.START_DT, CI.END_DT, CI.DESCRIPTION, SCAE.ENROLMENT_CAT, SCAE.ENROLLED_DT, SCAE.ENR_FORM_DUE_DT, SCAE.ENR_PCKG_PROD_DT, SCAE.ENR_FORM_RECEIVED_DT, SCAE.CREATED_BY, SCAE.CREATION_DATE, SCAE.LAST_UPDATED_BY, SCAE.LAST_UPDATE_DATE FROM IGS_AS_SC_ATMPT_ENR SCAE, HZ_PARTIES HP, IGS_EN_STDNT_PS_ATT_ALL SCA, IGS_PS_VER_ALL PSV, IGS_CA_INST_ALL CI WHERE SCAE.PERSON_ID = HP.PARTY_ID AND SCAE.PERSON_ID = SCA.PERSON_ID AND SCAE.COURSE_CD = SCA.COURSE_CD AND SCAE.COURSE_CD = PSV.COURSE_CD AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER AND SCAE.CAL_TYPE = CI.CAL_TYPE AND SCAE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT SCAE.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SCAE.COURSE_CD
, PSV.TITLE
, SCAE.CAL_TYPE
, SCAE.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, SCAE.ENROLMENT_CAT
, SCAE.ENROLLED_DT
, SCAE.ENR_FORM_DUE_DT
, SCAE.ENR_PCKG_PROD_DT
, SCAE.ENR_FORM_RECEIVED_DT
, SCAE.CREATED_BY
, SCAE.CREATION_DATE
, SCAE.LAST_UPDATED_BY
, SCAE.LAST_UPDATE_DATE
FROM IGS_AS_SC_ATMPT_ENR SCAE
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL PSV
, IGS_CA_INST_ALL CI
WHERE SCAE.PERSON_ID = HP.PARTY_ID
AND SCAE.PERSON_ID = SCA.PERSON_ID
AND SCAE.COURSE_CD = SCA.COURSE_CD
AND SCAE.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SCAE.CAL_TYPE = CI.CAL_TYPE
AND SCAE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY