JG JE GL Profit and Loss Report - Portugal

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

 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',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6888',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6889',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6889',amount)),0)) S,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'69',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'69',amount)),0)) V,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'86',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'86',amount)),0)) Z,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'711',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'711',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7171',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7171',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7181',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7181',amount)),0)) AA,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'712',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'712',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'713',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'713',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7172',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7172',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7182',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7182',amount)),0)) AB,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'72',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'72',amount)),0)) AC,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'75',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'75',amount)),0)) AG,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'73',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'73',amount)),0)) AH,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'74',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'74',amount)),0)) AI,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'76',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'76',amount)),0)) AJ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'77',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'77',amount)),0)) AY,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'782',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'782',amount)),0)) AM,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'784',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'784',amount)),0)) AN,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78122',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78122',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78152',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78152',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78162',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78162',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7832',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7832',amount)),0)) AO,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78121',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78121',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78151',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78151',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78161',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78161',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7831',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7831',amount)),0))+
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7834',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7834',amount)),0)) AP,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78112',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78112',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78132',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78132',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78142',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78142',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78182',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78182',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7852',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7852',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7862',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7862',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7872',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7872',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7882',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7882',amount)),0)) AQ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78111',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78111',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78131',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78131',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78141',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78141',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78181',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78181',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7851',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7851',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7861',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7861',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7871',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7871',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7881',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7881',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7883',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7883',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7884',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7884',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7885',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7885',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7886',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7886',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7887',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7887',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7888',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7888',amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7889',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7889',amount)),0)) AR,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'79',amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'79',amount)),0)) Au,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'612',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'612',prior_amount)),0)) PA,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'616',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'616',prior_amount)),0)) PB,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'62',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'62',prior_amount)),0)) PD,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'641',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'641',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'642',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'642',prior_amount)),0)) PE,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'643',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'643',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'644',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'644',prior_amount)),0)) PF,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'645',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'645',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'646',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'646',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'647',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'647',prior_amount)),0)) + 
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'648',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'648',prior_amount)),0)) PG,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'662',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'662',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'663',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'663',prior_amount)),0)) PI0,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'666',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'666',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'667',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'667',prior_amount)),0)) PI1,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'67',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'67',prior_amount)),0)) PJ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'63',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'63',prior_amount)),0)) PL,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'65',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'65',prior_amount)),0)) PM,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'682',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'682',prior_amount)),0)) PP,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'683',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'683',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'684',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'684',prior_amount)),0)) PQ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68112',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68112',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68122',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68122',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68132',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68132',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68142',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68142',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68152',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68152',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68162',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68162',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68182',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68182',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6852',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6852',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6862',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6862',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6872',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6872',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6882',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6882',prior_amount)),0)) PR,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68111',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68111',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68121',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68121',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68131',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68131',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68141',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68141',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68151',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68151',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68161',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68161',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'68181',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'68181',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6851',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6851',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6861',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6861',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6871',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6971',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6881',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6881',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6883',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6883',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6884',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6884',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6885',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6885',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6886',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6886',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6887',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6887',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6888',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6888',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'6889',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'6889',prior_amount)),0)) PS,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'69',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'69',prior_amount)),0)) PV,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'86',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'86',prior_amount)),0)) PZ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'711',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'711',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7171',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7171',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7181',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7181',prior_amount)),0)) PAA,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'712',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'712',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'713',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'713',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7172',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7172',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7182',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7182',prior_amount)),0)) PAB,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'72',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'72',prior_amount)),0)) PAC,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'75',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'75',prior_amount)),0)) PAG,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'73',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'73',prior_amount)),0)) PAH,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'74',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'74',prior_amount)),0)) PAI,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'76',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'76',prior_amount)),0)) PAJ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'77',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'77',prior_amount)),0)) PAY,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'782',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'782',prior_amount)),0)) PAM,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'784',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'784',prior_amount)),0)) PAN,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78122',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78122',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78152',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78152',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78162',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78162',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7832',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7832',prior_amount)),0)) PAO,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78121',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78121',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78151',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78151',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78161',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78161',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7831',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7831',prior_amount)),0))+
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7834',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7834',prior_amount)),0)) PAP,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78112',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78112',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78132',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78132',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78142',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78142',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78182',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78182',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7852',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7852',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7862',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7862',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7872',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7872',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7882',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7882',prior_amount)),0)) PAQ,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78111',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78111',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78131',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78131',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78141',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78141',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'78181',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'78181',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7851',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7851',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7861',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7861',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7871',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7871',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7881',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7881',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7884',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7884',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7885',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7885',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7886',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7886',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7887',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7887',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7888',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7888',prior_amount)),0)) +
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'7889',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'7889',prior_amount)),0)) PAR,
decode(:P_CURR_UNIT,'T',nvl(max(decode(parent_value,'79',prior_amount)),0)/1000,
                 'E',nvl(max(decode(parent_value,'79',prior_amount)),0)) PAU
FROM JE_PROFIT_LOSS_RPT_GT
Parameter Name SQL text Validation
Ledger Name
 
LOV Oracle
Balancing Account Segment
 
Char
Accounting Period From
 
LOV Oracle
Accounting Period To
 
LOV Oracle
IRC Tax Amount
 
Number
Unit Of Currency
 
LOV Oracle
Download
 
Blitz Report™

Blitz Report™ provides multiple benefits: