View: IGF_AP_IA_LOOKUP_V

Product:	IGF - Financial Aid
Description:	Lookup Types required for Institutional Application LOV items
Implementation/DBA Data:	APPS.IGF_AP_IA_LOOKUP_V

View Text

SELECT 'ATTENDANCE_MODE' LOOKUP_TYPE
, ATTENDANCE_MODE LOOKUP_CODE
, DESCRIPTION MEANING
FROM IGS_EN_ATD_MODE
WHERE NVL(CLOSED_IND
, 'N') <> 'Y' UNION SELECT 'ATTENDANCE_TYPE' LOOKUP_TYPE
, ATTENDANCE_TYPE LOOKUP_CODE
, DESCRIPTION MEANING
FROM IGS_EN_ATD_TYPE
WHERE NVL(CLOSED_IND
, 'N') <> 'Y' UNION SELECT 'CLASS_STANDING' LOOKUP_TYPE
, CLASS_STANDING LOOKUP_CODE
, DESCRIPTION MEANING
FROM IGS_PR_CLASS_STD_V
WHERE CLOSED_IND = 'N' UNION SELECT 'HOUSING_STATUS_CODE' LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'PE_TEA_PER_RES'
AND ENABLED_FLAG = 'Y' UNION SELECT 'ORG_UNIT_CD' LOOKUP_TYPE
, IOU.ORG_UNIT_CD LOOKUP_CODE
, IOU.DESCRIPTION MEANING
FROM IGS_OR_UNIT IOU
, IGS_OR_STATUS IOS
WHERE IOU.ORG_STATUS = IOS.ORG_STATUS
AND IOS.S_ORG_STATUS = 'ACTIVE' UNION SELECT DISTINCT 'PROGRAM_CD' LOOKUP_TYPE
, COURSE_CD LOOKUP_CODE
, TITLE MEANING
FROM IGS_PS_VER IPV
, IGS_PS_STAT IPS
WHERE IPV.COURSE_STATUS = IPS.COURSE_STATUS
AND IPS.S_COURSE_STATUS = 'ACTIVE' GROUP BY COURSE_CD
, TITLE
, VERSION_NUMBER HAVING VERSION_NUMBER = MAX(VERSION_NUMBER) UNION SELECT 'PROGRAM_LOCATION_CD' LOOKUP_TYPE
, LOCATION_CD LOOKUP_CODE
, DESCRIPTION MEANING
FROM IGS_AD_LOCATION
WHERE NVL(CLOSED_IND
, 'N') <> 'Y' UNION SELECT 'PROGRAM_TYPE' LOOKUP_TYPE
, COURSE_TYPE LOOKUP_CODE
, DESCRIPTION MEANING
FROM IGS_PS_TYPE_V
WHERE NVL(CLOSED_IND
, 'N') <> 'Y' UNION SELECT 'RESIDENCY_STATUS_CODE' LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'PE_RES_STATUS'
AND ENABLED_FLAG = 'Y' UNION SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
FROM IGF_LOOKUPS_VIEW
WHERE LOOKUP_TYPE IN (SELECT DISTINCT LOOKUP_CODE LOOKUP_TYPE
FROM IGF_AP_APPL_SETUP_ALL
WHERE LOOKUP_CODE IS NOT NULL)

Columns