ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4708951A9E05362FB09050512 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 Y JG JEPTGLPL AR JG تقرير الربح والخسارة للأستاذ العام في JE - البرتغال Imported from BI Publisher Application: المحليات الأقليمية Source: تقرير الربح والخسارة للأستاذ العام في JE - البرتغال Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG D JG JE - RW Gewinn und Verlust - Portugal Imported from BI Publisher Description: JE-Auswertung "RW Gewinn und Verlust" - Portugal Application: Regionale Lokalisierungen Source: JE - RW Gewinn und Verlust - Portugal Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG E JG Portugal - JE GL: Informe sobre Beneficios y Pérdidas Imported from BI Publisher Description: Portugal - JE GL: Informe sobre beneficios y pérdidas Application: Localizaciones Regionales Source: Portugal - JE GL: Informe sobre Beneficios y Pérdidas Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG F JG JE - Etat des résultats d'exploitation GL - Portugal Imported from BI Publisher Application: Regional Localizations Source: JE - Etat des résultats d'exploitation GL - Portugal Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG I JG Portogallo - rapporto JE: profitti e perdite GL Imported from BI Publisher Application: Regional Localizations Source: Portogallo - rapporto JE: profitti e perdite GL Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG RU JG Отчет о прибылях и убытках ГК JE - Португалия Imported from BI Publisher Application: Местные версии Source: Отчет о прибылях и убытках ГК JE - Португалия Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG S JG JE GL Resultatrapport - Portugal Imported from BI Publisher Application: Regional Localizations Source: JE GL Resultatrapport - Portugal Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG TR JG JE GL Kar ve Zarar Raporu - Portekiz Imported from BI Publisher Application: Bölgesel Yerelleştirmeler Source: JE GL Kar ve Zarar Raporu - Portekiz Short Name: JEPTGLPL DB package: JE_PT_GL_PFTLS_PKG US JG JE GL Profit and Loss Report - Portugal 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 BI Publisher :gc_access_where :gc_bal_seg_filter :gc_debug_var :gc_natural_account :gd_end_date :gd_prior_end_date :gd_prior_start_date :gd_start_date :gn_cur_amt :gn_cur_tax_amt :gn_curr_year :gn_flex_value_set_id :gn_iteration :gn_pre_amt :gn_pre_tax_amt :gn_prev_year :p_access_set_id :p_bal_seg_value :p_balance_segment :p_coa_id :p_curr_unit :p_curr_unit_value :p_custom_parameter_1 :p_custom_parameter_2 :p_end_period :p_irc_tax :p_ledger :p_ledger_id :p_natural_account :p_start_period 1 -60 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة صلاحيات الوصول معرف مجموعة صلاحيات الوصول D ZugriffsSet-Kennung ZugriffsSet-Kennung E Id Juego de Accesos Identificador de juego de accesos F ID jeu d'accès ID jeu d'accès I Id serie di accesso Id serie di accesso RU Идентификатор набора доступа Идентификатор набора доступа S Åtkomstuppsättnings-id Åtkomstuppsättnings-id TR Erişim Kümesi No Erişim Kümesi No US Access Set Id Access Set Id 2 -50 :p_coa_id Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف دليل الحسابات معرف دليل الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Identificador de plan de cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id piano dei conti RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts Id Chart of Accounts Id 3 -40 :p_ledger_id Number SELECT target_ledger_id FROM GL_LEDGER_RELATIONSHIPS WHERE application_id=101 AND source_ledger_id=target_ledger_id AND target_ledger_name = :$flex$.ledger_name Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id 4 -30 :p_natural_account Char SELECT application_column_name FROM fnd_segment_attribute_values WHERE application_id = 101 AND attribute_value = 'Y' AND segment_attribute_type = 'GL_ACCOUNT' AND id_flex_code = 'GL#' AND id_flex_num = :$flex$.chart_of_accounts_id Y AR الحساب الطبيعي الحساب الطبيعي D Natürliches Konto Natürliches Konto E Cuenta por Naturaleza Cuenta por naturaleza F Compte naturel Compte naturel I Conto di origine Conto di origine RU Корреспондирующий счет Корреспондирующий счет S Kostnadsslag Kostnadsslag TR Doğal Hesap Doğal Hesap US Natural Account Natural Account 5 -20 :p_balance_segment Char SELECT application_column_name FROM fnd_segment_attribute_values WHERE application_id = 101 AND attribute_value = 'Y' AND segment_attribute_type = 'GL_BALANCING' AND id_flex_code = 'GL#' AND id_flex_num = :$flex$.chart_of_accounts_id Y AR مقطع الترصيد مقطع الترصيد D Buchungskreis Buchungskreis E Segmento de Balance Segmento de balance F Segment d'équilibrage Segment d'équilibrage I Segmento di quadratura Segmento di quadratura RU Балансирующий сегмент Балансирующий сегмент S Balanssegment Balanssegment TR Dengeleme Segmenti Dengeleme Segmenti US Balancing Segment Balancing Segment 6 -10 :p_curr_unit_value Char SELECT meaning FROM fnd_lookup_values WHERE lookup_type = 'JE_PT_PL_CURR_UNIT' AND language = USERENV('LANG') AND lookup_code = :$flex$.unit_of_currency AR قيمة وحدة العملة قيمة وحدة العملة D Wert Währungseinheit Wert Währungseinheit E Valor de Unidad de Divisa Valor de unidad de divisa F Valeur de l'unité monétaire Valeur de l'unité monétaire I Valore unità della divisa Valore unità della divisa RU Значение единицы валюты Значение единицы валюты S Värde på valutaenhet Värde på valutaenhet TR Para birimi değeri Para birimi değeri US Unit of currency value Unit of currency value 7 10 :p_ledger LOV Oracle JGZZ_SRS_LEDGER_NO_SET Y select nvl(rel.target_ledger_name,led.name) id, nvl(rel.target_ledger_name,led.name) value, led.description description from gl_access_set_ledgers ac,gl_ledgers_public_v led,gl_ledger_relationships rel where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and rel.source_ledger_id(+)=ac.ledger_id and rel.target_ledger_id(+)=ac.ledger_id and rel.application_id(+)=101 order by nvl(rel.target_ledger_name,led.name) SELECT name FROM gl_ledgers WHERE ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'),'R') Y AR اسم دفتر الأستاذ اسم دفتر الأستاذ D Buchbezeichnung Buchbezeichnung E Nombre de Libro Mayor Nombre de libro mayor F Nom du livre Nom du livre I Nome libro contabile Nome del libro contabile RU Имя книги Имя книги S Huvudbok Huvudbok TR Defter Adı Defter Adı US Ledger Name Ledger Name 8 20 :p_bal_seg_value Char Y AR مقطع حساب الرصيد مقطع حساب الرصيد D Ausgleichskontensegment Ausgleichskontensegment E Segmento de Balance de Cuenta Segmento de balance de cuenta F Segment de compte d'équilibrage Segment de compte d'équilibrage I Segmento conto di quadratura Segmento del conto di quadratura RU Сегмент балансирующего счета Сегмент балансирующего счета S Balanskontosegment Balanskontosegment TR Dengeleme Hesabı Segmenti Dengeleme Hesabı Segmenti US Balancing Account Segment Balancing Account Segment 9 30 :p_start_period LOV Oracle JE_PT_PL_PERIOD_START Y select per.period_name id, per.period_name value, null description from gl_periods per,gl_access_sets gas where per.period_set_name=gas.period_set_name and per.period_type=gas.accounted_period_type and gas.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and exists (select 'Has Data' from gl_access_set_ledgers led2,gl_ledger_set_assignments ls,gl_period_statuses ps where led2.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and ls.ledger_set_id (+)=led2.ledger_id and ps.application_id=101 and ps.ledger_id=nvl(:$flex$.jgzz_srs_ledger_name:null,nvl(ls.ledger_id,led2.ledger_id)) and ps.closing_status in ('O','C','P') and ps.period_name=per.period_name) order by per.period_num Y AR الفترة المحاسبية من الفترة المحاسبية من D Von Buchungsperiode Von Buchungsperiode E De Período Contable De período contable F Période comptable - De Période comptable - De I Periodo contabile - Da Periodo contabile - Da RU Учетный период с Учетный период с S Redovisningsperiod från Redovisningsperiod från TR Muhasebe Dönemi, İlk Muhasebe Dönemi, İlk US Accounting Period From Accounting Period From 10 40 :p_end_period LOV Oracle JE_PT_PL_PERIOD_END Y select per.period_name id, per.period_name value, null description from gl_periods per,gl_access_sets gas where per.period_set_name=gas.period_set_name and per.period_type=gas.accounted_period_type and gas.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and exists (select 'has data' from gl_access_set_ledgers led2,gl_ledger_set_assignments ls,gl_period_statuses ps where led2.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and ls.ledger_set_id (+)=led2.ledger_id and ps.application_id=101 and ps.ledger_id=nvl(:$flex$.jgzz_srs_ledger_name:null,nvl(ls.ledger_id,led2.ledger_id)) and ps.closing_status in ('O','C','P') and ps.period_name=per.period_name) and per.period_year= (select per1.period_year from gl_periods per1 where per1.period_set_name=per.period_set_name and per1.period_type=per.period_type and per1.period_name=:$flex$.je_pt_pl_period_start) and per.period_name>= (select per1.period_name from gl_periods per1 where per1.period_set_name=per.period_set_name and per1.period_type=per.period_type and per1.period_name=:$flex$.je_pt_pl_period_start) order by per.period_num Y AR الفترة المحاسبية إلى الفترة المحاسبية إلى D Bis Buchungsperiode Bis Buchungsperiode E A Período Contable A período contable F Période comptable - A Période comptable - A I Periodo contabile - A Periodo contabile - A RU Учетный период по Учетный период по S Redovisningsperiod till Redovisningsperiod till TR Muhasebe Dönemi, Son Muhasebe Dönemi, Son US Accounting Period To Accounting Period To 11 50 :p_irc_tax Number AR مبلغ ضريبة IRC مبلغ ضريبة IRC D IRC Steuerbetrag IRC Steuerbetrag E IRC: Importe de Impuesto IRC: Importe de impuesto F IRC - Montant de taxe IRC - Montant de taxe I Importo imposta IRC Importo dell'imposta IRC RU Сумма налога IRC Сумма налога IRC S IRC: Skattebelopp IRC: Skattebelopp TR IRC Vergi Miktarı IRC Vergi Miktarı US IRC Tax Amount IRC Tax Amount 12 60 :p_curr_unit LOV Oracle JE_PT_PL_UNIT_OF_CURR Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JE_PT_PL_CURR_UNIT' and language=userenv('LANG') order by value,description SELECT meaning FROM fnd_lookup_values WHERE lookup_type = 'JE_PT_PL_CURR_UNIT' AND language = USERENV('LANG') AND lookup_code = 'E' Y AR وحدة العملة وحدة العملة D Währungseinheit Währungseinheit E Unidad de Divisa Unidad de divisa F Unité monétaire Unité monétaire I Unità della divisa Unità della divisa RU Единица валюты Единица валюты S Valutaenhet Valutaenhet TR Para Birimi Para Birimi US Unit Of Currency Unit Of Currency :$flex$.chart_of_accounts_id Chart of Accounts Id Balancing Segment :$flex$.chart_of_accounts_id Chart of Accounts Id Natural Account :$flex$.je_pt_pl_period_start Accounting Period From Accounting Period To :$flex$.ledger_name Ledger Name Ledger Id :$flex$.unit_of_currency Unit Of Currency Unit of currency value