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