ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 41D7A49F9BCACFA9E06362FB09058781 insert /*+ ignore_row_on_dupkey_index(xxfa_asset_cost,xxfa_asset_cost_u1) */ into xxfa_asset_cost select x.company_name, x.ledger, x.book book, x.currency currency, x.balancing_segment balancing_segment, x.asset_account asset_account, x.cost_center cost_center, x.asset_number asset_number, x.asset_description asset_description, -- cost sum(x.begin_amount) beginning_balance, sum(x.addition_amount) additions, sum(x.adjustment_amount) adjustments, sum(x.retirement_amount) retirements, sum(x.revaluation_amount) revaluations, sum(x.reclass_amount) reclassifications, sum(x.transfer_amount) transfers, sum(x.end_amount) ending_balance, sum(case nvl(x.end_amount,0) - (nvl(x.begin_amount,0) + nvl(x.addition_amount,0) + nvl(x.revaluation_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.revaluation_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, max(x.out_of_balance_flag) out_of_balance_flag, -- reserve &lp_reserve_cols1 -- x.company_name || ': ' || x.book || ' (' || x.currency || ')' comp_book_curr_label from ( select /*+ push_pred(fah) */ 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#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,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 ) asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,gcc_dh.code_combination_id),'FA_COST_CTR','Y','VALUE') cost_center, fa.asset_id, fa.asset_number, fa.description asset_description, -- cost 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, 'ADJUSTMENT', nvl(fbrg.amount,0) , null)), fc.precision) adjustment_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,'REVALUATION', nvl(fbrg.amount,0) , null)), fc.precision) revaluation_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, fa_fascosts_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,'REVALUATION', 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) , round(sum(decode(fbrg.source_type_code, 'ADJUSTMENT', nvl(fbrg.amount,0) ,null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'TRANSFER', nvl(fbrg.amount,0) ,null)), fc.precision) , 0 , nvl(round(sum(decode(fbrg.source_type_code, 'END', nvl(fbrg.amount,0) ,null)), fc.precision),0) ) out_of_balance_flag, -- reserve fah.deprn_reserve_acct reserve_account, to_number(null) reserve_begin_amount, to_number(null) reserve_addition_amount, to_number(null) reserve_depreciation_amount, to_number(null) reserve_revaluation_amount, to_number(null) reserve_tax_amount, to_number(null) reserve_retirement_amount, to_number(null) reserve_reclass_amount, to_number(null) reserve_transfer_amount, to_number(null) reserve_end_amount, to_number(null) reserve_adjustment_amount, null reserve_out_of_balance_flag, null reserve_reval_tax_flag from fa_system_controls fsc, gl_ledgers gl, fnd_currencies fc, fa_balances_report_gt fbrg, (select fah.asset_id, fcb.book_type_code, fcb.asset_cost_acct, max(fcb.deprn_reserve_acct) deprn_reserve_acct from fa_asset_history fah, fa_category_books fcb where fah.category_id = fcb.category_id group by fah.asset_id, fcb.book_type_code, fcb.asset_cost_acct having count(distinct fcb.deprn_reserve_acct) = 1 ) fah, fa_additions fa, gl_code_combinations gcc_dh, gl_code_combinations gcc_aj where gl.ledger_id = :p_ca_set_of_books_id and gl.currency_code = fc.currency_code and fbrg.asset_id > 0 and decode(:p_show_reserve,'Y',fbrg.asset_id) = fah.asset_id (+) and decode(:p_show_reserve,'Y',:p_book) = fah.book_type_code (+) and 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 ) = fah.asset_cost_acct (+) and fbrg.asset_id = fa.asset_id and fbrg.distribution_ccid = gcc_dh.code_combination_id (+) and fbrg.adjustment_ccid = gcc_aj.code_combination_id (+) 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#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,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#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,gcc_dh.code_combination_id),'FA_COST_CTR','Y','VALUE'), fa.asset_id, fa.asset_number, fa.description, fah.deprn_reserve_acct union all select /*+ push_pred(fah) */ 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#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,gcc_dh.code_combination_id),'GL_BALANCING','Y','VALUE') balancing_segment, fah.asset_cost_acct asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,gcc_dh.code_combination_id),'FA_COST_CTR','Y','VALUE') cost_center, fa.asset_id, fa.asset_number, fa.description asset_description, -- cost to_number(null) begin_amount, to_number(null) addition_amount, to_number(null) adjustment_amount, to_number(null) retirement_amount, to_number(null) revaluation_amount, to_number(null) reclass_amount, to_number(null) transfer_amount, to_number(null) end_amount, null out_of_balance_flag, -- reserve 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 ) reserve_account, nvl(round(sum(decode(fbrg.source_type_code, 'BEGIN', nvl(fbrg.amount,0) , null)), fc.precision),0) reserve_begin_amount, round(sum(decode(fbrg.source_type_code, 'ADDITION', nvl(fbrg.amount,0) , null)), fc.precision) reserve_addition_amount, round(sum(decode(fbrg.source_type_code,'DEPRECIATION', nvl(fbrg.amount,0) , null)), fc.precision) reserve_depreciation_amount, round(sum(decode(fbrg.source_type_code, 'REVALUATION', nvl(fbrg.amount,0) , null)), fc.precision) reserve_revaluation_amount, round(sum(decode(fbrg.source_type_code, 'TAX', nvl(fbrg.amount,0) , null)), fc.precision) reserve_tax_amount, round(sum(decode(fbrg.source_type_code, 'RETIREMENT', -nvl(fbrg.amount,0), null)), fc.precision) reserve_retirement_amount, round(sum(decode(fbrg.source_type_code, 'RECLASS', nvl(fbrg.amount,0) , null)), fc.precision) reserve_reclass_amount, round(sum(decode(fbrg.source_type_code, 'TRANSFER', nvl(fbrg.amount,0) , null)), fc.precision) reserve_transfer_amount, nvl(round(sum(decode(fbrg.source_type_code, 'END', nvl(fbrg.amount,0) , null)), fc.precision),0) reserve_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) reserve_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) ) reserve_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) ) reserve_reval_tax_flag from fa_system_controls fsc, gl_ledgers gl, fnd_currencies fc, fa_balances_report_gt fbrg, (select fah.asset_id, fcb.book_type_code, fcb.deprn_reserve_acct, max(fcb.asset_cost_acct) asset_cost_acct from fa_asset_history fah, fa_category_books fcb where fah.category_id = fcb.category_id group by fah.asset_id, fcb.book_type_code, fcb.deprn_reserve_acct having count(distinct fcb.asset_cost_acct) = 1 ) fah, fa_additions fa, gl_code_combinations gcc_dh, gl_code_combinations gcc_aj where :p_show_reserve = 'Y' and gl.ledger_id = :p_ca_set_of_books_id and gl.currency_code = fc.currency_code and fbrg.asset_id < 0 and -fbrg.asset_id = fah.asset_id (+) and 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 ) = fah.deprn_reserve_acct (+) and :p_book = fah.book_type_code (+) and -fbrg.asset_id = fa.asset_id and fbrg.distribution_ccid = gcc_dh.code_combination_id (+) and fbrg.adjustment_ccid = gcc_aj.code_combination_id (+) 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#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,gcc_dh.code_combination_id),'GL_BALANCING','Y','VALUE'), fah.asset_cost_acct, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',nvl(gcc_dh.chart_of_accounts_id,gcc_dh.chart_of_accounts_id),null,nvl(gcc_dh.code_combination_id,gcc_dh.code_combination_id),'FA_COST_CTR','Y','VALUE'), fa.asset_id, fa.asset_number, fa.description, 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 ) ) x group by x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, x.asset_account, x.reserve_account, x.cost_center, x.asset_number, x.asset_description order by x.company_name, x.ledger, x.book, x.balancing_segment, x.asset_account, x.reserve_account, x.cost_center, x.asset_number Y S #,##0.00;[Red]-#,##0.00 CA53C651BA81C8D8E0530100007FCCB4 XXEN_FA_FAS_XMLP US XXEUCL FA Asset Cost Insert Asset Costs Summary/Detail Report Equivalent to Oracle Standard Reports: Cost Summary Report Cost Detail Report DB package: XXEN_FA_FAS_XMLP &lp_reserve_cols1 1=1 :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 :p_show_reserve 1 -20 :p_fas_code Char FASCOSTS F Code FAS US FAS Code 2 -10 :p_report_type Char COST 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 Asset Cost' 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 AfA-Buch E Libro Nombre del Libro F Livre Nom du livre I Registro Nome del registro JA 台帳 台帳名 KO 장부 장부명 PTB Livro Nome do Livro RU Книга Имя книги S Bok Boknamn TR Defter Defter Adı US Book Book Name 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 fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=:$flex$.fa_book_type and fdp.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 Nombre de Período de Inicio F De la période Nom de la période de début I Periodo - Da Nome del periodo iniziale JA 期間:自 期間名:自 KO 기간: 부터 시작 기간명 PTB Período - De Nome do Período Inicial RU Начальный период Имя начального периода S Från period Namn på startperiod TR İlk Dönem Başlangıç Dönemi Adı US From Period Start Period Name 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 Nombre del Período de Finalización F À la période Nom de la période de fin I Periodo - A Nome del periodo finale JA 期間:至 期間名:至 KO 기간: 까지 종료 기간명 PTB Período - Até Nome do Período Final RU Конечный период Имя конечного периода S Till period Slutperiod TR Son Dönem Son Dönem Adı US To Period End Period Name ZHS 至期间 终止期间名称 7 50 :p_show_reserve LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Depreciation Reserve 8 &lp_reserve_cols1 x.reserve_account reserve_account, sum(x.reserve_begin_amount) reserve_beginning_balance, sum(x.reserve_addition_amount) reserve_additions, sum(x.reserve_depreciation_amount) reserve_depreciation, sum(x.reserve_adjustment_amount) reserve_adjustments, sum(x.reserve_retirement_amount) reserve_retirements, sum(x.reserve_reclass_amount) reserve_reclassifications, sum(x.reserve_transfer_amount) reserve_transfers, sum(x.reserve_end_amount) reserve_ending_balance, sum(case nvl(x.reserve_end_amount,0) - (nvl(x.reserve_begin_amount,0) + nvl(x.reserve_addition_amount,0) + nvl(x.reserve_depreciation_amount,0) + nvl(x.reserve_reclass_amount,0) - nvl(x.reserve_retirement_amount,0) + nvl(x.reserve_adjustment_amount,0) + nvl(x.reserve_transfer_amount,0)) when 0 then to_number(null) else nvl(x.reserve_end_amount,0) - (nvl(x.reserve_begin_amount,0) + nvl(x.reserve_addition_amount,0) + nvl(x.reserve_depreciation_amount,0) + nvl(x.reserve_reclass_amount,0) - nvl(x.reserve_retirement_amount,0) + nvl(x.reserve_adjustment_amount,0) + nvl(x.reserve_transfer_amount,0)) end ) reserve_out_of_balance_amount, max(x.reserve_out_of_balance_flag) reserve_out_of_balance_flag, case max(x.reserve_reval_tax_flag) when 'R' then 'Revaluation Adjustment' when 'T' then 'Tax Adjustment' when 'B' then 'Revaluation and Tax Adjustments' end reserve_adjustment_type, case fa_fasrsves_xmlp_pkg.reval_tax_flagformula ( sum(x.reserve_revaluation_amount) , sum(x.reserve_tax_amount) ) when 'R' then 'Revaluation Adjustment' when 'T' then 'Tax Adjustment' when 'B' then 'Revaluation and Tax Adjustments' end reserve_cost_ctr_adj_type, US Show Depreciation Reserve :$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