GL Budget - Master/Detail
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Budget - Master/Detail (XML)
- Short Name
- GLXRBCR_XML
- DB package
- GL_GLXRBCR_XMLP_PKG
Imported from BI Publisher
Master/Detail Budget Report
Master/Detail Budget Report
SQL 40 lines
select null FLEXDATA, &SELECT_MASTER_BUDGET MASTER_BUDGET_BAL, bv.budget_name DEPENDENT_BUDGET_NAME, &SELECT_DETAIL_BUDGET DETAIL_BUDGET_BAL, fnd_flex_xml_publisher_apis.process_kff_combination_1('acctdesc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCTDESC, 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, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield_pad', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') FLEXFIELD_PAD, GL_GLXRBCR_XMLP_PKG.available_budgetformula(nvl ( bm.period_net_dr , 0 ) - nvl ( bm.period_net_cr , 0 ), :TOTAL_DETAIL_BAL) AVAILABLE_BUDGET from gl_budget_versions bv, gl_balances bm, gl_balances bd, gl_code_combinations cc where cc.chart_of_accounts_id = :CHART_OF_ACCOUNTS_ID and cc.template_id is not null &WHERE_DAS and bm.ledger_id = :P_LEDGER_ID and bm.code_combination_id = cc.code_combination_id and bm.currency_code = :P_CURRENCY_CODE and bm.period_name = :P_PERIOD_NAME and bm.actual_flag = 'B' and bm.budget_version_id = :P_BUDGET_VERSION_ID and (bm.translated_flag is NULL OR bm.translated_flag = 'R') and bm.template_id is not NULL and bd.ledger_id = :P_LEDGER_ID and bd.code_combination_id = bm.code_combination_id and bd.currency_code = :P_CURRENCY_CODE and bd.period_name = :P_PERIOD_NAME and bd.actual_flag = 'B' and bd.budget_version_id in (select bv2.budget_version_id from gl_budget_versions bv2 where bv2.control_budget_version_id = :P_BUDGET_VERSION_ID) and (bd.translated_flag is NULL OR bd.translated_flag = 'R') and bd.template_id is not NULL and bv.budget_version_id = bd.budget_version_id order by &ORDERBY_FLEX, bv.budget_name |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle | |
| Master Budget | LOV Oracle | |
| Period | LOV Oracle | |
| Currency | LOV Oracle | |
| Amount Type | LOV Oracle |