IGI Combined Basis Reports: Detail Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Combined Basis Reports: Detail Report
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
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
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
GL MoFU KPI Dashboard Exceptions GL MoFU KPI Dashboard GL Journals - Tax GL Turnover for Selected Segments JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use TB GL Account Analysis (Drilldown)v2 GL Reconciliation - Unreconciled Transactions GL Reconciliation - Reconciled Transactions GL Budget - Journals by Account
Blitz Report™