Which table stores the hierarchies in ERP Cloud?
In which table can I find this information?, Is there a NODO table?
- - Investigating, I found the following statement gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,5,gcc.segment5), what is it for?
- - The report (Gl Trial Balance Report) does something similar to the report that I need but uses a package called JGZZGLTRB , but I did not find information about how to use it:
I did not find information about that package (JGZZGLTRB) and about the gl_flexfields_pkg.get_description_sq line
fnd_flex_xml_publisher_apis.process_kff_combination_1('ACCT_DESC', 'GL', 'GL#', :COA_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'N', 'DESCRIPTION') ACCT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('ACCT_VALUE_DESC', 'GL', 'GL#', :COA_ID, NULL, CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'DESCRIPTION') ACCT_VALUE_DESC,