VIEW: APPS.MTH_USER_ENTITIES_OCV

Source

View Text - Preformatted

SELECT DISTINCT(A.CODE) CODE, A.MEANING MEANING, USERENV('LANG') LANGUAGE FROM (SELECT FND.LOOKUP_CODE CODE, FND.MEANING MEANING, USERENV('LANG') LANGUAGE FROM FND_LOOKUP_VALUES FND WHERE FND.LOOKUP_TYPE = 'MTH_OTHER_ENTITY_TYPE' AND FND.LOOKUP_CODE IN( 'SITE','RESOURCE') AND ENABLED_FLAG = 'Y' AND FND.SOURCE_LANG = USERENV('LANG') UNION SELECT ENT.ENTITY_TYPE CODE, FND.MEANING MEANING, USERENV('LANG') LANGUAGE FROM MTH_EQUIP_ENTITIES_MST ENT, FND_LOOKUP_VALUES FND WHERE ENT.ENTITY_TYPE = FND.LOOKUP_CODE AND FND.LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES' AND ENABLED_FLAG = 'Y' AND FND.SOURCE_LANG = USERENV('LANG') )A

View Text - HTML Formatted

SELECT DISTINCT(A.CODE) CODE
, A.MEANING MEANING
, USERENV('LANG') LANGUAGE
FROM (SELECT FND.LOOKUP_CODE CODE
, FND.MEANING MEANING
, USERENV('LANG') LANGUAGE
FROM FND_LOOKUP_VALUES FND
WHERE FND.LOOKUP_TYPE = 'MTH_OTHER_ENTITY_TYPE'
AND FND.LOOKUP_CODE IN( 'SITE'
, 'RESOURCE')
AND ENABLED_FLAG = 'Y'
AND FND.SOURCE_LANG = USERENV('LANG') UNION SELECT ENT.ENTITY_TYPE CODE
, FND.MEANING MEANING
, USERENV('LANG') LANGUAGE
FROM MTH_EQUIP_ENTITIES_MST ENT
, FND_LOOKUP_VALUES FND
WHERE ENT.ENTITY_TYPE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES'
AND ENABLED_FLAG = 'Y'
AND FND.SOURCE_LANG = USERENV('LANG') )A