VIEW: APPS.IGS_AD_PS_APPL_APLCNTX_V

Source

View Text - Preformatted

SELECT aca.row_id row_id, aca.person_id, pdv.person_number, aca.admission_appl_number, aca.nominated_course_cd, pdv.api_person_id, pdv.person_id_type, pdv.full_name, pdv.sex_meaning, pdv.surname, pdv.given_names, pdv.preferred_given_name, pdv.title pe_title, pdv.context_block_name, pdv.sex, pdv.birth_dt, pdv.encumbered_ind, pdv.deceased_ind, aav.commencement_period, aav.admission_process_cat, crv.title, aca.created_by, aca.creation_date, aca.last_updated_by, aca.last_update_date, aca.last_update_login FROM IGS_AD_PS_APPL aca, IGS_PE_PERSON_V pdv, IGS_AD_APPL_ADMAPPL_V aav, IGS_PS_VER crv WHERE aca.person_id = pdv.person_id AND aca.person_id = aav.person_id AND aca.admission_appl_number = aav.admission_appl_number AND aca.nominated_course_cd = crv.course_cd AND crv.version_number = ( select max(crv2.version_number) from IGS_PS_VER crv2 where crv2.course_cd = aca.nominated_course_cd)

View Text - HTML Formatted

SELECT ACA.ROW_ID ROW_ID
, ACA.PERSON_ID
, PDV.PERSON_NUMBER
, ACA.ADMISSION_APPL_NUMBER
, ACA.NOMINATED_COURSE_CD
, PDV.API_PERSON_ID
, PDV.PERSON_ID_TYPE
, PDV.FULL_NAME
, PDV.SEX_MEANING
, PDV.SURNAME
, PDV.GIVEN_NAMES
, PDV.PREFERRED_GIVEN_NAME
, PDV.TITLE PE_TITLE
, PDV.CONTEXT_BLOCK_NAME
, PDV.SEX
, PDV.BIRTH_DT
, PDV.ENCUMBERED_IND
, PDV.DECEASED_IND
, AAV.COMMENCEMENT_PERIOD
, AAV.ADMISSION_PROCESS_CAT
, CRV.TITLE
, ACA.CREATED_BY
, ACA.CREATION_DATE
, ACA.LAST_UPDATED_BY
, ACA.LAST_UPDATE_DATE
, ACA.LAST_UPDATE_LOGIN
FROM IGS_AD_PS_APPL ACA
, IGS_PE_PERSON_V PDV
, IGS_AD_APPL_ADMAPPL_V AAV
, IGS_PS_VER CRV
WHERE ACA.PERSON_ID = PDV.PERSON_ID
AND ACA.PERSON_ID = AAV.PERSON_ID
AND ACA.ADMISSION_APPL_NUMBER = AAV.ADMISSION_APPL_NUMBER
AND ACA.NOMINATED_COURSE_CD = CRV.COURSE_CD
AND CRV.VERSION_NUMBER = ( SELECT MAX(CRV2.VERSION_NUMBER)
FROM IGS_PS_VER CRV2
WHERE CRV2.COURSE_CD = ACA.NOMINATED_COURSE_CD)