GL Chart of Accounts - Account Hierarchy

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