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