VIEW: APPS.FII_ALL_NATURAL_ACCOUNTS_V

Source

View Text - Preformatted

SELECT DISTINCT fft.id_flex_structure_code struct_code, 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 = 101 AND fft.id_flex_code = 'GL#' AND fft.id_flex_num IN (SELECT distinct sa.chart_of_accounts_id FROM fii_source_ledger_groups slg, fii_slg_assignments sa WHERE slg.usage_code = 'DBI' and sa.source_ledger_group_id = slg.source_ledger_group_id) AND fsav.application_id = 101 AND fsav.id_flex_code = 'GL#' AND fsav.id_flex_num = fft.id_flex_num AND fsav.segment_attribute_type = 'GL_ACCOUNT' AND NVL(fsav.attribute_value,'X') = 'Y' AND ffs.application_id = 101 AND ffs.id_flex_code = 'GL#' 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 ffv.summary_flag = 'N' AND ffvt.flex_value_id = ffv.flex_value_id AND ffvt.language = userenv('LANG') ORDER BY ffv.flex_value

View Text - HTML Formatted

SELECT DISTINCT FFT.ID_FLEX_STRUCTURE_CODE STRUCT_CODE
, 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 = 101
AND FFT.ID_FLEX_CODE = 'GL#'
AND FFT.ID_FLEX_NUM IN (SELECT DISTINCT SA.CHART_OF_ACCOUNTS_ID
FROM FII_SOURCE_LEDGER_GROUPS SLG
, FII_SLG_ASSIGNMENTS SA
WHERE SLG.USAGE_CODE = 'DBI'
AND SA.SOURCE_LEDGER_GROUP_ID = SLG.SOURCE_LEDGER_GROUP_ID)
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.ID_FLEX_NUM = FFT.ID_FLEX_NUM
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND NVL(FSAV.ATTRIBUTE_VALUE
, 'X') = 'Y'
AND FFS.APPLICATION_ID = 101
AND FFS.ID_FLEX_CODE = 'GL#'
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 FFV.SUMMARY_FLAG = 'N'
AND FFVT.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG') ORDER BY FFV.FLEX_VALUE