[Home] [Help]
View: FII_FIN_ITEM_V
Product: | FII - Financial Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FFIH.CHILD_FIN_CAT_ID
, FFIH.PARENT_FIN_CAT_ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING)
, DENORM.FIN_CAT_TYPE_CODE
FROM FII_FIN_ITEM_HIERARCHIES FFIH
, FND_FLEX_VALUES_TL FFVT
, FII_FIN_CAT_TYPE_ASSGNS DENORM
WHERE FFIH.PARENT_LEVEL = 1
AND FFIH.CHILD_FIN_CAT_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')
AND FFIH.CHILD_FIN_CAT_ID = DENORM.FIN_CATEGORY_ID UNION ALL SELECT -999
, -999
, 'ALL'
, 'ALL'
FROM DUAL
Columns
Name |
ID |
PARENT_ID |
VALUE |
TYPE |