Oracle EBS R12 Useful Queries

Get chart of accounts description

SELECT code_combination_id, chart_of_accounts_id, account_type,
segment1 seg1,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,1,gcc.segment1) seg1_desc,
segment2 seg2,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,2,gcc.segment2) seg2_desc,
segment3 seg3,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,3,gcc.segment3) seg3_desc,
segment4 seg4,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,4,gcc.segment4) seg4_desc,
segment5 seg5,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,5,gcc.segment5) seg5_desc          
  FROM gl_code_combinations gcc
  WHERE code_combination_id=<id>;