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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31558081/viewspace-2216395/,如需转载,请注明出处,否则将追究法律责任。