[Home] [Help]
View: FII_COST_CENTER_V
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | This view is based on tables FII_COST_CTR_HIERARCHIES and FND_FLEX_VALUES_TL. It will contain information about Cost Center Hierarchy. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT FLH.PARENT_CC_ID PARENT_ID
, FLH.NEXT_LEVEL_CC_ID ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING) VALUE FROM FII_COST_CTR_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_CC_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')
Columns