Oracle Notes

使用Oracle內建的Package gl_flexfields_pkg.get_description_sql,
以後就不用自己寫Code去抓Account Description了
SQL Script如下:

SELECT gcc.code_combination_id,

       gcc.segment1,

       gcc.segment2,

       gcc.segment3,

       gcc.segment4,

       gcc.segment5,

       gcc.segment6,

       gcc.segment7,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               1,

                                               gcc.segment1) segment1_desc,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               2,

                                               gcc.segment2) segment2_desc,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               3,

                                               gcc.segment3) segment3_desc,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               4,

                                               gcc.segment4) segment4_desc,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               5,

                                               gcc.segment5) segment5_desc,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               6,

                                               gcc.segment6) segment6_desc,

       gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,

                                               7,

                                               gcc.segment7) segment7_desc,

       gcc.chart_of_accounts_id chart_of_accounts_id,

       gcc.account_type

  FROM gl_code_combinations gcc