JG JE GL Profit and Loss Report - Portugal

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Regional Localizations
Source: JE GL Profit and Loss Report - Portugal
Short Name: JEPTGLPL
DB package: JE_PT_GL_PFTLS_PKG
Run JG JE GL Profit and Loss Report - Portugal and other Oracle EBS reports with Blitz Report™ on our demo environment
 SELECT
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'612',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'612',amount)),0))  A,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'616',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'616',amount)),0))  B,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'62',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'62',amount)),0))  D,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'641',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'641',amount)),0))  +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'642',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'642',amount)),0))  E,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'643',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'643',amount)),0))  +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'644',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'644',amount)),0))  F,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'645',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'645',amount)),0))  +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'646',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'646',amount)),0))  +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'647',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'647',amount)),0))  + 
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'648',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'648',amount)),0))  G,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'662',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'662',amount)),0))  +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'663',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'663',amount)),0))  i,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'666',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'666',amount)),0))  +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'667',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'667',amount)),0))  I1,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'67',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'67',amount)),0))  J,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'63',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'63',amount)),0))  L,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'65',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'65',amount)),0))  M,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'682',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'682',amount)),0)) P,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'683',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'683',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'684',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'684',amount)),0)) Q,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68112',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68112',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68122',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68122',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68132',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68132',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68142',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68142',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68152',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68152',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68162',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68162',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68182',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68182',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6852',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6852',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6862',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6862',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6872',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6872',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6882',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6882',amount)),0)) R,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68111',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68111',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68121',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68121',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68131',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68131',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68141',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68141',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68151',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68151',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68161',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68161',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68181',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68181',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6851',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6851',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6861',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6861',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6871',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6871',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6881',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6881',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6883',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6883',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6884',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6884',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6885',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6885',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6886',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6886',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6887',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6887',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6888'