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
Ask a question