View: FII_FULL_USER_DEFINED2_V

Product:	FII - Financial Intelligence
Description:	This view is based on tables FII_FULL_UDD2_HIERS and FND_FLEX_VALUES_TL. It will contain information about the nodes in the full hierarchy of User Defined Dimension 2.
Implementation/DBA Data:	APPS.FII_FULL_USER_DEFINED2_V

View Text

SELECT -999 PARENT_ID
, FLH.PARENT_VALUE_ID ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING) VALUE FROM FII_FULL_UDD2_HIERS FLH
, FND_FLEX_VALUES_TL FFVT
WHERE FLH.PARENT_LEVEL = FLH.CHILD_LEVEL AND FLH.PARENT_VALUE_ID = FFVT.FLEX_VALUE_ID AND FFVT.LANGUAGE = USERENV('LANG')

Columns