GL Other - Calendar Validation

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Other - Calendar Validation Report (XML)
Short Name: GLXCLVAL_XML
DB package: GL_GLXCLVAL_XMLP_PKG
SELECT 
       m1.period_set_name period_set_dg,
       m1.period_type period_type_dg,
       m2.period_name before_per_dg,
       m3.period_name after_per_dg, 
       m1.accounting_date gap_start_date_dg,
       m3.accounting_date-1 gap_end_date_dg
FROM   gl_date_period_map m1,
       gl_date_period_map m2,
       gl_date_period_map m3
WHERE
      m1.accounting_date between :date_low 
                                                  and :date_high
AND   m1.period_name = 'NOT ASSIGNED'
AND   m2.period_set_name = :periodset
AND   m2.period_type = :periodtype
AND   m2.accounting_date+0 between :date_low 
                                                    and :date_high
AND   m2.accounting_date = m1.accounting_date-1
AND   m2.period_name != 'NOT ASSIGNED'
AND   m3.period_set_name = :periodset
AND   m3.period_type = :periodtype
AND   m3.accounting_date =
       ( SELECT min(m4.accounting_date)
         FROM gl_date_period_map m4 
         WHERE m4.period_set_name = :periodset
         AND   m4.period_type = :periodtype
         AND   m4.accounting_date between 
                  m1.accounting_date and :date_high
         AND   m4.period_name != 'NOT ASSIGNED' ) 
 and m1.period_set_name=:periodset 
 and m1.period_type=:periodtype
ORDER BY m1.accounting_date
Parameter NameSQL textValidation
Calendar
 
LOV Oracle
Period Type
 
LOV Oracle
Year From
 
Number
Year To
 
Number
Download
Related Blitz Reports
AI INV Period Close Details GCS Data Submission Impacted Balances Data Source GCS Data Submission Impacted Balances Base Data Source GMF Item Costs ECC Enterprise Asset Management, Work Order Assets (Maintenance) JG EMEA VAT: Allocation Rules Listing AI AP Trial Balance GL Chart of Accounts Mapping Rules AI INV On Hand Qty Value
Blitz Report™