View: FND_FLEX_VALUE_DESTINATION_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_FLEX_VALUE_DESTINATION_V

View Text

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'

Columns