[Home] [Help]
View: FII_LOB_HIER_V
Product: | FII - Financial Intelligence (Obsolete) |
Description: | Internal view used to support Line of Business Hierarchy in DBI. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FLH.LEVEL_ID
, FLH.PARENT_FLEX_VALUE
, FLH.NEXT_LEVEL_FLEX_VALUE
, FFVT.DESCRIPTION
, FLH.CHILD_FLEX_VALUE
FROM FII_LOB_HIERARCHIES FLH
, FND_FLEX_VALUES_TL FFVT
WHERE FLH.NEXT_LEVEL_FLEX_VALUE_ID = FFVT.FLEX_VALUE_ID
Columns
Name |
LEVEL_ID |
PARENT_FLEX_VALUE |
NEXT_LEVEL_FLEX_VALUE |
NEXT_LEVEL_VALUE |
CHILD_FLEX_VALUE |