SELECT F.FLEX_VALUE_ID , F.FLEX_VALUE , T.DESCRIPTION FROM FND_FLEX_VALUES F , FND_FLEX_VALUES_TL T WHERE FLEX_VALUE_SET_ID IN (SELECT MASTER_VALUE_SET_ID FROM FII_FINANCIAL_DIMENSIONS WHERE DIMENSION_SHORT_NAME = 'GL_FII_FIN_ITEM' ) AND F.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND T.LANGUAGE = USERENV('LANG') ORDER BY F.FLEX_VALUE