JE Norwegian GEI S-

Description
Categories: BI Publisher
Application: European Localizations
Source: Norwegian GEI S-Report (XML)
Short Name: JENOGEIS_XMLP
DB package: JE_NO_SREPORT_PKG
     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
Period
 
LOV Oracle
Summary Template
 
LOV Oracle
Ledger
 
LOV Oracle
Ask a question