eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AD_PS_APLCNTX_LKUP_V

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

View Text

SELECT ACACV.PERSON_ID PERSON_ID
, ACACV.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, ACACV.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, ACACV.CONTEXT_BLOCK_NAME CONTEXT_BLOCK_NAME
, ACACV.SEX SEX
, DECODE ( ACACV.SEX
, NULL
, NULL
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE ACACV.SEX = LOOKUP_CODE
AND LOOKUP_TYPE = 'HZ_GENDER'
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG') )) MEANING_SEX
, ACACV.BIRTH_DT BIRTH_DT
, ACACV.ENCUMBERED_IND ENCUMBERED_IND
, ACACV.DECEASED_IND DECEASED_IND
, ACACV.COMMENCEMENT_PERIOD COMMENCEMENT_PERIOD
, ACACV.ADMISSION_PROCESS_CAT ADMISSION_PROCESS_CAT
, ACACV.TITLE TITLE
, ACACV.CREATED_BY CREATED_BY
, ACACV.CREATION_DATE CREATION_DATE
, ACACV.LAST_UPDATED_BY LAST_UPDATED_BY
, ACACV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACACV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PS_APPL_APLCNTX_V ACACV

Columns

Name
PERSON_ID
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
CONTEXT_BLOCK_NAME
SEX
MEANING_SEX
BIRTH_DT
ENCUMBERED_IND
DECEASED_IND
COMMENCEMENT_PERIOD
ADMISSION_PROCESS_CAT
TITLE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN