[Home] [Help]
View: FII_USER_DEFINED2_V
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | This view is based on tables FII_UDD2_HIERARCHIES and FND_FLEX_VALUES_TL. It will contain information about User Defined Dimension 2 Hierarchy. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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_UDD2_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