GL Trial Balance - Encumbrance
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Trial Balance - Encumbrance (XML)
- Short Name
- GLXETB_XML
- DB package
- GL_GLXETB_XMLP_PKG
Imported from BI Publisher
Encumbrance Trial Balance
Encumbrance Trial Balance
SQL 41 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger/Ledger Set | LOV Oracle | |
| Encumbrance Type | LOV Oracle | |
| Period | LOV Oracle |