[Home] [Help]
View: FII_LOB_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 DISTINCT FLH.PARENT_LOB_ID
, FLH.NEXT_LEVEL_LOB_ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING)
FROM FII_LOB_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_LOB_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')
Columns