SELECT c.code_combination_id,
c.concatenated_segments,
apps.fa_rx_flex_pkg.get_description(101 -- p_application_id
,
'GL#' -- p_id_flex_code
,
c.chart_of_accounts_id -- p_id_flex_num
,
'ALL',
c.concatenated_segments) acc_description
--, c.*
FROM apps.gl_code_combinations_kfv c
where c.code_combination_id = 7645831
xla_oa_functions_pkg.get_ccid_description(50328,cggi.code_combination_id) concatenated_description,