ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CA53C651BA82C8D8E0530100007FCCB4 select x.company_name company_name, x.ledger ledger, x.book book, x.currency currency, x.balancing_segment balancing_segment, x.reval_reserve_account reval_reserve_account, x.cost_center cost_center, x.asset_number asset_number, x.asset_description asset_description, x.begin_amount beginning_balance, x.addition_amount additions, x.depreciation_amount amortization, x.adjustment_amount revaluations, x.retirement_amount retirements, x.reclass_amount reclassifications, x.transfer_amount transfers, x.end_amount ending_balance, x.out_of_balance_flag out_of_balance_flag, case nvl(x.end_amount,0) - (nvl(x.begin_amount,0) + nvl(x.addition_amount,0) + nvl(x.depreciation_amount,0) + nvl(x.reclass_amount,0) - nvl(x.retirement_amount,0) + nvl(x.adjustment_amount,0) + nvl(x.transfer_amount,0)) when 0 then to_number(null) else nvl(x.end_amount,0) - (nvl(x.begin_amount,0) + nvl(x.addition_amount,0) + nvl(x.depreciation_amount,0) + nvl(x.reclass_amount,0) - nvl(x.retirement_amount,0) + nvl(x.adjustment_amount,0) + nvl(x.transfer_amount,0)) end out_of_balance_amount, -- case x.reval_tax_flag when 'R' then 'Revaluation Adjustment' when 'T' then 'Tax Adjustment' when 'B' then 'Revaluation and Tax Adjustments' end adjustment_type, -- case fa_fasrsves_xmlp_pkg.reval_tax_flagformula ( sum(x.revaluation_amount) over (partition by x.book,x.balancing_segment,x.reval_reserve_account,x.cost_center) , sum(x.tax_amount) over (partition by x.book,x.balancing_segment,x.reval_reserve_account,x.cost_center) ) when 'R' then 'Revaluation Adjustment' when 'T' then 'Tax Adjustment' when 'B' then 'Revaluation and Tax Adjustments' end cost_ctr_adj_type, x.company_name || ': ' || x.book || ' (' || x.currency || ')' comp_book_curr_label from ( select fsc.company_name, gl.name ledger, :p_book book, gl.currency_code currency, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'GL_BALANCING','Y','VALUE') balancing_segment, nvl2(gcc_aj.code_combination_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg','SQLGL','GL#',gcc_aj.chart_of_accounts_id,null,gcc_aj.code_combination_id,'GL_ACCOUNT','Y','VALUE'), fbrg.category_books_account ) reval_reserve_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'FA_COST_CTR','Y','VALUE') cost_center, fa.asset_number, fa.description asset_description, nvl(round(sum(decode(fbrg.source_type_code, 'BEGIN' , nvl(fbrg.amount,0) , null)), fc.precision),0) begin_amount, round(sum(decode(fbrg.source_type_code, 'ADDITION' , nvl(fbrg.amount,0) , null)), fc.precision) addition_amount, round(sum(decode(fbrg.source_type_code, 'DEPRECIATION', nvl(fbrg.amount,0) , null)), fc.precision) depreciation_amount, round(sum(decode(fbrg.source_type_code, 'REVALUATION' , nvl(fbrg.amount,0) , null)), fc.precision) revaluation_amount, round(sum(decode(fbrg.source_type_code, 'TAX' , nvl(fbrg.amount,0) , null)), fc.precision) tax_amount, round(sum(decode(fbrg.source_type_code, 'RETIREMENT' , -nvl(fbrg.amount,0), null)), fc.precision) retirement_amount, round(sum(decode(fbrg.source_type_code, 'RECLASS' , nvl(fbrg.amount,0) , null)), fc.precision) reclass_amount, round(sum(decode(fbrg.source_type_code, 'TRANSFER' , nvl(fbrg.amount,0) , null)), fc.precision) transfer_amount, nvl(round(sum(decode(fbrg.source_type_code, 'END' , nvl(fbrg.amount,0) , null)), fc.precision),0) end_amount, -- nvl(round(sum(decode(fbrg.source_type_code, 'TAX' , nvl(fbrg.amount,0),null)), fc.precision),0) + nvl(round(sum(decode(fbrg.source_type_code, 'REVALUATION' , nvl(fbrg.amount,0),null)), fc.precision),0) adjustment_amount, -- fa_fasrsves_xmlp_pkg.out_of_balanceformula ( nvl(round(sum(decode(fbrg.source_type_code, 'BEGIN' , nvl(fbrg.amount,0) , null)), fc.precision),0) , round(sum(decode(fbrg.source_type_code, 'ADDITION' , nvl(fbrg.amount,0) , null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'DEPRECIATION', nvl(fbrg.amount,0) , null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'RECLASS' , nvl(fbrg.amount,0) , null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'RETIREMENT' , - nvl(fbrg.amount,0), null)), fc.precision) , nvl(round(sum(decode(fbrg.source_type_code, 'TAX' , nvl(fbrg.amount,0),null)), fc.precision),0) + nvl(round(sum(decode(fbrg.source_type_code, 'REVALUATION' , nvl(fbrg.amount,0),null)), fc.precision),0) , round(sum(decode(fbrg.source_type_code, 'TRANSFER' , nvl(fbrg.amount,0) , null)), fc.precision) , nvl(round(sum(decode(fbrg.source_type_code, 'END' , nvl(fbrg.amount,0) , null)), fc.precision),0) ) out_of_balance_flag, fa_fasrsves_xmlp_pkg.reval_tax_flagformula ( round(sum(decode(fbrg.source_type_code, 'REVALUATION', nvl(fbrg.amount,0), null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'TAX' , nvl(fbrg.amount,0), null)), fc.precision) ) reval_tax_flag from fa_system_controls fsc, gl_ledgers gl, fnd_currencies fc, fa_balances_report_gt fbrg, fa_additions fa, gl_code_combinations gcc_dh, gl_code_combinations gcc_aj where gl.ledger_id = :p_ca_set_of_books_id and fc.currency_code = gl.currency_code and fa.asset_id = fbrg.asset_id and gcc_dh.code_combination_id = fbrg.distribution_ccid and gcc_aj.code_combination_id (+) = fbrg.adjustment_ccid and 1=1 group by fsc.company_name, gl.name, :p_book, gl.currency_code, fc.precision, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'GL_BALANCING','Y','VALUE'), nvl2(gcc_aj.code_combination_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg','SQLGL','GL#',gcc_aj.chart_of_accounts_id,null,gcc_aj.code_combination_id,'GL_ACCOUNT','Y','VALUE'), fbrg.category_books_account ), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'FA_COST_CTR','Y','VALUE'), fa.asset_number, fa.description ) x order by x.company_name, x.ledger, x.book, x.balancing_segment, x.reval_reserve_account, x.cost_center, x.asset_number Y #,##0.00;[Red]-#,##0.00 XXEN_FA_FAS_XMLP US FA Revaluation Reserve Revaluation Reserve Summary/Detail Report Equivalent to Oracle Standard Reports: Revaluation Reserve Summary Report Revaluation Reserve Detail Report DB package: XXEN_FA_FAS_XMLP Enginatics R12 only 1=1 :p_adj_mode :p_book :p_book1 :p_book2 :p_book3 :p_book4 :p_ca_set_of_books_id :p_calendar_type :p_conc_request_id :p_currency :p_fas_code :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :p_period_count :p_period_name :p_report_type :p_run_id 1 -20 :p_fas_code Char FASRSVES F Code FAS US FAS Code 2 -10 :p_report_type Char REVAL RESERVE Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de Informe F Type de rapport Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type ZHS 报表类型 报表类型 3 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code select case when xrpv.parameter_type='LOV Oracle' and xrrpv.value not like '<multiple_values>%' then xxen_report.id_to_value(xrpv.parameter_id,xrrpv.value) else xrrpv.value end value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'FA Revaluation Reserve' and xrpv.parameter_name = 'Book' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id Y AR الدفتر نوع الدفتر D AfA-Buch Art AfA-Buch E Libro Tipo de Libro F Livre Type de livre I Registro Tipo di registro JA 台帳 台帳タイプ KO 장부 장부 유형 PTB Livro Tipo de Livro RU Книга Тип книги S Bok Boktyp TR Defter Defter Tipi US Book Book Type ZHS 帐簿 账簿类型 4 20 :p_ca_set_of_books_id LOV Oracle FA_CA_SOB_CURRENCY Y select gsob.set_of_books_id id, gsob.currency_code value, gsob.name description from gl_sets_of_books gsob where gsob.set_of_books_id in ( select set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type union all select set_of_books_id from fa_mc_book_controls where book_type_code=:$flex$.fa_book_type) order by gsob.currency_code select set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type Y AR عملة دفاتر الحسابات عملة دفاتر الحسابات D Währung Buchungsstruktur Währung Buchungsstruktur E Divisa de Juego de Libros Divisa de Juego de Libros F Ensemble de livres Monnaie Devise de l'entité comptable I Divisa set of books Divisa set of books JA 会計帳簿通貨 会計帳簿通貨 KO 회계장부 통화 회계장부 통화 PTB Moeda do Conjunto de Livros Moeda do Conjunto de Livros RU Валюта набора книг Валюта набора книг S Räkenskapsvaluta Räkenskapsvaluta TR Yasal Muhasebe Birimi Para Birimi Yasal Muhasebe Birimi Para Birimi US Set of Books Currency Set of Books Currency ZHS 帐套币种 帐套币种 5 30 :p_period1 LOV Oracle FA_PERIOD_NAME_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter select period_name from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter= (select max(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type and dp2.period_close_date is not null) Y AR من الفترة فترة البداية D Von Periode Von Periode E De Período Período de Inicio F De la période Période de début I Periodo - Da Periodo iniziale JA 期間:自 期間:自 KO 기간: 부터 시작 기간 PTB Período - De Período Inicial RU Начальный период Начальный период S Från period Startperiod TR İlk Dönem Başlangıç Dönemi US From Period Start Period ZHS 自期间 起始期间 6 40 :p_period2 LOV Oracle FA_PERIOD_TO_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>=(select period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_book_type and period_name= :$flex$.fa_period_name_closed) order by period_counter :$flex$.fa_period_name_closed Y AR إلى الفترة فترة النهاية D Bis Periode Bis Periode E A Período Período de Finalización F À la période Fin de période I Periodo - A Periodo finale JA 期間:至 期間:至 KO 기간: 까지 종료 기간 PTB Período - Até Per. Final RU Конечный период Конечный период S Till period Slutperiod TR Son Dönem Bitiş Dönemi US To Period End Period ZHS 至期间 终止期间 :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book Set of Books Currency :$flex$.fa_book_type Book To Period :$flex$.fa_period_name_closed From Period To Period Pivot: Default Template Revaluation Reserve Summary (Pivot) with Revaluation Reserve Details by Asset SYSADMIN 11 ADDITIONS 20 ADJUSTMENT_TYPE 12 AMORTIZATION 9 ASSET_DESCRIPTION 8 ASSET_NUMBER 5 BALANCING_SEGMENT 4 10 BEGINNING_BALANCE 3 BOOK 3 1 COMPANY_NAME 1 22 COMP_BOOK_CURR_LABEL 7 COST_CENTER 6 21 COST_CTR_ADJ_TYPE 4 CURRENCY 17 ENDING_BALANCE 2 LEDGER 2 19 OUT_OF_BALANCE_AMOUNT 18 OUT_OF_BALANCE_FLAG 15 RECLASSIFICATIONS 14 RETIREMENTS 13 REVALUATIONS 6 REVAL_RESERVE_ACCOUNT 5 16 TRANSFERS ADDITIONS VALUE 2 SUM AMORTIZATION VALUE 3 SUM BALANCING_SEGMENT ROW 2 BEGINNING_BALANCE VALUE 1 SUM COMP_BOOK_CURR_LABEL ROW 1 COST_CENTER ROW 4 ENDING_BALANCE VALUE 8 SUM OUT_OF_BALANCE_AMOUNT VALUE 9 SUM RECLASSIFICATIONS VALUE 6 SUM RETIREMENTS VALUE 5 SUM REVALUATIONS VALUE 4 SUM REVAL_RESERVE_ACCOUNT ROW 3 TRANSFERS VALUE 7 SUM S Site Reval Reserve Detail Revaluation Reserve Detail Report by Asset SYSADMIN 11 ADDITIONS 20 ADJUSTMENT_TYPE 12 AMORTIZATION 9 ASSET_DESCRIPTION 8 ASSET_NUMBER 7 5 BALANCING_SEGMENT 4 10 BEGINNING_BALANCE 3 BOOK 3 1 COMPANY_NAME 1 7 COST_CENTER 6 4 CURRENCY 17 ENDING_BALANCE 2 LEDGER 2 19 OUT_OF_BALANCE_AMOUNT 18 OUT_OF_BALANCE_FLAG 15 RECLASSIFICATIONS 14 RETIREMENTS 13 REVALUATIONS 6 REVAL_RESERVE_ACCOUNT 5 16 TRANSFERS S Site Reval Reserve Summary Revaluation Reserve Summary Report by Balancing Segment, Reval Reserve Account, and Cost Center SYSADMIN 9 ADDITIONS SUM 10 AMORTIZATION SUM 5 BALANCING_SEGMENT 4 8 BEGINNING_BALANCE SUM 3 BOOK 3 1 COMPANY_NAME 1 7 COST_CENTER 6 18 COST_CTR_ADJ_TYPE MAX 4 CURRENCY 15 ENDING_BALANCE SUM 2 LEDGER 2 17 OUT_OF_BALANCE_AMOUNT SUM 16 OUT_OF_BALANCE_FLAG MAX 13 RECLASSIFICATIONS SUM 12 RETIREMENTS SUM 11 REVALUATIONS SUM 6 REVAL_RESERVE_ACCOUNT 5 14 TRANSFERS SUM S Site Pivot: Default Template