IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
BUD: Budgeting: Balanced Budget Journal Report
BUD: Budgeting: Balanced Budget Journal Report
SQL 27 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger ID | LOV Oracle | |
| Batch Name | LOV Oracle |