GL Open Balances Revaluation

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: GL Open Balances Revaluation Report
Short Name: GLXOBRVR
DB package: gl_open_bal_reval_rpt_pkg
            SELECT * FROM 
              (SELECT 
                      gcc.code_combination_id        ccid
                     ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_acct', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE')                     acct
                     ,gjh.currency_code              reval_jrnl_currency_code
                     ,gjs.user_je_source_name        reval_jrnl_source
                     ,gjc.user_je_category_name      reval_jrnl_category
                     ,gjh.name                       reval_jrnl_name
                     ,gjh.default_effective_date     reval_jrnl_effective_date
                     ,NVL(gjl.entered_dr,0)          reval_jrnl_line_ent_dr
                     ,NVL(gjl.entered_cr,0)          reval_jrnl_line_ent_cr
                     ,NVL(gjl.accounted_dr,0)        reval_jrnl_line_dr
                     ,NVL(gjl.accounted_cr,0)        reval_jrnl_line_cr
                     ,gl_open_bal_reval_rpt_pkg.get_reval_conversion_rate(gcc.code_combination_id
                                                                    ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_acct', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE')					 
                                                                    ,gjh.currency_code)   reval_conversion_rate
              FROM   
                      gl_je_headers gjh
                     ,gl_je_lines gjl 
                     ,gl_code_combinations gcc
                     ,gl_je_categories gjc
                     ,gl_je_sources gjs
                     ,gl_balances gb
              WHERE
                         gb.ledger_id=:ledger_id_param
                     AND gb.code_combination_id=gcc.code_combination_id
                     AND gb.period_name=:period_to_param
                     AND gb.actual_flag = 'A'
                     AND gb.translated_flag='R'
                     AND (NVL(gb.begin_balance_dr,0)+NVL(gb.period_net_dr,0))
                         <> (NVL(gb.begin_balance_cr,0)+NVL(gb.period_net_cr,0))
                     AND gjh.ledger_id = gb.ledger_id
                     AND gjh.je_source = 'Revaluation'
                     AND gjh.status = 'P'
                     AND gjh.actual_flag = 'A'	  
                     AND gjh.currency_code=gb.currency_code
                     AND gjl.effective_date BETWEEN :gd_start_date AND :gd_end_date
                     AND gjl.je_header_id = gjh.je_header_id	
                     AND gjl.code_combination_id = gb.code_combination_id
                     AND gjc.je_category_name = gjh.je_category
                     AND gjs.je_source_name = gjh.je_source
                     AND &gc_currency_where 
                     AND &acct_flex_where_clause
                     AND &gc_access_where 
              ORDER BY 
                      acct
                     ,reval_jrnl_currency_code )
            WHERE reval_conversion_rate IS NOT NULL
Parameter NameSQL textValidation
Period From
 
Chart Of Accounts ID
 
Number
Access Set ID
 
Number
Period
 
LOV Oracle
Account To
 
Account From
 
Currency
 
LOV Oracle
Ledger
 
LOV Oracle