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
Run IGI Combined Basis Reports: Detail Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
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 Journals - Tax GL Account Analysis GL General Ledger - (132 Char) GL Account Analysis (Distributions) 11g GL Turnover for Selected Segments JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use GL Reconciliation - Unreconciled Transactions GL Reconciliation - Reconciled Transactions GL Budget - Journals by Account
Blitz Report™

Blitz Report™ provides multiple benefits: