[Home] [Help]
View: FII_FIN_ITEM_HIER_V
Product: | FII - Financial Intelligence |
Description: | Internal view used to support Financial Item Hierarchy in DBI. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FFIH.LEVEL_ID
, FFIH.PARENT_FLEX_VALUE
, FFIH.NEXT_LEVEL_FLEX_VALUE
, FFVT.DESCRIPTION
, FFIH.CHILD_FLEX_VALUE
, FFIH.CHILD_LEVEL_ID
FROM FII_FIN_ITEM_HIERARCHIES FFIH
, FND_FLEX_VALUES_TL FFVT
WHERE FFIH.NEXT_LEVEL_FLEX_VALUE_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')
Columns
Name |
LEVEL_ID |
PARENT_FLEX_VALUE |
NEXT_LEVEL_FLEX_VALUE |
NEXT_LEVEL_VALUE |
CHILD_FLEX_VALUE |
CHILD_LEVEL_ID |