IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Balanced Budget Journal Report
Application: Public Sector Financials International
Source: Budgeting: Balanced Budget Journal Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBJRB_XML
DB package: IGI_IGIGBJRB_XMLP_PKG
Run IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 	gsob.NAME SOB_NAME,
	bat.FISCAL_YEAR,
	bat.NAME BATCH_NAME,
	to_char(bat.CREATION_DATE,'DD-MON-YYYY') CREATION_DATE,
	bat.DATE_COMPLETED,
	head.NAME JOURNAL_NAME,
	head.CURRENCY_CODE,
	head.DEFAULT_REASON_CODE,
	head.BE_HEADER_ID,
	head.DESCRIPTION,
	head.JE_CATEGORY_NAME,
	ent.NAME ORGANISATION,
	vers.BUDGET_NAME
FROM	GL_SETS_OF_BOOKS gsob,
	IGI_BUD_JOURNAL_HEADERS head,
	IGI_BUD_JOURNAL_BATCHES bat,
	GL_BUDGET_ENTITIES ent,
	GL_BUDGET_VERSIONS vers
WHERE	gsob.SET_OF_BOOKS_ID = :P_SOB
AND 	gsob.SET_OF_BOOKS_ID = bat.SET_OF_BOOKS_ID
AND	bat.BE_BATCH_ID = :P_BE_BATCH
AND 	bat.BE_BATCH_ID = head.BE_BATCH_ID
AND	bat.RECORD_TYPE = 'B'
AND	head.BUDGET_VERSION_ID = vers.BUDGET_VERSION_ID(+)
AND	head.BUDGET_ENTITY_ID = ent.BUDGET_ENTITY_ID(+)
ORDER BY SOB_NAME, BATCH_NAME, JOURNAL_NAME
Parameter Name SQL text Validation
Ledger ID 
 
 LOV Oracle
Batch Name 
 
 LOV Oracle
Download
Related Blitz Reports
IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use GL Account Analysis (Distributions) GL Account Analysis (Distributions) 11g GL Account Analysis 11g COPY OF: GL Account Analysis GL Account Analysis
Blitz Report™

Blitz Report™ provides multiple benefits: