View: IGF_AW_LOOKUPS_VIEW

Product:	IGF - Financial Aid
Description:	Award year specific Lookups View
Implementation/DBA Data:	APPS.IGF_AW_LOOKUPS_VIEW

View Text

SELECT BM.SYS_AWARD_YEAR
, BM.CI_CAL_TYPE
, BM.CI_SEQUENCE_NUMBER
, LV.LOOKUP_TYPE
, LV.LOOKUP_CODE
, LV.MEANING
, LV.DESCRIPTION
, LV.ENABLED_FLAG
FROM FND_LOOKUP_VALUES LV
, IGF_AP_BATCH_AW_MAP_ALL BM
WHERE LV.LANGUAGE = USERENV ('LANG')
AND LV.VIEW_APPLICATION_ID = 8406
AND LV.SECURITY_GROUP_ID = 0
AND NOT EXISTS ( SELECT EX.SYS_AWARD_YEAR
, EX.LOOKUP_TYPE
, EX.LOOKUP_CODE
FROM IGF_AW_LKUP_OVD_DET EX
WHERE EX.SYS_AWARD_YEAR = BM.SYS_AWARD_YEAR
AND EX.LOOKUP_TYPE = LV.LOOKUP_TYPE
AND EX.LOOKUP_CODE = LV.LOOKUP_CODE)

Columns