查看会计科目，ccid，和科目描述

1、通过账户查找ccid

fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
                                     key_flex_code          => 'GL#',
                                     structure_number       => l_char_id, --SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS
                                     validation_date        => to_char(SYSDATE,
                                                                       'YYYY-MM-DD'),
                                     concatenated_segments  => l_account)  --科目账户

2、通过ccid查看科目

fnd_flex_ext.get_segs(application_short_name => 'SQLGL',
                                         key_flex_code          => 'GL#',
                                         structure_number       => l_char_id,
                                         combination_id         => l_num);

3、通过ccid查看科目描述

SELECT xla_oa_functions_pkg.get_ccid_description(chart_of_accounts_id
                                                ,code_combination_id)
  FROM gl_code_combinations

以上都是系统标准function,返回值就是结果，可在sql中直接使用