View: FII_FIN_ITEM_V

Product:	FII - Financial Intelligence
Description:
Implementation/DBA Data:	APPS.FII_FIN_ITEM_V

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