IGI Combined Basis Reports: Detail - draft

Description
Categories: BI Publisher, Financials
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
Account Segment
 
Chart of Accounts Id
 
LOV Oracle
Data Access Set Id
 
Number
To Period
 
LOV Oracle
From Period
 
LOV Oracle
To Account
 
From Account
 
Journal Source
 
LOV Oracle
Secondary Ledger
 
LOV Oracle
Primary Ledger
 
LOV Oracle
Ask a question