IGI Balanced Budget Journal - draft

Description
Categories: BI Publisher, Financials
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
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 NameSQL textValidation
Data Access Set ID
 
Number
Chart of Accounts ID
 
LOV Oracle
Batch Name
 
LOV Oracle
Ledger ID
 
LOV Oracle