View: FII_USER_DEFINED1_V

Product:	FII - Financial Intelligence
Description:	This view is based on tables FII_UDD1_HIERARCHIES and FND_FLEX_VALUES_TL. It will contain information about User Defined Dimension 1 Hierarchy.
Implementation/DBA Data:	APPS.FII_USER_DEFINED1_V

View Text

SELECT FLH.PARENT_VALUE_ID PARENT_ID
, FLH.NEXT_LEVEL_VALUE_ID ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING) VALUE FROM FII_UDD1_HIERARCHIES FLH
, FND_FLEX_VALUES_TL FFVT
WHERE (FLH.CHILD_LEVEL = FLH.PARENT_LEVEL + 1 OR FLH.CHILD_LEVEL = FLH.PARENT_LEVEL )
AND FLH.CHILD_VALUE_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')

Columns