GL Chart of Accounts - Account Hierarchy

Description

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

GL Chart of Accounts - Account Hierarchy and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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

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

Download