FA Asset Retirement
Description
Categories: Draft
Detail report with retirement ID, asset ID, date retired, cost retired, status, retirement prorate convention, number of units, cost, gain or loss amount, proceeds and retirement type.
SELECT ret.ROWID ret_rowid, ret.retirement_id, ret.book_type_code, ret.asset_id, ret.transaction_header_id_in, ret.date_retired, ret.date_effective, ret.cost_retired, ret.status, ret.last_update_date, ret.last_updated_by, ret.retirement_prorate_convention, ret.transaction_header_id_out, ret.units, ret.cost_of_removal, ret.nbv_retired, ret.gain_loss_amount, ret.proceeds_of_sale, ret.gain_loss_type_code, ret.retirement_type_code, ret.itc_recaptured, ret.itc_recapture_id, ret.reference_num, ret.sold_to, ret.trade_in_asset_id, ret.stl_method_code, ret.stl_life_in_months, ret.stl_deprn_amount, ret.created_by, ret.creation_date, ret.last_update_login, ret.attribute1 ret_attribute1, ret.attribute2 ret_attribute2, ret.attribute3 ret_attribute3, ret.attribute4 ret_attribute4, ret.attribute5 ret_attribute5, ret.attribute6 ret_attribute6, ret.attribute7 ret_attribute7, ret.attribute8 ret_attribute8, ret.attribute9 ret_attribute9, ret.attribute10 ret_attribute10, ret.attribute11 ret_attribute11, ret.attribute12 ret_attribute12, ret.attribute13 ret_attribute13, ret.attribute14 ret_attribute14, ret.attribute15 ret_attribute15, ret.attribute_category_code ret_attribute_category_code, ret.reval_reserve_retired, ret.unrevalued_cost_retired, ad.asset_number asset_number, bks.cost cost, ah.units current_units, trade_in.asset_number trade_in_asset_number, adt.description trade_in_asset_desc, th.transaction_name, th.attribute1, th.attribute2, th.attribute3, th.attribute4, th.attribute5, th.attribute6, th.attribute7, th.attribute8, th.attribute9, th.attribute10, th.attribute11, th.attribute12, th.attribute13, th.attribute14, th.attribute15, th.attribute_category_code, bc.current_fiscal_year, bc.fiscal_year_name, fy.start_date fy_start_date, fy.end_date fy_end_date, th.invoice_transaction_id, bks.group_asset_id group_asset_id, ret.recognize_gain_loss recognize_gain_loss, ret.recapture_reserve_flag recapture_reserve_flag, ret.limit_proceeds_flag limit_proceeds_flag, ret.terminal_gain_loss terminal_gain_loss, ret.reduction_rate reduction_rate, ret.eofy_reserve eofy_reserve, ret.reserve_retired reserve_retired, ret.recapture_amount recapture_amount, th.date_effective transaction_date_effective FROM fa_retirements ret, fa_additions_b ad, fa_books bks, fa_book_controls bc, fa_fiscal_year fy, fa_asset_history ah, fa_additions_b trade_in, fa_additions_tl adt, fa_transaction_headers th WHERE ad.asset_id = ret.asset_id AND bks.book_type_code = ret.book_type_code AND bks.asset_id = ret.asset_id AND bks.transaction_header_id_out = ret.transaction_header_id_in AND bks.date_ineffective > ah.date_effective AND bks.date_ineffective <= NVL (ah.date_ineffective, SYSDATE) AND ah.asset_id = ret.asset_id AND trade_in.asset_id(+) = ret.trade_in_asset_id AND th.transaction_header_id = ret.transaction_header_id_in AND bc.book_type_code = ret.book_type_code AND fy.fiscal_year_name = bc.fiscal_year_name AND fy.fiscal_year = bc.current_fiscal_year AND adt.asset_id(+) = trade_in.asset_id AND adt.language(+) = USERENV ('LANG') |