VIEW: APPS.FII_ALL_LINES_OF_BUSINESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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