View: FII_ALL_LINES_OF_BUSINESS_V

Product:	FII - Financial Intelligence
Description:	For Web ADI component
Implementation/DBA Data:	APPS.FII_ALL_LINES_OF_BUSINESS_V

View Text

SELECT FFV.FLEX_VALUE FLEX_VALUE
, FFVT.DESCRIPTION DESCRIPTION
FROM FND_ID_FLEX_STRUCTURES FFT
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
, FND_ID_FLEX_SEGMENTS FFS
, FND_FLEX_VALUES FFV
, FND_FLEX_VALUES_TL FFVT
WHERE FFT.APPLICATION_ID = 450
AND FFT.ID_FLEX_CODE = 'FII#'
AND FFT.ID_FLEX_STRUCTURE_CODE = 'DBI_DEFAULT_STRUCTURE'
AND FSAV.APPLICATION_ID = 450
AND FSAV.ID_FLEX_CODE = 'FII#'
AND FSAV.ID_FLEX_NUM = FFT.ID_FLEX_NUM
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'FII_LOB'
AND NVL(FSAV.ATTRIBUTE_VALUE
, 'X') = 'Y'
AND FFS.APPLICATION_ID = 450
AND FFS.ID_FLEX_CODE = 'FII#'
AND FFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
AND FFS.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
AND FFV.FLEX_VALUE_SET_ID = FFS.FLEX_VALUE_SET_ID
AND NVL(SUBSTR(FFV.COMPILED_VALUE_ATTRIBUTES
, 1
, 1)
, 'N') <> 'Y'
AND FFVT.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG') ORDER BY FFV.FLEX_VALUE

Columns