GL Trial Balance - Budget

Description
Categories: BI Publisher, Financials
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_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') BAL_FIELD,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') BAL_FIELD_W_DEP,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') BAL_DESC,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'SECURITY') BAL_SECURE,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCT_DESC,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_VALUE,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_VALUE_W_DEP,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'SECURITY') ACCT_SECURE,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXFIELD,
	GL_GLXBTB_XMLP_PKG.period_act_balformula(nvl ( be.begin_balance_dr , 0 ) - nvl ( be.begin_balance_cr , 0 ) + nvl ( be.period_net_dr , 0 ) - nvl ( be.period_net_cr , 0 ), nvl ( bb.begin_balance_dr , 0 ) - nvl ( bb.begin_balance_cr , 0 )) PERIOD_ACT_BAL,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') FLEX_SECURE
from gl_lookups l,
     gl_code_combinations cc,
     gl_balances bb,
     gl_balances be
where
         be.ledger_id = :P_LEDGER_ID
and   be.period_name = :P_TO_PERIOD_NAME
and   be.currency_code =:RESULTING_CURRENCY
and   be.actual_flag = 'B'
and   be.budget_version_id = :P_BUDGET_VERSION_ID
and   be.template_id is null
and   &TRANS_CHECK_BE
and   bb.ledger_id(+) = :P_LEDGER_ID
and   bb.period_name(+) = :P_FROM_PERIOD_NAME
and   bb.code_combination_id(+) =
      be.code_combination_id + 0
and   bb.currency_code(+) = :RESULTING_CURRENCY
and   bb.actual_flag(+) = 'B'
and   bb.budget_version_id(+) = :P_BUDGET_VERSION_ID
and   bb.template_id(+) is null
and   &TRANS_CHECK_BB
and   cc.code_combination_id =
      be.code_combination_id + 0
&WHERE_DAS
and   l.lookup_type = 'ACCOUNT TYPE'
and   l.lookup_code = cc.account_type
/*order by &ORDERBY_BAL, &ORDERBY_ACCT,
         &ORDERBY_ALL*/
order by fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE'),
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE')
Parameter Name SQL text Validation
GL_SRS_LEDGER_ID_UNVALIDATED
 
Number
Data Access Set ID
 
Number
To Period
 
LOV Oracle
From Period
 
LOV Oracle
Entered Currency
 
LOV Oracle
Currency Type
 
LOV Oracle
Ledger
 
LOV Oracle
Budget
 
LOV Oracle