VIEW: APPS.ENI_RESOURCE_GROUP_V

Source

View Text - Preformatted

SELECT RG.LOOKUP_CODE || '-1' ID, RG.MEANING VALUE FROM FND_LOOKUP_VALUES RG WHERE LOOKUP_TYPE= 'CRP_RESOURCE_GROUPS' AND LANGUAGE = USERENV('LANG') UNION ALL SELECT DISTINCT RG.RESOURCES || '-2' ID, RG.RESOURCE_DESC VALUE FROM CR_RSRC_MST_TL RG, CR_RSRC_DTL R WHERE R.GROUP_RESOURCE = RG.RESOURCES AND RG.LANGUAGE = USERENV('LANG') UNION ALL SELECT LOOKUP_CODE ID, DESCRIPTION VALUE FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'RESOURCE_DIM' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT RG.LOOKUP_CODE || '-1' ID
, RG.MEANING VALUE
FROM FND_LOOKUP_VALUES RG
WHERE LOOKUP_TYPE= 'CRP_RESOURCE_GROUPS'
AND LANGUAGE = USERENV('LANG') UNION ALL SELECT DISTINCT RG.RESOURCES || '-2' ID
, RG.RESOURCE_DESC VALUE
FROM CR_RSRC_MST_TL RG
, CR_RSRC_DTL R
WHERE R.GROUP_RESOURCE = RG.RESOURCES
AND RG.LANGUAGE = USERENV('LANG') UNION ALL SELECT LOOKUP_CODE ID
, DESCRIPTION VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'RESOURCE_DIM'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG')