EBS导出键弹性域

select gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
1,
gcc.segment1) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
2,
gcc.segment2) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
3,
gcc.segment3) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
4,
gcc.segment4) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
5,
gcc.segment5) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
6,
gcc.segment6) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
7,
gcc.segment7) || '-' ||
gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
8,
gcc.segment8) as 描述,
from gl_code_combinations gcc
where gcc.code_combination_id = code_combination_id;