GL Chart of Accounts - Account Hierarchy
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Account Hierarchies Listing
Application: General Ledger
Source: Chart of Accounts - Account Hierarchy (XML)
Short Name: GLXRLACH_XML
DB package: GL_GLXRLACH_XMLP_PKG
Description: Account Hierarchies Listing
Application: General Ledger
Source: Chart of Accounts - Account Hierarchy (XML)
Short Name: GLXRLACH_XML
DB package: GL_GLXRLACH_XMLP_PKG
Run
GL Chart of Accounts - Account Hierarchy and other Oracle EBS reports with Blitz Report™ on our demo environment
select st.template_name template , --null C_FLEXDATA_SUM, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_flexdata_sum', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXDATA_SUM, --null C_FLEXDATA_DET, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_flexdata_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXDATA_DET, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_sum', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_SUM, --&C_LPROMPT_SUM C_LPROMPT_SUM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_sum', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') C_DESC_ACCT_SUM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_sum_pad', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEXFIELD_SUM_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_DET, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') C_DESC_ACCT_DET, --GL_GLXRLACH_XMLP_PKG.new_descformula(:C_DESC_ACCT_DET) NEW_DESC, GL_GLXRLACH_XMLP_PKG.new_descformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION')) NEW_DESC, GL_GLXRLACH_XMLP_PKG.OLD_DESC_p OLD_DESC from gl_code_combinations cs1, gl_code_combinations cd, gl_summary_templates st, gl_account_hierarchies h where st.status = 'F' &WHERE_TEMPLATE and h.ledger_id = :P_LEDGER_ID and h.template_id = st.template_id and h.summary_code_combination_id = cs1.code_combination_id and h.detail_code_combination_id = cd.code_combination_id &WHERE_DAS order by &P_ORDER_BY_DET |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger |
|
LOV Oracle | |
Summary Template |
|
LOV Oracle |