View: IGS_AD_PS_APPL_INST_CONTEXT_V

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

View Text

SELECT ACAIV.ROW_ID ROW_ID
, ACAIV.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.FULL_NAME CONTEXT_BLOCK_NAME
, PDV.GENDER SEX
, PDV.BIRTH_DATE BIRTH_DT
, (SELECT DECODE(COUNT(ROWID)
, 0
, 'N'
, 'Y')
FROM IGS_PE_PERS_ENCUMB
WHERE PERSON_ID = PDV.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN START_DT
AND (NVL(EXPIRY_DT
, TRUNC(SYSDATE)+1)-1)) ENCUMBERED_IND
, DECODE(PP.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y') DECEASED_IND
, AA.ADMISSION_APPL_NUMBER
, AA.ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE
, AA.ACAD_CAL_TYPE
, AA.ACAD_CI_SEQUENCE_NUMBER
, CI1.ALTERNATE_CODE
, AA.ADM_CAL_TYPE
, AA.ADM_CI_SEQUENCE_NUMBER
, CI2.ALTERNATE_CODE
, CI1.ALTERNATE_CODE || '/' || CI2.ALTERNATE_CODE
, ACAIV.NOMINATED_COURSE_CD
, ACAIV.SEQUENCE_NUMBER
, ACAIV.COURSE_CD
, ACAIV.CRV_VERSION_NUMBER
, ACAIV.LOCATION_CD
, ACAIV.ATTENDANCE_MODE
, ACAIV.ATTENDANCE_TYPE
, ACAIV.PREFERENCE_NUMBER
, ACAIV.COURSE_CD || ' ' || ACAIV.CRV_VERSION_NUMBER
, PSV.TITLE COURSE_TITLE_DISPLAY
, ACAIV.CREATED_BY
, ACAIV.CREATION_DATE
, ACAIV.LAST_UPDATED_BY
, ACAIV.LAST_UPDATE_DATE
, ACAIV.LAST_UPDATE_LOGIN
, AA.APPLICATION_ID APPLICATION_ID
, AA.ALT_APPL_ID ALT_APPL_ID
FROM IGS_AD_PS_APPL_INST ACAIV
, IGS_AD_APPL AA
, IGS_PE_PERSON_BASE_V PDV
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, IGS_PS_VER PSV
, IGS_PE_HZ_PARTIES PD
, HZ_PERSON_PROFILES PP
WHERE ACAIV.PERSON_ID = AA.PERSON_ID
AND ACAIV.ADMISSION_APPL_NUMBER = AA.ADMISSION_APPL_NUMBER
AND ACAIV.PERSON_ID = PDV.PERSON_ID
AND CI1.CAL_TYPE = AA.ACAD_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = AA.ACAD_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = AA.ADM_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = AA.ADM_CI_SEQUENCE_NUMBER
AND ACAIV.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND ACAIV.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER
AND AA.PERSON_ID = PD.PARTY_ID
AND AA.PERSON_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE(+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)

Columns