IGI Combined Basis Reports: Detail - draft

Description
Categories: BI Publisher
Columns: Period Name, Rec Count ...
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 Name SQL text Validation
Primary Ledger
 
LOV Oracle
Secondary Ledger
 
LOV Oracle
Journal Source
 
LOV Oracle
From Account
 
To Account
 
From Period
 
LOV Oracle
To Period
 
LOV Oracle
Data Access Set Id
 
Number
Chart of Accounts Id
 
LOV Oracle
Account Segment