VIEW: APPS.PAY_FR_ELEMENT_GROUP_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)