JE Norwegian GEI S-

➜ Back to Library
Description
Categories: BI Publisher
Application: European Localizations
Source: Norwegian GEI S-Report (XML)
Short Name: JENOGEIS_XMLP
DB package: JE_NO_SREPORT_PKG
Run JE Norwegian GEI S- and other Oracle EBS reports with Blitz Report™ on our demo environment
     SELECT 'Z20'                                   TYPE_OF_ROW
           ,jesr.authority_type                           PARTY_QUALIFIER                         
           ,jesr.account_number                           ACCOUNT_NUMBER
           ,to_char(round(sum(nvl(jesr.balance,0)), :P_PRECISION), 'S99999999999999999D00') AMOUNT
	   ,jesr.natural_account                          NATURAL_ACCOUNT
	   ,jesr.segment_desc                             ACCOUNT_DESCRIPTION
     FROM je_no_gei_sreport_v jesr
     WHERE (:P_PERIOD_NUM > 12 and jesr.period_num = :P_PERIOD_NUM)
     AND jesr.period_year = :P_PERIOD_YEAR
     AND nvl(jesr.balance,0) <> 0
     AND jesr.template_id = :P_TEMPLATE_ID 
     AND jesr.actual_flag = 'A'
     GROUP BY jesr.authority_type, jesr.account_number, jesr.natural_account, jesr.segment_desc
	 having round(sum(nvl(jesr.balance,0)), :P_PRECISION) <>0
     UNION
     SELECT 'Z20'                                   TYPE_OF_ROW
	   ,jesr.authority_type                           PARTY_QUALIFIER                         
	   ,jesr.account_number                           ACCOUNT_NUMBER
	   ,TO_CHAR(ROUND(SUM(NVL(jesr.balance,0)), :P_PRECISION), 'S99999999999999999D00') AMOUNT
	   ,jesr.natural_account                          NATURAL_ACCOUNT
	   ,jesr.segment_desc                             ACCOUNT_DESCRIPTION
     FROM je_no_gei_sreport_v jesr
     WHERE (:P_PERIOD_NUM <= 12 AND jesr.period_num <= :P_PERIOD_NUM)                    
     AND jesr.period_year = :P_PERIOD_YEAR
     AND nvl(jesr.balance,0) <> 0
     AND jesr.template_id = :P_TEMPLATE_ID 
     AND jesr.actual_flag = 'A'
     GROUP BY jesr.authority_type, jesr.account_number, jesr.natural_account, jesr.segment_desc
	 having ROUND(SUM(NVL(jesr.balance,0)), :P_PRECISION) <>0
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Summary Template 
 
 LOV Oracle
Period 
 
 LOV Oracle
Download
Related Blitz Reports
JE Norwegian GEI A-Report- Not Supported: Reserved For Future Use JE Norwegian GEI Print Messages- Not Supported: Reserved For Future Use JE Hungarian Payables Invoice Aging - draft JE Finnish Payables Account by Detail- Not Supported: Reserved For Future Use CE Transactions Available for Reconciliation CE General Ledger Reconciliation JE German Payables VAT Reconciliation Detail Report- Not Supported: Reserved For Future Use JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use FV Data Act File C Activity
Blitz Report™

Blitz Report™ provides multiple benefits: