[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ajitf.rowid,
ad.asset_id,
ajitf.asset_number,
ad.asset_type,
ajitf.adjusted_rate,
ajitf.basic_rate,
ajitf.bonus_rule,
ajitf.ceiling_name,
ajitf.cost,
ajitf.date_placed_in_service,
ajitf.depreciate_flag,
ajitf.deprn_method_code,
ajitf.itc_amount_id,
ajitf.life_in_months,
ajitf.original_cost,
ajitf.production_capacity,
ajitf.prorate_convention_code,
ajitf.salvage_value,
ajitf.short_fiscal_year_flag,
ajitf.conversion_date,
ajitf.original_deprn_start_date,
ajitf.fully_rsvd_revals_counter,
ajitf.unrevalued_cost,
ajitf.reval_ceiling,
ajitf.deprn_reserve,
ajitf.ytd_deprn,
ajitf.reval_amortization_basis,
ajitf.reval_reserve,
ajitf.ytd_reval_deprn_expense,
decode(ajitf.amortize_nbv_flag,
'YES', 'AMORTIZED',
'EXPENSED') transaction_subtype,
ajitf.amortization_start_date,
nvl(ajitf.transaction_name, 'Adjustments Interface') transaction_name,
ajitf.attribute1,
ajitf.attribute2,
ajitf.attribute3,
ajitf.attribute4,
ajitf.attribute5,
ajitf.attribute6,
ajitf.attribute7,
ajitf.attribute8,
ajitf.attribute9,
ajitf.attribute10,
ajitf.attribute11,
ajitf.attribute12,
ajitf.attribute13,
ajitf.attribute14,
ajitf.attribute15,
ajitf.attribute_category_code,
nvl(ajitf.global_attribute1,
bk.global_attribute1) global_attribute1,
nvl(ajitf.global_attribute2,
bk.global_attribute2) global_attribute2,
nvl(ajitf.global_attribute3,
bk.global_attribute3) global_attribute3,
nvl(ajitf.global_attribute4,
bk.global_attribute4) global_attribute4,
nvl(ajitf.global_attribute5,
bk.global_attribute5) global_attribute5,
nvl(ajitf.global_attribute6,
bk.global_attribute6) global_attribute6,
nvl(ajitf.global_attribute7,
bk.global_attribute7) global_attribute7,
nvl(ajitf.global_attribute8,
bk.global_attribute8) global_attribute8,
nvl(ajitf.global_attribute9,
bk.global_attribute9) global_attribute9,
nvl(ajitf.global_attribute10,
bk.global_attribute10) global_attribute10,
nvl(ajitf.global_attribute11,
bk.global_attribute11) global_attribute11,
nvl(ajitf.global_attribute12,
bk.global_attribute12) global_attribute12,
nvl(ajitf.global_attribute13,
bk.global_attribute13) global_attribute13,
nvl(ajitf.global_attribute14,
bk.global_attribute14) global_attribute14,
nvl(ajitf.global_attribute15,
bk.global_attribute15) global_attribute15,
nvl(ajitf.global_attribute16,
bk.global_attribute16) global_attribute16,
nvl(ajitf.global_attribute17,
bk.global_attribute17) global_attribute17,
nvl(ajitf.global_attribute18,
bk.global_attribute18) global_attribute18,
nvl(ajitf.global_attribute19,
bk.global_attribute19) global_attribute19,
nvl(ajitf.global_attribute20,
bk.global_attribute20) global_attribute20,
nvl(ajitf.global_attribute_category,
bk.global_attribute_category) global_attribute_category,
ajitf.group_asset_id,
ajitf.cash_generating_unit_id,
bk.period_counter_fully_reserved,
bk.period_counter_fully_retired,
bk.cash_generating_unit_id
from fa_adjustments_t ajitf,
fa_books bk,
fa_additions_b ad
where ajitf.book_type_code = p_book_type_code
and ajitf.posting_status = 'POST'
and ajitf.asset_number = ad.asset_number
and bk.asset_id = ad.asset_id
and bk.book_type_code = p_book_type_code
and bk.date_ineffective is null
and ad.asset_id > px_max_asset_id
-- any potenajitfal change in group will be
-- assigned to the first worker avoiding
-- the potential locking issues between workers
and decode(ajitf.group_asset_id,
null,
MOD(nvl(bk.group_asset_id, ad.asset_id), p_total_requests),
0) = (p_request_number - 1)
order by ad.asset_id;
select count(*)
into l_amort_count
from fa_books bk
where bk.book_type_code = p_book
and bk.asset_id = p_asset_id
and (bk.rate_Adjustment_factor <> 1 OR
(bk.rate_adjustment_factor = 1 and
exists (select 'YES' -- and amortized before.
from fa_transaction_headers th,
fa_methods mt
where th.book_type_code = bk.book_type_code
and th.asset_id = bk.asset_id
and th.transaction_type_code = 'ADJUSTMENT'
and (th.transaction_subtype = 'AMORTIZED' OR th.transaction_key = 'UA')
and th.transaction_header_id = bk.transaction_header_id_in
and mt.method_code = bk.deprn_method_code
and mt.rate_source_rule IN ('TABLE','FLAT','PRODUCTION'))));
l_asset_fin_mrc_tbl_new.delete;
l_inv_tbl.delete;
l_asset_deprn_mrc_tbl_new.delete;
l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
l_trans_rec.who_info.last_update_date := sysdate;
l_trans_rec.who_info.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
select nvl(sum(decode(debit_credit_flag,
'DR', adjustment_amount,
-adjustment_amount)), 0)
into l_deprn_exp_amort_nbv
from fa_adjustments
where book_type_code = l_asset_hdr_rec.book_type_code
and asset_id = l_asset_hdr_rec.asset_id
and source_type_code = 'DEPRECIATION'
and adjustment_type = 'EXPENSE';
update fa_adjustments_t
set posting_status = 'POSTED',
request_id = l_request_id
where rowid = l_itf_rowid(l_loop_count);
update fa_adjustments_t
set posting_status = 'ERROR',
request_id = l_request_id
where rowid = l_itf_rowid(l_loop_count);
update fa_adjustments_t
set posting_status = 'WARNING',
request_id = l_request_id
where rowid = l_itf_rowid(l_loop_count);
update fa_adjustments_t
set posting_status = 'ERROR',
request_id = l_request_id
where rowid = l_itf_rowid(l_loop_count);