Given a code_combination_id how can i get the code description? 获取科目组合描述

时间:2023-03-09 18:05:33
Given a code_combination_id how can i get the code description?  获取科目组合描述
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,