ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 638CF2FFBFC83630E05392D1825E8155 select x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, x.asset_type, x.asset_account, x.cost_center, x.asset_number, x.asset_desciption, x.date_placed_in_service, x.date_retired, x.period, x.transaction_type, x.cost_retired, x.net_book_value_retired, x.proceeds_of_sale, x.removal_cost, x.reval_reserve_retired, ( -x.net_book_value_retired + x.proceeds_of_sale - x.removal_cost + x.reval_reserve_retired ) gain_loss, x.transaction_number, x.company_name || ': ' || x.book || ' (' || x.currency || ')' comp_book_curr_label from (select /*+ ordered */ fsc.company_name, gsob.name ledger, fb.book_type_code book, gsob.currency_code currency, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') balancing_segment, fl.meaning asset_type, decode(fah.asset_type,'CIP', fcb.cip_cost_acct,fcb.asset_cost_acct) asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, fa.asset_number, fa.description asset_desciption, fr.date_retired, (select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=fb.book_type_code and fth.date_effective >= fdp.calendar_period_open_date and fth.date_effective < fdp.calendar_period_close_date + 1 and rownum=1) period, fth.transaction_type_code, (select flv.meaning from fa_lookups_vl flv where flv.lookup_type='FAXOLTRX' and fth.transaction_type_code=flv.lookup_code) transaction_type, fth.asset_id, fb.date_placed_in_service, sum(decode(fadj.adjustment_type,'COST',1, 'CIP COST',1,0) * decode(fadj.debit_credit_flag,'DR',-1,'CR', 1,0) * fadj.adjustment_amount) cost_retired, sum(decode(fadj.adjustment_type,'NBV RETIRED',-1,0) * decode(fadj.debit_credit_flag,'DR',-1,'CR', 1,0) * fadj.adjustment_amount) net_book_value_retired, sum(decode(fadj.adjustment_type,'PROCEEDS CLR',1,'PROCEEDS',1,0) * decode(fadj.debit_credit_flag,'DR', 1,'CR',-1,0) * fadj.adjustment_amount) proceeds_of_sale, sum(decode(fadj.adjustment_type,'REMOVALCOST',-1,0) * decode(fadj.debit_credit_flag,'DR',-1,'CR', 1,0) * fadj.adjustment_amount) removal_cost, sum(decode(fadj.adjustment_type,'REVAL RSV RET',1,0) * decode(fadj.debit_credit_flag,'DR',-1,'CR', 1,0) * fadj.adjustment_amount) reval_reserve_retired, fth.transaction_header_id transaction_number from fa_system_controls fsc, gl_sets_of_books gsob, fa_transaction_headers fth, fa_additions fa, &lp_fa_books fb, &lp_fa_retirements fr, &lp_fa_adjustments fadj, fa_distribution_history fdh, gl_code_combinations gcc, fa_asset_history fah, fa_category_books fcb, fa_lookups fl where gsob.set_of_books_id = :p_ca_set_of_books_id and fth.date_effective >= :period1_pod and fth.date_effective <= :period2_pcd and fth.book_type_code = :p_book and fth.transaction_key = 'R' and fr.book_type_code = :p_book and fr.asset_id = fb.asset_id and decode(fth.transaction_type_code,'REINSTATEMENT', fr.transaction_header_id_out,fr.transaction_header_id_in) = fth.transaction_header_id and fa.asset_id = fth.asset_id and fadj.asset_id = fr.asset_id and fadj.book_type_code = :p_book and fadj.adjustment_type not in (select 'PROCEEDS' from &lp_fa_adjustments fadj1 where fadj1.book_type_code = fadj.book_type_code and fadj1.asset_id = fadj.asset_id and fadj1.transaction_header_id = fadj.transaction_header_id and fadj1.adjustment_type = 'PROCEEDS CLR' ) and fadj.transaction_header_id = fth.transaction_header_id and fah.asset_id = fa.asset_id and fah.date_effective <= fth.date_effective and nvl(fah.date_ineffective, fth.date_effective+1) > fth.date_effective and fl.lookup_code = fah.asset_type and fl.lookup_type = 'ASSET TYPE' and fb.transaction_header_id_out = fth.transaction_header_id and fb.book_type_code = :p_book and fb.asset_id = fa.asset_id and fcb.category_id = fah.category_id and fcb.book_type_code = :p_book and fdh.distribution_id = fadj.distribution_id and fth.asset_id = fdh.asset_id and gcc.code_combination_id = fdh.code_combination_id group by fsc.company_name, gsob.name, fb.book_type_code, gsob.currency_code, fl.meaning, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), fth.transaction_type_code, fth.asset_id, fcb.asset_cost_acct, fcb.cip_cost_acct, fa.asset_number, fa.description, fb.date_placed_in_service, fr.date_retired, fth.date_effective, fth.transaction_header_id, fah.asset_type, fr.gain_loss_amount union select /*+ ordered */ fsc.company_name, gsob.name ledger, fb.book_type_code book, gsob.currency_code currency, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') balancing_segment, fl.meaning asset_type, decode (fah.asset_type,'CIP', fcb.cip_cost_acct,fcb.asset_cost_acct) asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, fa.asset_number, fa.description asset_desciption, fr.date_retired, (select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=fb.book_type_code and fth.date_effective >= fdp.calendar_period_open_date and fth.date_effective < fdp.calendar_period_close_date + 1 and rownum=1) period, fth.transaction_type_code, (select flv.meaning from fa_lookups_vl flv where flv.lookup_type='FAXOLTRX' and fth.transaction_type_code=flv.lookup_code) transaction_type, fth.asset_id, fb.date_placed_in_service, 0 cost_retired, 0 net_book_value_retired, nvl(fr.proceeds_of_sale,0) proceeds_of_sale, nvl(fr.cost_of_removal,0) removal_cost, 0 reval_reserve_retired, fth.transaction_header_id transaction_number from fa_system_controls fsc, gl_sets_of_books gsob, fa_transaction_headers fth, fa_additions fa, &lp_fa_books fb, &lp_fa_retirements fr, (select fdh.* from fa_transaction_headers fth1, fa_distribution_history fdh, fa_book_controls fbc, fa_transaction_headers fth2 where fth1.book_type_code = :p_book and fth1.transaction_type_code in ( 'FULL RETIREMENT', 'PARTIAL RETIREMENT') and fth1.date_effective between :period1_pod and :period2_pcd and fth1.asset_id = fdh.asset_id and fbc.book_type_code = fth1.book_type_code and fbc.distribution_source_book = fdh.book_type_code and fth1.date_effective <= nvl(fdh.date_ineffective,fth1.date_effective) and fth1.asset_id = fth2.asset_id and fth2.book_type_code = :p_book and fth2.transaction_type_code = 'REINSTATEMENT' and fth2.date_effective between :period1_pod and :period2_pcd and fth2.date_effective >= fdh.date_effective ) fdh, gl_code_combinations gcc, fa_asset_history fah, fa_category_books fcb, fa_lookups fl where gsob.set_of_books_id = :p_ca_set_of_books_id and fth.date_effective >= :period1_pod and fth.date_effective <= :period2_pcd and fth.book_type_code = :p_book and fth.transaction_key = 'R' and fr.book_type_code = :p_book and fr.asset_id = fb.asset_id and fr.transaction_header_id_out = fth.transaction_header_id and fa.asset_id = fth.asset_id and fah.asset_id = fa.asset_id and fah.date_effective <= fth.date_effective and nvl(fah.date_ineffective, fth.date_effective+1) > fth.date_effective and fl.lookup_code = fah.asset_type and fl.lookup_type = 'ASSET TYPE' and fb.transaction_header_id_out = fth.transaction_header_id and fb.book_type_code = :p_book and fb.asset_id = fa.asset_id and fcb.category_id = fah.category_id and fcb.book_type_code = :p_book and fth.asset_id = fdh.asset_id and gcc.code_combination_id = fdh.code_combination_id and fth.transaction_type_code = 'REINSTATEMENT' and fr.cost_retired = 0 and fr.cost_of_removal = 0 and fr.proceeds_of_sale = 0 group by fsc.company_name, gsob.name, fb.book_type_code, gsob.currency_code, fl.meaning, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), fth.transaction_type_code, fth.asset_id, fcb.asset_cost_acct, fcb.cip_cost_acct, fa.asset_number, fa.description, fb.date_placed_in_service, fr.date_retired, fth.date_effective, fth.transaction_header_id, fah.asset_type, fr.gain_loss_amount, fr.status, fr.proceeds_of_sale, fr.cost_of_removal ) x order by x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, x.asset_type, x.asset_account, x.cost_center, x.asset_number, x.date_retired Y OFA FAS440_XML #,##0.00;[Red]-#,##0.00 AR FA Asset Retirements معاملات سحب الأصول ، بناءً على تقرير Oracle القياسي FAS440_XML. D FA Asset Retirements Application: Anlagen Source: Anlagenabgänge (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS440_XML DB package: FA_FAS440_XMLP_PKG E FA Asset Retirements Transacciones de retirada de activos, basadas en el informe estándar de Oracle FAS440_XML. F FA Asset Retirements Application: Assets Source: Etat des cessions d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS440_XML DB package: FA_FAS440_XMLP_PKG I FA Asset Retirements Transazioni di pensionamento di beni, basate sul rapporto standard Oracle FAS440_XML. JA FA Asset Retirements Oracle標準レポートFAS440_XMLに基づく資産除去取引。 KO FA Asset Retirements Oracle 표준 보고서 FAS440_XML을 기반으로 한 자산 처분 거래. PTB FA Asset Retirements Transações de aposentadoria de ativos, baseadas no relatório padrão FAS440_XML da Oracle. RU FA Asset Retirements Операции по выводу активов из эксплуатации, основанные на стандартном отчете Oracle FAS440_XML. S FA Asset Retirements Tillgångspensionstransaktioner, baserade på Oracles standardrapport FAS440_XML. TR FA Asset Retirements Oracle standart raporu FAS440_XML'ye dayalı varlık kullanımdan çıkarma işlemleri. US FA Asset Retirements Imported from BI Publisher Description: Asset Retirements Report Application: Assets Source: Asset Retirements Report (XML) Short Name: FAS440_XML DB package: FA_FAS440_XMLP_PKG ZHS FA Asset Retirements 资产留存交易，基于Oracle标准报告FAS440_XML。 Enginatics R12 only &lp_fa_adjustments &lp_fa_books &lp_fa_retirements :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :lp_currency_code :lp_fa_adjustments :lp_fa_book_controls :lp_fa_books :lp_fa_retirements :p_book :p_ca_set_of_books_id :p_conc_request_id :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :period_from :period_to :precision :rp_company_name :rp_report_name 1 -30 :p_mrcsobtype Char select nvl( (select decode(gsob.mrc_sob_type_code,'R','R','P') from gl_sets_of_books gsob where gsob.set_of_books_id = :$flex$.Set_Of_Books_Currency ) ,'P' ) from dual F Drapeau MRC US MRC Flag 2 &lp_fa_adjustments fa_adjustments P F Drapeau MRC US MRC Flag 3 &lp_fa_adjustments fa_adjustments_mrc_v R F Drapeau MRC US MRC Flag 4 &lp_fa_books fa_books P F Drapeau MRC US MRC Flag 5 &lp_fa_books fa_books_mrc_v R F Drapeau MRC US MRC Flag 6 &lp_fa_retirements fa_retirements P F Drapeau MRC US MRC Flag 7 &lp_fa_retirements fa_retirements_mrc_v R F Drapeau MRC US MRC Flag 8 -20 :period1_pod DateTime select fdpmv.period_open_date from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code = :$flex$.Book and fdpmv.period_name = :$flex$.From_Period and :$flex$.MRC_Flag = 'R' union select fdp.period_open_date from fa_deprn_periods fdp where fdp.book_type_code = :$flex$.Book and fdp.period_name = :$flex$.From_Period and nvl(:$flex$.MRC_Flag,'P') != 'R' F De la période Date d'ouverture US From Period Open Date 9 -10 :period2_pcd DateTime select nvl(fdpmv.period_close_date, sysdate) from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code = :$flex$.Book and fdpmv.period_name = :$flex$.To_Period and :$flex$.MRC_Flag = 'R' union select nvl(fdp.period_close_date, sysdate) from fa_deprn_periods fdp where fdp.book_type_code = :$flex$.Book and fdp.period_name = :$flex$.To_Period and nvl(:$flex$.MRC_Flag,'P') != 'R' F Au Date de clôture de la période US To Period Close Date 10 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 Retirements' 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 F Livre US Book 11 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 F Ensemble de livres Monnaie US Set of Books Currency 12 30 :p_period1 LOV Oracle FA_PERIOD_NAME 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 F De la période US From Period 13 40 :p_period2 LOV Oracle FA_PERIOD_TO 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) order by period_counter :$flex$.fa_period_name Y F À la période US To Period :$flex$.Book Book From Period Open Date :$flex$.Book Book To Period Close Date :$flex$.From_Period From Period From Period Open Date :$flex$.MRC_Flag MRC Flag From Period Open Date :$flex$.MRC_Flag MRC Flag To Period Close Date :$flex$.Set_Of_Books_Currency Set of Books Currency MRC Flag :$flex$.To_Period To Period To Period Close Date :$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 From Period To Period Pivot: Default Template Asset Retirements Summary (Pivot) with Asset Retirement Details by Asset SYSADMIN 7 ASSET_ACCOUNT 6 10 ASSET_DESCIPTION 9 ASSET_NUMBER 8 6 ASSET_TYPE 5 5 BALANCING_SEGMENT 4 3 BOOK 3 1 COMPANY_NAME 1 22 COMP_BOOK_CURR_LABEL 8 COST_CENTER 7 15 COST_RETIRED 4 CURRENCY 11 DATE_PLACED_IN_SERVICE 12 DATE_RETIRED 20 GAIN_LOSS 2 LEDGER 2 16 NET_BOOK_VALUE_RETIRED 13 PERIOD 17 PROCEEDS_OF_SALE 18 REMOVAL_COST 19 REVAL_RESERVE_RETIRED 21 TRANSACTION_NUMBER 9 14 TRANSACTION_TYPE ASSET_ACCOUNT ROW 4 ASSET_TYPE ROW 3 BALANCING_SEGMENT ROW 2 COMP_BOOK_CURR_LABEL ROW 1 COST_CENTER ROW 5 COST_RETIRED VALUE 1 SUM GAIN_LOSS VALUE 6 SUM NET_BOOK_VALUE_RETIRED VALUE 2 SUM PERIOD FILTER 1 PROCEEDS_OF_SALE VALUE 3 SUM REMOVAL_COST VALUE 4 SUM REVAL_RESERVE_RETIRED VALUE 5 SUM S Site Pivot: Default Template