This view is based on tables FII_FULL_COST_CTR_HIERS and FND_FLEX_VALUES_TL. It will contain information about the nodes in the full hierarchy of Cost Center.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT -999 PARENT_ID , FLH.PARENT_CC_ID ID , NVL(FFVT.DESCRIPTION , FFVT.FLEX_VALUE_MEANING) VALUE FROM FII_FULL_COST_CTR_HIERS FLH , FND_FLEX_VALUES_TL FFVT WHERE FLH.PARENT_LEVEL = FLH.CHILD_LEVEL AND FLH.PARENT_CC_ID = FFVT.FLEX_VALUE_ID AND FFVT.LANGUAGE = USERENV('LANG')