IGI Combined Basis Reports: Detail Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Public Sector Financials International
- Source
- Combined Basis Reports: Detail Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- IGIGCBGD_XML
- DB package
- IGI_IGIGCBGD_XMLP_PKG
Imported from BI Publisher
Combined Basis Reports: Detail Report
Combined Basis Reports: Detail Report
SQL 16 lines
SELECT gjb.default_period_name period_name, count(*) rec_count FROM gl_je_batches gjb, gl_je_headers gjh, (select distinct batch_id from IGI_CBR_GL_INTERFACE) cbr, gl_period_statuses gps WHERE gjb.parent_je_batch_id = cbr.batch_id and gjb.status != 'P' and gjh.je_batch_id = gjb.je_batch_id and gjh.ledger_id = :p_cash_sob_id and gps.set_of_books_id = gjh.ledger_id AND gps.application_id = 101 AND gps.effective_period_num between :cp_effective_period_from and :cp_effective_period_to AND gps.period_name = gjb.default_period_name GROUP BY gjb.default_period_name ORDER BY rec_count desc |
Parameters 7
| Parameter | Type | List of values SQL |
|---|---|---|
| Primary Ledger | LOV Oracle | |
| Secondary Ledger | LOV Oracle | |
| Journal Source | LOV Oracle | |
| From Account | Char | |
| To Account | Char | |
| From Period | LOV Oracle | |
| To Period | LOV Oracle |