VIEW: APPS.IGF_AP_IA_LOOKUP_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)