VIEW: APPS.IGS_AD_PS_APLCNTX_LKUP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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