View: PAY_FR_ELEMENT_GROUP_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_FR_ELEMENT_GROUP_V

View Text

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)

Columns