GL Budget - Unbudgeted Master/Detail Accounts

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Unbudgeted Master/Detail Accounts Report
Application: General Ledger
Source: Budget - Unbudgeted Master/Detail Accounts (XML)
Short Name: GLRRBUDA_XML
DB package: GL_GLXRBUDA_XMLP_PKG
Run GL Budget - Unbudgeted Master/Detail Accounts and other Oracle EBS reports with Blitz Report™ on our demo environment
select
   &FLEXDATA                   				FLEXDATA_H,
   &ACCOUNT_SEG            				ACCOUNT_SEG_H,
  glbv.budget_name           				Dep_Bud_Name,
  &PTD_YTD                  				Dep_amount, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP
FROM
  gl_code_combinations   				cs,
  gl_balances                 				glbd,
  gl_budget_versions         				glbv
where
  glbd.ledger_id =    		:P_LEDGER_ID  AND
  glbd.currency_code =   	:P_CURRENCY_CODE AND	
  glbd.period_name =     	:P_PERIOD_NAME AND
  glbd.actual_flag =      	'B' AND
  glbd.code_combination_id = cs.code_combination_id		AND
  glbd.budget_version_id in
   (select glbv1.budget_version_id
    from gl_budget_versions glbv1
    where glbv1.control_budget_version_id = 
             :P_BUDGET_VERSION_ID)			AND
  glbd.budget_version_id = glbv.budget_version_id		AND
  NVL(glbd.translated_flag,'R') = 'R'			AND
  glbd.template_id is NOT NULL				AND
  glbd.code_combination_id NOT IN
  (select glbc.code_combination_id
    from gl_balances glbc
    where glbc.ledger_id = :P_LEDGER_ID AND
        glbc.period_name = :P_PERIOD_NAME AND
        glbc.currency_code = :P_CURRENCY_CODE AND
        glbc.budget_version_id = :P_BUDGET_VERSION_ID AND
        glbc.actual_flag = 'B')
  &WHERE_DAS
order by 1 ASC ,
  &FLEX_ORDERBY,
  glbv.budget_name
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Master Budget 
 
 LOV Oracle
Period 
 
 LOV Oracle
Currency 
 
 LOV Oracle
Amount Type 
 
 LOV Oracle
Download
Related Blitz Reports
GL Account Analysis GL Budget - Master/Detail GL Balance GL Account Analysis (Distributions) PA Revise Project Budget To Consumption ECC Projects, Projects Costing: Transactions, SQL1 IGI Process Impact Review- Not Supported: Reserved For Future Use IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget History Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™