SELECT gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id, 1, gcc.segment1),
gcc.concatenated_segments,
xla_oa_functions_pkg.get_ccid_description(gcc.chart_of_accounts_id,
gcc.code_combination_id)
FROM gl_code_combinations_kfv gcc
WHERE gcc.code_combination_id = 1222