View: IGS_AD_PS_APPL_APLCNTX_V

Product:	IGS - Student System
Description:	View of IGS_AD_PS_APPL, for forms requiring this table as a context block. - Obsolete
Implementation/DBA Data:	APPS.IGS_AD_PS_APPL_APLCNTX_V

View Text

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)

Columns