Reports2017-11-18T12:27:27+00:00

GL Budget - Master/Detail

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Master/Detail (XML)
Short Name: GLXRBCR_XML
DB package: GL_GLXRBCR_XMLP_PKG
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
Access Set Id
 
Number
Amount Type
 
LOV Oracle
Currency
 
LOV Oracle
Period
 
LOV Oracle
Master Budget
 
LOV Oracle
Ledger
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept