1.根据科目取得或创建CCID.
fnd_flex_ext.get_segs('SQLGL',
'GL#',
gcc.chart_of_accounts_id,
gcc.code_combination_id);
fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
key_flex_code => 'GL#',
structure_number => L_CHART_OF_ACCOUNTS_ID,--50470,
validation_date => to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),
concatenated_segments =>:CUX_17_CST_MAPP_RULE_ALL.ACCOUNTING);
2.取得科目描述
SELECT xla_oa_functions_pkg.get_ccid_description(gcc.chart_of_accounts_id
,gcc.code_combination_id) account_desc <
,gcc.code_combination_id) account_desc <