GL Budget - Master/Detail
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Master/Detail Budget Report
Application: General Ledger
Source: Budget - Master/Detail (XML)
Short Name: GLXRBCR_XML
DB package: GL_GLXRBCR_XMLP_PKG
Description: Master/Detail Budget Report
Application: General Ledger
Source: Budget - Master/Detail (XML)
Short Name: GLXRBCR_XML
DB package: GL_GLXRBCR_XMLP_PKG
Run
GL Budget - Master/Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger |
|
LOV Oracle | |
Master Budget |
|
LOV Oracle | |
Period |
|
LOV Oracle | |
Currency |
|
LOV Oracle | |
Amount Type |
|
LOV Oracle |