[Home] [Help]
View: FII_FC_V
Product: | FII - Financial Intelligence |
Description: | This view is based on tables FII_FIN_ITEM_LEAF_HIERS and FND_FLEX_VALUES_TL. It will contain information about Financial Category Hierarchy. |
Implementation/DBA Data: |
APPS.FII_FC_V
|
View Text
SELECT FLH.PARENT_FIN_CAT_ID PARENT_ID
, FLH.NEXT_LEVEL_FIN_CAT_ID ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING) VALUE
, CAT.FIN_CAT_TYPE_CODE TYPE
, DECODE(FLH.PARENT_LEVEL
, FLH.CHILD_LEVEL
, CAT.TOP_NODE_FLAG
, 'N') TOP_NODE_FLAG FROM FII_FIN_ITEM_LEAF_HIERS FLH
, FND_FLEX_VALUES_TL FFVT
, FII_FIN_CAT_TYPE_ASSGNS CAT
WHERE (FLH.CHILD_LEVEL = FLH.PARENT_LEVEL + 1 OR FLH.CHILD_LEVEL = FLH.PARENT_LEVEL )
AND FLH.CHILD_FIN_CAT_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')
AND FLH.CHILD_FIN_CAT_ID = CAT.FIN_CATEGORY_ID
Columns
Name |
PARENT_ID |
ID |
VALUE |
TYPE |
TOP_NODE_FLAG |