ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1D63869E053B46B63588994 SELECT fat.description "Asset_Name" , fb.life_in_months , fab.asset_number "asset_number" , fab.asset_id , to_char(fb.date_placed_in_service,'DD-MON-RRRR') "date_placed_in_service" , to_char(fr.date_retired,'DD-MON-RRRR') "retirement_date" , ceil(months_between(fr.date_retired, fb.prorate_date)) "Actual_lifetime" , fr.proceeds_of_sale "proceeds_of_sale" , fr.cost_of_removal "cost_of_removal" , fr.nbv_retired "net_book_value" , DECODE(SIGN(fr.gain_loss_amount), 1, fr.gain_loss_amount, 0) gain_amount , DECODE(SIGN(fr.gain_loss_amount), -1, -1 * (fr.gain_loss_amount), 0) loss_amount , fr.retirement_type_code "retirement_type" ,DECODE(fr.retirement_type_code,'RETIREMENT',0,(fb.life_in_months - ceil(months_between(fr.date_retired, fb.prorate_date))))write_off_time ,DECODE(fr.retirement_type_code,'RETIREMENT',0,DECODE(SIGN(fr.gain_loss_amount), -1,-1 * (fr.gain_loss_amount), 0)/(fb.life_in_months - ceil(months_between(fr.date_retired, fb.prorate_date))) )write_off_amount FROM fa_books fb , fa_retirements fr , fa_additions_b fab , fa_additions_tl fat , fa_lookups_b flb WHERE fb.book_type_code = :P_BOOK_NAME &lp_date_retired AND fab.asset_id = fb.asset_id AND fab.asset_id = fat.asset_id AND fb.book_type_code = fr.book_type_code AND fb.asset_id = fr.asset_id AND fr.status = 'PROCESSED' AND fat.language='US' AND fb.date_ineffective IS NULL AND fb.transaction_header_id_out IS NULL AND flb.lookup_type = 'RETIREMENT' AND flb.lookup_code(+) = fr.retirement_type_code AND &lp_free_of_charge = 'Y' ORDER BY asset_number Y OFA FASARTR AR FA سجل ضرائب استبعاد الأصول - (روسيا) Application: الأصول Source: سجل ضرائب استبعاد الأصول - (روسيا) Short Name: FASARTR DB package: FA_RETMT_TAX_REG_RPT_PKG D FA Steuerregister Anlagenabgänge (Russland) Application: Anlagen Source: Steuerregister Anlagenabgänge (Russland) Short Name: FASARTR DB package: FA_RETMT_TAX_REG_RPT_PKG F FA Registre fiscal de cession d'immobilisation (Russie) Application: Assets Source: Registre fiscal de cession d'immobilisation (Russie) Short Name: FASARTR DB package: FA_RETMT_TAX_REG_RPT_PKG US FA Asset Retirement Tax Register -(Russia) Application: Assets Source: Asset Retirement Tax Register -(Russia) Short Name: FASARTR DB package: FA_RETMT_TAX_REG_RPT_PKG ZHS FA 资产报废税登记表 -（俄罗斯） Application: 资产 Source: 资产报废税登记表 -（俄罗斯） Short Name: FASARTR DB package: FA_RETMT_TAX_REG_RPT_PKG BI Publisher &lp_date_retired &lp_free_of_charge :cp_no_data :lp_company_name :lp_currency_code :lp_free_of_charge :p_book_name 1 10 :p_book_name 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 Y AR اسم الدفتر D AfA-Buch F Nom du livre d'amortissement US Book Name ZHS 帐簿名称 2 20 :p_from_period 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 Y AR من الفترة D Von Periode F De la période US From Period ZHS 自期间 3 30 :p_to_period 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 Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间 :$flex$.fa_book_type Book Name From Period :$flex$.fa_book_type Book Name To Period :$flex$.fa_period_name From Period To Period