GL Trial Balance - Budget

Description
Categories: BI Publisher
Application: General Ledger
Source: Trial Balance - Budget (XML)
Short Name: GLXBTB_XML
DB package: GL_GLXBTB_XMLP_PKG
select null ACCTDATA,
       null BAL_DATA,
       null FLEXDATA,
       l.description ACCT_TYPE,
       nvl(bb.begin_balance_dr,0) -
       nvl(bb.begin_balance_cr,0) BEGIN_BAL,
       nvl(be.begin_balance_dr,0) -
       nvl(be.begin_balance_cr,0) +
       nvl(be.period_net_dr,0) -
       nvl(be.period_net_cr,0) END_BAL,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_field', 'SQLGL', 'GL#', CC.CHART