View: FII_COMPANY_VALUES_V

Product:	FII - Financial Intelligence
Description:	This view is for the Company Dimension master value set node names and description.
Implementation/DBA Data:	APPS.FII_COMPANY_VALUES_V

View Text

SELECT DISTINCT FLEXVAL.FLEX_VALUE_ID ID
, FLEXVAL.FLEX_VALUE VALUE
, FLEXVAL.DESCRIPTION
, C.IS_LEAF_FLAG
FROM FND_FLEX_VALUES_VL FLEXVAL
, FII_FINANCIAL_DIMENSIONS FDIM
, FII_COMPANY_HIERARCHIES C
WHERE FDIM.MASTER_VALUE_SET_ID = FLEXVAL.FLEX_VALUE_SET_ID
AND FDIM.DIMENSION_SHORT_NAME = 'FII_COMPANIES'
AND FLEXVAL.FLEX_VALUE_ID = C.PARENT_COMPANY_ID

Columns