GL Trial Balance - Encumbrance

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Trial Balance - Encumbrance (XML)
Short Name: GLXETB_XML
DB package: GL_GLXETB_XMLP_PKG
select null ACCTDATA,
       null BAL_DATA,
       null FLEXDATA,
       nvl(bal.begin_balance_dr,0) -
       nvl(bal.begin_balance_cr,0) BEGIN_BAL,
       nvl(bal.period_net_dr,0) DEBITS,
       nvl(bal.period_net_cr,0) CREDITS,
       l.name LEDGER_NAME, 
	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_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_FIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_FIELD_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_GLXETB_XMLP_PKG.end_balformula(nvl ( bal.begin_balance_dr , 0 ) - nvl ( bal.begin_balance_cr , 0 ), nvl ( bal.period_net_dr , 0 ), nvl ( bal.period_net_cr , 0 )) END_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_code_combinations cc,
         gl_balances bal,
         gl_ledgers l
         &FROM_LEDGER
where (   nvl(bal.begin_balance_dr, 0) -
          nvl(bal.begin_balance_cr, 0) != 0
       OR nvl(bal.period_net_dr, 0) != 0
       OR nvl(bal.period_net_cr, 0) != 0
      )
&WHERE_LEDGER
and   bal.period_name = :P_PERIOD_NAME
and   bal.currency_code = l.currency_code
and   bal.actual_flag = 'E'
and   bal.encumbrance_type_id = :P_ENCUMBRANCE_TYPE_ID
and   bal.template_id is null
and   bal.translated_flag is null
and   cc.code_combination_id = bal.code_combination_id + 0
and   l.ledger_id = bal.ledger_id
&WHERE_DAS
order by l.name, &ORDERBY_BAL, &ORDERBY_BAL2, &ORDERBY_ACCT,
             &ORDERBY_ACCT2, &ORDERBY_ALL
Parameter Name SQL text Validation
Access Set Id
 
Number
Period
 
LOV Oracle
Encumbrance Type
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle