VIEW: APPS.MTH_ITEMS_OCV

Source

View Text - Preformatted

SELECT DISTINCT(D.LEVEL9_FK_KEY) CODE, C.CATEGORY_NAME MEANING, USERENV('LANG') LANGUAGE FROM MTH_ITEM_DENORM_D D, MTH_ITEM_CATEGORIES_D C WHERE D.LEVEL9_FK_KEY = C.CATEGORY_PK_KEY AND D.HIERARCHY_ID = ( SELECT FND_PROFILE.VALUE('MTH_UDA_ITEM_PROFILE') FROM DUAL )

View Text - HTML Formatted

SELECT DISTINCT(D.LEVEL9_FK_KEY) CODE
, C.CATEGORY_NAME MEANING
, USERENV('LANG') LANGUAGE
FROM MTH_ITEM_DENORM_D D
, MTH_ITEM_CATEGORIES_D C
WHERE D.LEVEL9_FK_KEY = C.CATEGORY_PK_KEY
AND D.HIERARCHY_ID = ( SELECT FND_PROFILE.VALUE('MTH_UDA_ITEM_PROFILE')
FROM DUAL )