VIEW: APPS.FII_ALL_FIN_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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