eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FII_FC_V

Product:	FII - Financial Intelligence (Obsolete)
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:	Not implemented in this database

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