科目显示科目描述

时间：2010-07-27 来源：richardliu1123

SELECT apps.gl_flexfields_pkg.get_description_sql(&char_of_account_id,
                                                  1,
                                                  gcc.segment1) seg1,
       gl_flexfields_pkg.get_description_sql(&char_of_account_id,
                                             2,
                                             gcc.segment2) seg2,
       gl_flexfields_pkg.get_description_sql(&char_of_account_id,
                                             3,
                                             gcc.segment3) seg3,
       gl_flexfields_pkg.get_description_sql(&char_of_account_id,
                                             4,
                                             gcc.segment4) seg4,
       gl_flexfields_pkg.get_description_sql(&char_of_account_id,
                                             5,
                                             gcc.segment5) seg5
FROM gl_code_combinations gcc
WHERE gcc.segment4 = '31110' --gcc.code_combination_id = &code_combination_id;