select		val.FLEX_VALUE
,		valtl.DESCRIPTION
from		FND_ID_FLEXS	 			flex
,		FND_ID_FLEX_SEGMENTS			seg
,		FND_ID_FLEX_STRUCTURES			struc 
,		FND_FLEX_VALUES				val
,		FND_FLEX_VALUES_TL			valtl
where		flex.ID_FLEX_NAME			= 'Accounting Flexfield'
and		struc.ID_FLEX_STRUCTURE_CODE		=  &&structure
and		seg.SEGMENT_NAME			=  &&segment
and		val.FLEX_VALUE				=  &&flex_value
and		struc.ID_FLEX_NUM			=  SEG.ID_FLEX_NUM
and		seg.ID_FLEX_CODE			=  FLEX.ID_FLEX_CODE
and		val.FLEX_VALUE_SET_ID			=  SEG.FLEX_VALUE_SET_ID
and		valtl.FLEX_VALUE_ID			=  val.FLEX_VALUE_ID
and		valtl.LANGUAGE				=  USERENV('LANG')
order by	val.FLEX_VALUE;