SELECT USERCODE.LOOKUP_CODE , USERCODE.MEANING , USERCODE.TAG FROM FND_LOOKUP_VALUES USERCODE WHERE USERCODE.LOOKUP_TYPE = 'FR_USER_ELEMENT_GROUP' AND USERCODE.LANGUAGE = USERENV('LANG') UNION SELECT MAINCODE.LOOKUP_CODE , MAINCODE.MEANING , MAINCODE.TAG FROM FND_LOOKUP_VALUES MAINCODE WHERE MAINCODE.LOOKUP_TYPE = 'FR_ELEMENT_GROUP' AND MAINCODE.LANGUAGE = USERENV('LANG') AND NOT EXISTS (SELECT NULL FROM FND_LOOKUP_VALUES USERCODE1 WHERE USERCODE1.LOOKUP_TYPE = 'FR_USER_ELEMENT_GROUP' AND USERCODE1.LANGUAGE = USERENV('LANG') AND USERCODE1.LOOKUP_CODE = MAINCODE.LOOKUP_CODE)