PSB Budget Revision Summary

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Budget Revision Summary Report (XML)
Short Name: PSBRPBRS_XML
DB package: PSB_PSBRPBRS_XMLP_PKG
Run PSB Budget Revision Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select a.budget_revision_id, 
      a.budget_group_id,
     a.gl_budget_version_id,
      a.code_combination_id,
      a.currency_code,
       b.concatenated_segments,
       a.gl_budget_name,
       a.start_period,
       a.end_period,
       a.budget_balance,
       a.revision_amount,
       decode(:cf_document_posting_status, 0, a.budget_balance + a.revision_amount, a.budget_balance) rev_budget,
       b.description,
       a.set_of_books_id,
       a.chart_of_accounts_id, 
	PSB_PSBRPBRS_XMLP_PKG.cf_document_posting_statusform(a.currency_code) CF_document_posting_status, 
	PSB_PSBRPBRS_XMLP_PKG.cf_original_budgetformula(a.code_combination_id, a.budget_group_id, a.start_period, a.gl_budget_version_id, a.set_of_books_id, a.end_period, a.currency_code) CF_original_budget, 
	PSB_PSBRPBRS_XMLP_PKG.cf_percent_changeformula(a.budget_balance, a.revision_amount) CF_percent_change, 
	PSB_PSBRPBRS_XMLP_PKG.cf_acct_flex_descformula(a.chart_of_accounts_id, a.code_combination_id) CF_Acct_Flex_Desc,
	PSB_PSBRPBRS_XMLP_PKG.CP_ORIGINAL_BUDGET_p CP_ORIGINAL_BUDGET
from psb_budget_revision_summary_v a,
       gl_code_combinations_kfv b
 where a.code_combination_id = b.code_combination_id
    and  a.chart_of_accounts_id = b.chart_of_accounts_id
     and a.budget_revision_id = :p_budget_revision_id
	 ORDER BY 1 ASC,5 ASC,7 ASC,2 ASC
Parameter Name SQL text Validation
Budget Revision Number 
 
 LOV Oracle
Download
Related Blitz Reports
PSB Budget Revision Summary Report by Responsibility PSB Worksheet Account Costing PSB Worksheet Account Costing Report By Responsibility PSB Budget Revisions Transaction PSB Budget Revisions Transaction Report By Responsibility PSB Stage Variance Report for Account PSB Stage Variance Report for Account by Responsibility PSB Budget Journal Edit PSB Pooled Position Report for Worksheet
Blitz Report™

Blitz Report™ provides multiple benefits: