VIEW: APPS.IGF_AW_LOOKUPS_VIEW

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)