VIEW: APPS.FND_FLEX_VALUE_DESTINATION_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'