Skip to content FND Design Data [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