SELECT A.FLEX_VALUE_SET_ID , FLEX_VALUE , A.DESCRIPTION , B.HIERARCHY_NAME , HIERARCHY_LEVEL FROM FND_FLEX_VALUES_VL A , FND_FLEX_HIERARCHIES_TL B WHERE A.FLEX_VALUE_SET_ID = B.FLEX_VALUE_SET_ID (+) AND A.STRUCTURED_HIERARCHY_LEVEL = B.HIERARCHY_ID (+) AND B.LANGUAGE (+) = USERENV('LANG') AND SUMMARY_FLAG = 'Y'