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,

posted @ 2016-03-15 10:50  我不卖豆腐  阅读(451)  评论(0)  编辑  收藏  举报