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_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 NameSQL textValidation
Budget
 
LOV Oracle
Ledger
 
LOV Oracle
Currency Type
 
LOV Oracle
Entered Currency
 
LOV Oracle
From Period
 
LOV Oracle
To Period
 
LOV Oracle
Data Access Set ID
 
Number
GL_SRS_LEDGER_ID_UNVALIDATED
 
Number