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

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

ParameterTypeList of values SQL
Primary LedgerLOV Oracle
Secondary LedgerLOV Oracle
Journal SourceLOV Oracle
From AccountChar
To AccountChar
From PeriodLOV Oracle
To PeriodLOV Oracle