[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select date_placed_in_service ,
deprn_start_date ,
deprn_method_code ,
life_in_months ,
rate_adjustment_factor ,
adjusted_cost ,
cost ,
original_cost ,
salvage_value ,
prorate_convention_code ,
prorate_date ,
cost_change_flag ,
adjustment_required_status ,
capitalize_flag ,
retirement_pending_flag ,
depreciate_flag ,
disabled_flag , /* HH group ed */
itc_amount_id ,
itc_amount ,
retirement_id ,
tax_request_id ,
itc_basis ,
basic_rate ,
adjusted_rate ,
bonus_rule ,
ceiling_name ,
recoverable_cost ,
adjusted_capacity ,
fully_rsvd_revals_counter ,
idled_flag ,
period_counter_capitalized ,
period_counter_fully_reserved ,
period_counter_fully_retired ,
production_capacity ,
reval_amortization_basis ,
reval_ceiling ,
unit_of_measure ,
unrevalued_cost ,
annual_deprn_rounding_flag ,
percent_salvage_value ,
allowed_deprn_limit ,
allowed_deprn_limit_amount ,
period_counter_life_complete ,
adjusted_recoverable_cost ,
annual_rounding_flag ,
eofy_adj_cost ,
eofy_formula_factor ,
short_fiscal_year_flag ,
conversion_date ,
ORIGINAL_DEPRN_START_DATE ,
remaining_life1 ,
remaining_life2 ,
group_asset_id ,
old_adjusted_cost ,
formula_factor ,
global_attribute1 ,
global_attribute2 ,
global_attribute3 ,
global_attribute4 ,
global_attribute5 ,
global_attribute6 ,
global_attribute7 ,
global_attribute8 ,
global_attribute9 ,
global_attribute10 ,
global_attribute11 ,
global_attribute12 ,
global_attribute13 ,
global_attribute14 ,
global_attribute15 ,
global_attribute16 ,
global_attribute17 ,
global_attribute18 ,
global_attribute19 ,
global_attribute20 ,
global_attribute_category ,
salvage_type ,
deprn_limit_type ,
over_depreciate_option ,
super_group_id ,
reduction_rate ,
reduce_addition_flag ,
reduce_adjustment_flag ,
reduce_retirement_flag ,
recognize_gain_loss ,
recapture_reserve_flag ,
limit_proceeds_flag ,
terminal_gain_loss ,
tracking_method ,
allocate_to_fully_rsv_flag ,
allocate_to_fully_ret_flag ,
exclude_fully_rsv_flag ,
excess_allocation_option ,
depreciation_option ,
member_rollup_flag ,
ytd_proceeds ,
ltd_proceeds ,
eofy_reserve ,
cip_cost ,
terminal_gain_loss_amount ,
ltd_cost_of_removal ,
exclude_proceeds_from_basis ,
retirement_deprn_option ,
contract_id -- Bug:6021567
into px_asset_fin_rec.date_placed_in_service ,
px_asset_fin_rec.deprn_start_date ,
px_asset_fin_rec.deprn_method_code ,
px_asset_fin_rec.life_in_months ,
px_asset_fin_rec.rate_adjustment_factor ,
px_asset_fin_rec.adjusted_cost ,
px_asset_fin_rec.cost ,
px_asset_fin_rec.original_cost ,
px_asset_fin_rec.salvage_value ,
px_asset_fin_rec.prorate_convention_code ,
px_asset_fin_rec.prorate_date ,
px_asset_fin_rec.cost_change_flag ,
px_asset_fin_rec.adjustment_required_status ,
px_asset_fin_rec.capitalize_flag ,
px_asset_fin_rec.retirement_pending_flag ,
px_asset_fin_rec.depreciate_flag ,
px_asset_fin_rec.disabled_flag , /* HH group ed */
px_asset_fin_rec.itc_amount_id ,
px_asset_fin_rec.itc_amount ,
px_asset_fin_rec.retirement_id ,
px_asset_fin_rec.tax_request_id ,
px_asset_fin_rec.itc_basis ,
px_asset_fin_rec.basic_rate ,
px_asset_fin_rec.adjusted_rate ,
px_asset_fin_rec.bonus_rule ,
px_asset_fin_rec.ceiling_name ,
px_asset_fin_rec.recoverable_cost ,
px_asset_fin_rec.adjusted_capacity ,
px_asset_fin_rec.fully_rsvd_revals_counter ,
px_asset_fin_rec.idled_flag ,
px_asset_fin_rec.period_counter_capitalized ,
px_asset_fin_rec.period_counter_fully_reserved ,
px_asset_fin_rec.period_counter_fully_retired ,
px_asset_fin_rec.production_capacity ,
px_asset_fin_rec.reval_amortization_basis ,
px_asset_fin_rec.reval_ceiling ,
px_asset_fin_rec.unit_of_measure ,
px_asset_fin_rec.unrevalued_cost ,
px_asset_fin_rec.annual_deprn_rounding_flag ,
px_asset_fin_rec.percent_salvage_value ,
px_asset_fin_rec.allowed_deprn_limit ,
px_asset_fin_rec.allowed_deprn_limit_amount ,
px_asset_fin_rec.period_counter_life_complete ,
px_asset_fin_rec.adjusted_recoverable_cost ,
px_asset_fin_rec.annual_rounding_flag ,
px_asset_fin_rec.eofy_adj_cost ,
px_asset_fin_rec.eofy_formula_factor ,
px_asset_fin_rec.short_fiscal_year_flag ,
px_asset_fin_rec.conversion_date ,
px_asset_fin_rec.orig_deprn_start_date ,
px_asset_fin_rec.remaining_life1 ,
px_asset_fin_rec.remaining_life2 ,
px_asset_fin_rec.group_asset_id ,
px_asset_fin_rec.old_adjusted_cost ,
px_asset_fin_rec.formula_factor ,
px_asset_fin_rec.global_attribute1 ,
px_asset_fin_rec.global_attribute2 ,
px_asset_fin_rec.global_attribute3 ,
px_asset_fin_rec.global_attribute4 ,
px_asset_fin_rec.global_attribute5 ,
px_asset_fin_rec.global_attribute6 ,
px_asset_fin_rec.global_attribute7 ,
px_asset_fin_rec.global_attribute8 ,
px_asset_fin_rec.global_attribute9 ,
px_asset_fin_rec.global_attribute10 ,
px_asset_fin_rec.global_attribute11 ,
px_asset_fin_rec.global_attribute12 ,
px_asset_fin_rec.global_attribute13 ,
px_asset_fin_rec.global_attribute14 ,
px_asset_fin_rec.global_attribute15 ,
px_asset_fin_rec.global_attribute16 ,
px_asset_fin_rec.global_attribute17 ,
px_asset_fin_rec.global_attribute18 ,
px_asset_fin_rec.global_attribute19 ,
px_asset_fin_rec.global_attribute20 ,
px_asset_fin_rec.global_attribute_category ,
px_asset_fin_rec.salvage_type ,
px_asset_fin_rec.deprn_limit_type ,
px_asset_fin_rec.over_depreciate_option ,
px_asset_fin_rec.super_group_id ,
px_asset_fin_rec.reduction_rate ,
px_asset_fin_rec.reduce_addition_flag ,
px_asset_fin_rec.reduce_adjustment_flag ,
px_asset_fin_rec.reduce_retirement_flag ,
px_asset_fin_rec.recognize_gain_loss ,
px_asset_fin_rec.recapture_reserve_flag ,
px_asset_fin_rec.limit_proceeds_flag ,
px_asset_fin_rec.terminal_gain_loss ,
px_asset_fin_rec.tracking_method ,
px_asset_fin_rec.allocate_to_fully_rsv_flag ,
px_asset_fin_rec.allocate_to_fully_ret_flag ,
px_asset_fin_rec.exclude_fully_rsv_flag ,
px_asset_fin_rec.excess_allocation_option ,
px_asset_fin_rec.depreciation_option ,
px_asset_fin_rec.member_rollup_flag ,
px_asset_fin_rec.ytd_proceeds ,
px_asset_fin_rec.ltd_proceeds ,
px_asset_fin_rec.eofy_reserve ,
px_asset_fin_rec.cip_cost ,
px_asset_fin_rec.terminal_gain_loss_amount ,
px_asset_fin_rec.ltd_cost_of_removal ,
px_asset_fin_rec.exclude_proceeds_from_basis ,
px_asset_fin_rec.retirement_deprn_option ,
px_asset_fin_rec.contract_id -- Bug:6021567
from fa_books_mrc_v
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id_out is null;
select date_placed_in_service ,
deprn_start_date ,
deprn_method_code ,
life_in_months ,
rate_adjustment_factor ,
adjusted_cost ,
cost ,
original_cost ,
salvage_value ,
prorate_convention_code ,
prorate_date ,
cost_change_flag ,
adjustment_required_status ,
capitalize_flag ,
retirement_pending_flag ,
depreciate_flag ,
disabled_flag , /* HH group ed */
itc_amount_id ,
itc_amount ,
retirement_id ,
tax_request_id ,
itc_basis ,
basic_rate ,
adjusted_rate ,
bonus_rule ,
ceiling_name ,
recoverable_cost ,
adjusted_capacity ,
fully_rsvd_revals_counter ,
idled_flag ,
period_counter_capitalized ,
period_counter_fully_reserved ,
period_counter_fully_retired ,
production_capacity ,
reval_amortization_basis ,
reval_ceiling ,
unit_of_measure ,
unrevalued_cost ,
annual_deprn_rounding_flag ,
percent_salvage_value ,
allowed_deprn_limit ,
allowed_deprn_limit_amount ,
period_counter_life_complete ,
adjusted_recoverable_cost ,
annual_rounding_flag ,
eofy_adj_cost ,
eofy_formula_factor ,
short_fiscal_year_flag ,
conversion_date ,
ORIGINAL_DEPRN_START_DATE ,
remaining_life1 ,
remaining_life2 ,
group_asset_id ,
old_adjusted_cost ,
formula_factor ,
global_attribute1 ,
global_attribute2 ,
global_attribute3 ,
global_attribute4 ,
global_attribute5 ,
global_attribute6 ,
global_attribute7 ,
global_attribute8 ,
global_attribute9 ,
global_attribute10 ,
global_attribute11 ,
global_attribute12 ,
global_attribute13 ,
global_attribute14 ,
global_attribute15 ,
global_attribute16 ,
global_attribute17 ,
global_attribute18 ,
global_attribute19 ,
global_attribute20 ,
global_attribute_category ,
salvage_type ,
deprn_limit_type ,
over_depreciate_option ,
super_group_id ,
reduction_rate ,
reduce_addition_flag ,
reduce_adjustment_flag ,
reduce_retirement_flag ,
recognize_gain_loss ,
recapture_reserve_flag ,
limit_proceeds_flag ,
terminal_gain_loss ,
tracking_method ,
allocate_to_fully_rsv_flag ,
allocate_to_fully_ret_flag ,
exclude_fully_rsv_flag ,
excess_allocation_option ,
depreciation_option ,
member_rollup_flag ,
ytd_proceeds ,
ltd_proceeds ,
eofy_reserve ,
cip_cost ,
terminal_gain_loss_amount ,
ltd_cost_of_removal ,
exclude_proceeds_from_basis ,
retirement_deprn_option ,
contract_id, -- Bug:6021567
extended_deprn_flag , -- Japan Tax phase3
extended_depreciation_period , -- Japan Tax phase3
period_counter_fully_extended -- Japan Tax phase3
into px_asset_fin_rec.date_placed_in_service ,
px_asset_fin_rec.deprn_start_date ,
px_asset_fin_rec.deprn_method_code ,
px_asset_fin_rec.life_in_months ,
px_asset_fin_rec.rate_adjustment_factor ,
px_asset_fin_rec.adjusted_cost ,
px_asset_fin_rec.cost ,
px_asset_fin_rec.original_cost ,
px_asset_fin_rec.salvage_value ,
px_asset_fin_rec.prorate_convention_code ,
px_asset_fin_rec.prorate_date ,
px_asset_fin_rec.cost_change_flag ,
px_asset_fin_rec.adjustment_required_status ,
px_asset_fin_rec.capitalize_flag ,
px_asset_fin_rec.retirement_pending_flag ,
px_asset_fin_rec.depreciate_flag ,
px_asset_fin_rec.disabled_flag , /* HH group ed */
px_asset_fin_rec.itc_amount_id ,
px_asset_fin_rec.itc_amount ,
px_asset_fin_rec.retirement_id ,
px_asset_fin_rec.tax_request_id ,
px_asset_fin_rec.itc_basis ,
px_asset_fin_rec.basic_rate ,
px_asset_fin_rec.adjusted_rate ,
px_asset_fin_rec.bonus_rule ,
px_asset_fin_rec.ceiling_name ,
px_asset_fin_rec.recoverable_cost ,
px_asset_fin_rec.adjusted_capacity ,
px_asset_fin_rec.fully_rsvd_revals_counter ,
px_asset_fin_rec.idled_flag ,
px_asset_fin_rec.period_counter_capitalized ,
px_asset_fin_rec.period_counter_fully_reserved ,
px_asset_fin_rec.period_counter_fully_retired ,
px_asset_fin_rec.production_capacity ,
px_asset_fin_rec.reval_amortization_basis ,
px_asset_fin_rec.reval_ceiling ,
px_asset_fin_rec.unit_of_measure ,
px_asset_fin_rec.unrevalued_cost ,
px_asset_fin_rec.annual_deprn_rounding_flag ,
px_asset_fin_rec.percent_salvage_value ,
px_asset_fin_rec.allowed_deprn_limit ,
px_asset_fin_rec.allowed_deprn_limit_amount ,
px_asset_fin_rec.period_counter_life_complete ,
px_asset_fin_rec.adjusted_recoverable_cost ,
px_asset_fin_rec.annual_rounding_flag ,
px_asset_fin_rec.eofy_adj_cost ,
px_asset_fin_rec.eofy_formula_factor ,
px_asset_fin_rec.short_fiscal_year_flag ,
px_asset_fin_rec.conversion_date ,
px_asset_fin_rec.orig_deprn_start_date ,
px_asset_fin_rec.remaining_life1 ,
px_asset_fin_rec.remaining_life2 ,
px_asset_fin_rec.group_asset_id ,
px_asset_fin_rec.old_adjusted_cost ,
px_asset_fin_rec.formula_factor ,
px_asset_fin_rec.global_attribute1 ,
px_asset_fin_rec.global_attribute2 ,
px_asset_fin_rec.global_attribute3 ,
px_asset_fin_rec.global_attribute4 ,
px_asset_fin_rec.global_attribute5 ,
px_asset_fin_rec.global_attribute6 ,
px_asset_fin_rec.global_attribute7 ,
px_asset_fin_rec.global_attribute8 ,
px_asset_fin_rec.global_attribute9 ,
px_asset_fin_rec.global_attribute10 ,
px_asset_fin_rec.global_attribute11 ,
px_asset_fin_rec.global_attribute12 ,
px_asset_fin_rec.global_attribute13 ,
px_asset_fin_rec.global_attribute14 ,
px_asset_fin_rec.global_attribute15 ,
px_asset_fin_rec.global_attribute16 ,
px_asset_fin_rec.global_attribute17 ,
px_asset_fin_rec.global_attribute18 ,
px_asset_fin_rec.global_attribute19 ,
px_asset_fin_rec.global_attribute20 ,
px_asset_fin_rec.global_attribute_category ,
px_asset_fin_rec.salvage_type ,
px_asset_fin_rec.deprn_limit_type ,
px_asset_fin_rec.over_depreciate_option ,
px_asset_fin_rec.super_group_id ,
px_asset_fin_rec.reduction_rate ,
px_asset_fin_rec.reduce_addition_flag ,
px_asset_fin_rec.reduce_adjustment_flag ,
px_asset_fin_rec.reduce_retirement_flag ,
px_asset_fin_rec.recognize_gain_loss ,
px_asset_fin_rec.recapture_reserve_flag ,
px_asset_fin_rec.limit_proceeds_flag ,
px_asset_fin_rec.terminal_gain_loss ,
px_asset_fin_rec.tracking_method ,
px_asset_fin_rec.allocate_to_fully_rsv_flag ,
px_asset_fin_rec.allocate_to_fully_ret_flag ,
px_asset_fin_rec.exclude_fully_rsv_flag ,
px_asset_fin_rec.excess_allocation_option ,
px_asset_fin_rec.depreciation_option ,
px_asset_fin_rec.member_rollup_flag ,
px_asset_fin_rec.ytd_proceeds ,
px_asset_fin_rec.ltd_proceeds ,
px_asset_fin_rec.eofy_reserve ,
px_asset_fin_rec.cip_cost ,
px_asset_fin_rec.terminal_gain_loss_amount ,
px_asset_fin_rec.ltd_cost_of_removal ,
px_asset_fin_rec.exclude_proceeds_from_basis ,
px_asset_fin_rec.retirement_deprn_option ,
px_asset_fin_rec.contract_id , -- Bug:6021567
px_asset_fin_rec.extended_deprn_flag , -- Japan Tax phase3
px_asset_fin_rec.extended_depreciation_period , -- Japan Tax phase3
px_asset_fin_rec.period_counter_fully_extended -- Japan Tax phase3
from fa_books
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id_out is null;
select date_placed_in_service ,
deprn_start_date ,
deprn_method_code ,
life_in_months ,
rate_adjustment_factor ,
adjusted_cost ,
cost ,
original_cost ,
salvage_value ,
prorate_convention_code ,
prorate_date ,
cost_change_flag ,
adjustment_required_status ,
capitalize_flag ,
retirement_pending_flag ,
depreciate_flag ,
disabled_flag , /* HH group ed */
itc_amount_id ,
itc_amount ,
retirement_id ,
tax_request_id ,
itc_basis ,
basic_rate ,
adjusted_rate ,
bonus_rule ,
ceiling_name ,
recoverable_cost ,
adjusted_capacity ,
fully_rsvd_revals_counter ,
idled_flag ,
period_counter_capitalized ,
period_counter_fully_reserved ,
period_counter_fully_retired ,
production_capacity ,
reval_amortization_basis ,
reval_ceiling ,
unit_of_measure ,
unrevalued_cost ,
annual_deprn_rounding_flag ,
percent_salvage_value ,
allowed_deprn_limit ,
allowed_deprn_limit_amount ,
period_counter_life_complete ,
adjusted_recoverable_cost ,
annual_rounding_flag ,
eofy_adj_cost ,
eofy_formula_factor ,
short_fiscal_year_flag ,
conversion_date ,
ORIGINAL_DEPRN_START_DATE ,
remaining_life1 ,
remaining_life2 ,
group_asset_id ,
old_adjusted_cost ,
formula_factor ,
global_attribute1 ,
global_attribute2 ,
global_attribute3 ,
global_attribute4 ,
global_attribute5 ,
global_attribute6 ,
global_attribute7 ,
global_attribute8 ,
global_attribute9 ,
global_attribute10 ,
global_attribute11 ,
global_attribute12 ,
global_attribute13 ,
global_attribute14 ,
global_attribute15 ,
global_attribute16 ,
global_attribute17 ,
global_attribute18 ,
global_attribute19 ,
global_attribute20 ,
global_attribute_category ,
salvage_type ,
deprn_limit_type ,
over_depreciate_option ,
super_group_id ,
reduction_rate ,
reduce_addition_flag ,
reduce_adjustment_flag ,
reduce_retirement_flag ,
recognize_gain_loss ,
recapture_reserve_flag ,
limit_proceeds_flag ,
terminal_gain_loss ,
tracking_method ,
allocate_to_fully_rsv_flag ,
allocate_to_fully_ret_flag ,
exclude_fully_rsv_flag ,
excess_allocation_option ,
depreciation_option ,
member_rollup_flag ,
ytd_proceeds ,
ltd_proceeds ,
eofy_reserve ,
cip_cost ,
terminal_gain_loss_amount ,
ltd_cost_of_removal ,
exclude_proceeds_from_basis ,
retirement_deprn_option ,
contract_id -- Bug:6021567
into px_asset_fin_rec.date_placed_in_service ,
px_asset_fin_rec.deprn_start_date ,
px_asset_fin_rec.deprn_method_code ,
px_asset_fin_rec.life_in_months ,
px_asset_fin_rec.rate_adjustment_factor ,
px_asset_fin_rec.adjusted_cost ,
px_asset_fin_rec.cost ,
px_asset_fin_rec.original_cost ,
px_asset_fin_rec.salvage_value ,
px_asset_fin_rec.prorate_convention_code ,
px_asset_fin_rec.prorate_date ,
px_asset_fin_rec.cost_change_flag ,
px_asset_fin_rec.adjustment_required_status ,
px_asset_fin_rec.capitalize_flag ,
px_asset_fin_rec.retirement_pending_flag ,
px_asset_fin_rec.depreciate_flag ,
px_asset_fin_rec.disabled_flag , /* HH group ed */
px_asset_fin_rec.itc_amount_id ,
px_asset_fin_rec.itc_amount ,
px_asset_fin_rec.retirement_id ,
px_asset_fin_rec.tax_request_id ,
px_asset_fin_rec.itc_basis ,
px_asset_fin_rec.basic_rate ,
px_asset_fin_rec.adjusted_rate ,
px_asset_fin_rec.bonus_rule ,
px_asset_fin_rec.ceiling_name ,
px_asset_fin_rec.recoverable_cost ,
px_asset_fin_rec.adjusted_capacity ,
px_asset_fin_rec.fully_rsvd_revals_counter ,
px_asset_fin_rec.idled_flag ,
px_asset_fin_rec.period_counter_capitalized ,
px_asset_fin_rec.period_counter_fully_reserved ,
px_asset_fin_rec.period_counter_fully_retired ,
px_asset_fin_rec.production_capacity ,
px_asset_fin_rec.reval_amortization_basis ,
px_asset_fin_rec.reval_ceiling ,
px_asset_fin_rec.unit_of_measure ,
px_asset_fin_rec.unrevalued_cost ,
px_asset_fin_rec.annual_deprn_rounding_flag ,
px_asset_fin_rec.percent_salvage_value ,
px_asset_fin_rec.allowed_deprn_limit ,
px_asset_fin_rec.allowed_deprn_limit_amount ,
px_asset_fin_rec.period_counter_life_complete ,
px_asset_fin_rec.adjusted_recoverable_cost ,
px_asset_fin_rec.annual_rounding_flag ,
px_asset_fin_rec.eofy_adj_cost ,
px_asset_fin_rec.eofy_formula_factor ,
px_asset_fin_rec.short_fiscal_year_flag ,
px_asset_fin_rec.conversion_date ,
px_asset_fin_rec.orig_deprn_start_date ,
px_asset_fin_rec.remaining_life1 ,
px_asset_fin_rec.remaining_life2 ,
px_asset_fin_rec.group_asset_id ,
px_asset_fin_rec.old_adjusted_cost ,
px_asset_fin_rec.formula_factor ,
px_asset_fin_rec.global_attribute1 ,
px_asset_fin_rec.global_attribute2 ,
px_asset_fin_rec.global_attribute3 ,
px_asset_fin_rec.global_attribute4 ,
px_asset_fin_rec.global_attribute5 ,
px_asset_fin_rec.global_attribute6 ,
px_asset_fin_rec.global_attribute7 ,
px_asset_fin_rec.global_attribute8 ,
px_asset_fin_rec.global_attribute9 ,
px_asset_fin_rec.global_attribute10 ,
px_asset_fin_rec.global_attribute11 ,
px_asset_fin_rec.global_attribute12 ,
px_asset_fin_rec.global_attribute13 ,
px_asset_fin_rec.global_attribute14 ,
px_asset_fin_rec.global_attribute15 ,
px_asset_fin_rec.global_attribute16 ,
px_asset_fin_rec.global_attribute17 ,
px_asset_fin_rec.global_attribute18 ,
px_asset_fin_rec.global_attribute19 ,
px_asset_fin_rec.global_attribute20 ,
px_asset_fin_rec.global_attribute_category ,
px_asset_fin_rec.salvage_type ,
px_asset_fin_rec.deprn_limit_type ,
px_asset_fin_rec.over_depreciate_option ,
px_asset_fin_rec.super_group_id ,
px_asset_fin_rec.reduction_rate ,
px_asset_fin_rec.reduce_addition_flag ,
px_asset_fin_rec.reduce_adjustment_flag ,
px_asset_fin_rec.reduce_retirement_flag ,
px_asset_fin_rec.recognize_gain_loss ,
px_asset_fin_rec.recapture_reserve_flag ,
px_asset_fin_rec.limit_proceeds_flag ,
px_asset_fin_rec.terminal_gain_loss ,
px_asset_fin_rec.tracking_method ,
px_asset_fin_rec.allocate_to_fully_rsv_flag ,
px_asset_fin_rec.allocate_to_fully_ret_flag ,
px_asset_fin_rec.exclude_fully_rsv_flag ,
px_asset_fin_rec.excess_allocation_option ,
px_asset_fin_rec.depreciation_option ,
px_asset_fin_rec.member_rollup_flag ,
px_asset_fin_rec.ytd_proceeds ,
px_asset_fin_rec.ltd_proceeds ,
px_asset_fin_rec.eofy_reserve ,
px_asset_fin_rec.cip_cost ,
px_asset_fin_rec.terminal_gain_loss_amount ,
px_asset_fin_rec.ltd_cost_of_removal ,
px_asset_fin_rec.exclude_proceeds_from_basis ,
px_asset_fin_rec.retirement_deprn_option ,
px_asset_fin_rec.contract_id -- Bug:6021567
from fa_books_mrc_v
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id_in = p_transaction_header_id;
select date_placed_in_service ,
deprn_start_date ,
deprn_method_code ,
life_in_months ,
rate_adjustment_factor ,
adjusted_cost ,
cost ,
original_cost ,
salvage_value ,
prorate_convention_code ,
prorate_date ,
cost_change_flag ,
adjustment_required_status ,
capitalize_flag ,
retirement_pending_flag ,
depreciate_flag ,
disabled_flag , /* HH group ed */
itc_amount_id ,
itc_amount ,
retirement_id ,
tax_request_id ,
itc_basis ,
basic_rate ,
adjusted_rate ,
bonus_rule ,
ceiling_name ,
recoverable_cost ,
adjusted_capacity ,
fully_rsvd_revals_counter ,
idled_flag ,
period_counter_capitalized ,
period_counter_fully_reserved ,
period_counter_fully_retired ,
production_capacity ,
reval_amortization_basis ,
reval_ceiling ,
unit_of_measure ,
unrevalued_cost ,
annual_deprn_rounding_flag ,
percent_salvage_value ,
allowed_deprn_limit ,
allowed_deprn_limit_amount ,
period_counter_life_complete ,
adjusted_recoverable_cost ,
annual_rounding_flag ,
eofy_adj_cost ,
eofy_formula_factor ,
short_fiscal_year_flag ,
conversion_date ,
ORIGINAL_DEPRN_START_DATE ,
remaining_life1 ,
remaining_life2 ,
group_asset_id ,
old_adjusted_cost ,
formula_factor ,
global_attribute1 ,
global_attribute2 ,
global_attribute3 ,
global_attribute4 ,
global_attribute5 ,
global_attribute6 ,
global_attribute7 ,
global_attribute8 ,
global_attribute9 ,
global_attribute10 ,
global_attribute11 ,
global_attribute12 ,
global_attribute13 ,
global_attribute14 ,
global_attribute15 ,
global_attribute16 ,
global_attribute17 ,
global_attribute18 ,
global_attribute19 ,
global_attribute20 ,
global_attribute_category ,
salvage_type ,
deprn_limit_type ,
over_depreciate_option ,
super_group_id ,
reduction_rate ,
reduce_addition_flag ,
reduce_adjustment_flag ,
reduce_retirement_flag ,
recognize_gain_loss ,
recapture_reserve_flag ,
limit_proceeds_flag ,
terminal_gain_loss ,
tracking_method ,
allocate_to_fully_rsv_flag ,
allocate_to_fully_ret_flag ,
exclude_fully_rsv_flag ,
excess_allocation_option ,
depreciation_option ,
member_rollup_flag ,
ytd_proceeds ,
ltd_proceeds ,
eofy_reserve ,
cip_cost ,
terminal_gain_loss_amount ,
ltd_cost_of_removal ,
exclude_proceeds_from_basis ,
retirement_deprn_option ,
contract_id , -- Bug:6021567
extended_deprn_flag , -- Japan Tax phase3
extended_depreciation_period , -- Japan Tax phase3
period_counter_fully_extended -- Japan Tax phase3
into px_asset_fin_rec.date_placed_in_service ,
px_asset_fin_rec.deprn_start_date ,
px_asset_fin_rec.deprn_method_code ,
px_asset_fin_rec.life_in_months ,
px_asset_fin_rec.rate_adjustment_factor ,
px_asset_fin_rec.adjusted_cost ,
px_asset_fin_rec.cost ,
px_asset_fin_rec.original_cost ,
px_asset_fin_rec.salvage_value ,
px_asset_fin_rec.prorate_convention_code ,
px_asset_fin_rec.prorate_date ,
px_asset_fin_rec.cost_change_flag ,
px_asset_fin_rec.adjustment_required_status ,
px_asset_fin_rec.capitalize_flag ,
px_asset_fin_rec.retirement_pending_flag ,
px_asset_fin_rec.depreciate_flag ,
px_asset_fin_rec.disabled_flag , /* HH group ed */
px_asset_fin_rec.itc_amount_id ,
px_asset_fin_rec.itc_amount ,
px_asset_fin_rec.retirement_id ,
px_asset_fin_rec.tax_request_id ,
px_asset_fin_rec.itc_basis ,
px_asset_fin_rec.basic_rate ,
px_asset_fin_rec.adjusted_rate ,
px_asset_fin_rec.bonus_rule ,
px_asset_fin_rec.ceiling_name ,
px_asset_fin_rec.recoverable_cost ,
px_asset_fin_rec.adjusted_capacity ,
px_asset_fin_rec.fully_rsvd_revals_counter ,
px_asset_fin_rec.idled_flag ,
px_asset_fin_rec.period_counter_capitalized ,
px_asset_fin_rec.period_counter_fully_reserved ,
px_asset_fin_rec.period_counter_fully_retired ,
px_asset_fin_rec.production_capacity ,
px_asset_fin_rec.reval_amortization_basis ,
px_asset_fin_rec.reval_ceiling ,
px_asset_fin_rec.unit_of_measure ,
px_asset_fin_rec.unrevalued_cost ,
px_asset_fin_rec.annual_deprn_rounding_flag ,
px_asset_fin_rec.percent_salvage_value ,
px_asset_fin_rec.allowed_deprn_limit ,
px_asset_fin_rec.allowed_deprn_limit_amount ,
px_asset_fin_rec.period_counter_life_complete ,
px_asset_fin_rec.adjusted_recoverable_cost ,
px_asset_fin_rec.annual_rounding_flag ,
px_asset_fin_rec.eofy_adj_cost ,
px_asset_fin_rec.eofy_formula_factor ,
px_asset_fin_rec.short_fiscal_year_flag ,
px_asset_fin_rec.conversion_date ,
px_asset_fin_rec.orig_deprn_start_date ,
px_asset_fin_rec.remaining_life1 ,
px_asset_fin_rec.remaining_life2 ,
px_asset_fin_rec.group_asset_id ,
px_asset_fin_rec.old_adjusted_cost ,
px_asset_fin_rec.formula_factor ,
px_asset_fin_rec.global_attribute1 ,
px_asset_fin_rec.global_attribute2 ,
px_asset_fin_rec.global_attribute3 ,
px_asset_fin_rec.global_attribute4 ,
px_asset_fin_rec.global_attribute5 ,
px_asset_fin_rec.global_attribute6 ,
px_asset_fin_rec.global_attribute7 ,
px_asset_fin_rec.global_attribute8 ,
px_asset_fin_rec.global_attribute9 ,
px_asset_fin_rec.global_attribute10 ,
px_asset_fin_rec.global_attribute11 ,
px_asset_fin_rec.global_attribute12 ,
px_asset_fin_rec.global_attribute13 ,
px_asset_fin_rec.global_attribute14 ,
px_asset_fin_rec.global_attribute15 ,
px_asset_fin_rec.global_attribute16 ,
px_asset_fin_rec.global_attribute17 ,
px_asset_fin_rec.global_attribute18 ,
px_asset_fin_rec.global_attribute19 ,
px_asset_fin_rec.global_attribute20 ,
px_asset_fin_rec.global_attribute_category ,
px_asset_fin_rec.salvage_type ,
px_asset_fin_rec.deprn_limit_type ,
px_asset_fin_rec.over_depreciate_option ,
px_asset_fin_rec.super_group_id ,
px_asset_fin_rec.reduction_rate ,
px_asset_fin_rec.reduce_addition_flag ,
px_asset_fin_rec.reduce_adjustment_flag ,
px_asset_fin_rec.reduce_retirement_flag ,
px_asset_fin_rec.recognize_gain_loss ,
px_asset_fin_rec.recapture_reserve_flag ,
px_asset_fin_rec.limit_proceeds_flag ,
px_asset_fin_rec.terminal_gain_loss ,
px_asset_fin_rec.tracking_method ,
px_asset_fin_rec.allocate_to_fully_rsv_flag ,
px_asset_fin_rec.allocate_to_fully_ret_flag ,
px_asset_fin_rec.exclude_fully_rsv_flag ,
px_asset_fin_rec.excess_allocation_option ,
px_asset_fin_rec.depreciation_option ,
px_asset_fin_rec.member_rollup_flag ,
px_asset_fin_rec.ytd_proceeds ,
px_asset_fin_rec.ltd_proceeds ,
px_asset_fin_rec.eofy_reserve ,
px_asset_fin_rec.cip_cost ,
px_asset_fin_rec.terminal_gain_loss_amount ,
px_asset_fin_rec.ltd_cost_of_removal ,
px_asset_fin_rec.exclude_proceeds_from_basis ,
px_asset_fin_rec.retirement_deprn_option ,
px_asset_fin_rec.contract_id , -- Bug:6021567
px_asset_fin_rec.extended_deprn_flag , -- Japan Tax phase3
px_asset_fin_rec.extended_depreciation_period , -- Japan Tax phase3
px_asset_fin_rec.period_counter_fully_extended -- Japan Tax phase3
from fa_books
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id_in = p_transaction_header_id;
select ah.category_id,
ad.asset_category_id,
ad.ATTRIBUTE1 ,
ad.ATTRIBUTE2 ,
ad.ATTRIBUTE3 ,
ad.ATTRIBUTE4 ,
ad.ATTRIBUTE5 ,
ad.ATTRIBUTE6 ,
ad.ATTRIBUTE7 ,
ad.ATTRIBUTE8 ,
ad.ATTRIBUTE9 ,
ad.ATTRIBUTE10,
ad.ATTRIBUTE11,
ad.ATTRIBUTE12,
ad.ATTRIBUTE13,
ad.ATTRIBUTE14,
ad.ATTRIBUTE15,
ad.ATTRIBUTE16,
ad.ATTRIBUTE17,
ad.ATTRIBUTE18,
ad.ATTRIBUTE19,
ad.ATTRIBUTE20,
ad.ATTRIBUTE21,
ad.ATTRIBUTE22,
ad.ATTRIBUTE23,
ad.ATTRIBUTE24,
ad.ATTRIBUTE25,
ad.ATTRIBUTE26,
ad.ATTRIBUTE27,
ad.ATTRIBUTE28,
ad.ATTRIBUTE29,
ad.ATTRIBUTE30,
ad.ATTRIBUTE_CATEGORY_CODE,
ad.CONTEXT
into px_asset_cat_rec.category_id,
l_asset_category_id,
px_asset_cat_rec.desc_flex.attribute1,
px_asset_cat_rec.desc_flex.attribute2,
px_asset_cat_rec.desc_flex.attribute3,
px_asset_cat_rec.desc_flex.attribute4,
px_asset_cat_rec.desc_flex.attribute5,
px_asset_cat_rec.desc_flex.attribute6,
px_asset_cat_rec.desc_flex.attribute7,
px_asset_cat_rec.desc_flex.attribute8,
px_asset_cat_rec.desc_flex.attribute9,
px_asset_cat_rec.desc_flex.attribute10,
px_asset_cat_rec.desc_flex.attribute11,
px_asset_cat_rec.desc_flex.attribute12,
px_asset_cat_rec.desc_flex.attribute13,
px_asset_cat_rec.desc_flex.attribute14,
px_asset_cat_rec.desc_flex.attribute15,
px_asset_cat_rec.desc_flex.attribute16,
px_asset_cat_rec.desc_flex.attribute17,
px_asset_cat_rec.desc_flex.attribute18,
px_asset_cat_rec.desc_flex.attribute19,
px_asset_cat_rec.desc_flex.attribute20,
px_asset_cat_rec.desc_flex.attribute21,
px_asset_cat_rec.desc_flex.attribute22,
px_asset_cat_rec.desc_flex.attribute23,
px_asset_cat_rec.desc_flex.attribute24,
px_asset_cat_rec.desc_flex.attribute25,
px_asset_cat_rec.desc_flex.attribute26,
px_asset_cat_rec.desc_flex.attribute27,
px_asset_cat_rec.desc_flex.attribute28,
px_asset_cat_rec.desc_flex.attribute29,
px_asset_cat_rec.desc_flex.attribute30,
px_asset_cat_rec.desc_flex.attribute_category_code,
px_asset_cat_rec.desc_flex.context
from fa_additions_b ad,
fa_asset_history ah
where ad.asset_id = p_asset_hdr_rec.asset_id
and ad.asset_id = ah.asset_id
and ((p_date_effective is null and
ah.date_ineffective is null) or
(p_date_effective is not null and
p_date_effective between
ah.date_effective and nvl(ah.date_ineffective, sysdate)));
select ah.asset_type
into px_asset_type_rec.asset_type
from fa_additions_b ad,
fa_asset_history ah
where ad.asset_id = p_asset_hdr_rec.asset_id
and ad.asset_id = ah.asset_id
and (ah.date_effective = nvl(p_date_effective, to_date('01/01/0001', 'DD/MM/YYYY')) or
ah.date_ineffective is null);
select asset_number ,
description ,
tag_number ,
serial_number ,
asset_key_ccid ,
parent_asset_id ,
attribute15 , -- status ,
manufacturer_name ,
model_number ,
null , -- warranty_number ,
lease_id ,
in_use_flag ,
inventorial ,
property_type_code ,
property_1245_1250_code ,
owned_leased ,
new_used ,
current_units ,
unit_adjustment_flag ,
add_cost_je_flag ,
null, -- ls_attribute1 ,
null, -- ls_attribute2 ,
null, -- ls_attribute3 ,
null, -- ls_attribute4 ,
null, -- ls_attribute5 ,
null, -- ls_attribute6 ,
null, -- ls_attribute7 ,
null, -- ls_attribute8 ,
null, -- ls_attribute9 ,
null, -- ls_attribute10 ,
null, -- ls_attribute11 ,
null, -- ls_attribute12 ,
null, -- ls_attribute13 ,
null, -- ls_attribute14 ,
null, -- ls_attribute15 ,
null, -- ls_attribute_category_code,
global_attribute1 ,
global_attribute2 ,
global_attribute3 ,
global_attribute4 ,
global_attribute5 ,
global_attribute6 ,
global_attribute7 ,
global_attribute8 ,
global_attribute9 ,
global_attribute10 ,
global_attribute11 ,
global_attribute12 ,
global_attribute13 ,
global_attribute14 ,
global_attribute15 ,
global_attribute16 ,
global_attribute17 ,
global_attribute18 ,
global_attribute19 ,
global_attribute20 ,
global_attribute_category,
commitment, -- Bug:5372429
investment_law -- Bug:5372429
into px_asset_desc_rec.asset_number ,
px_asset_desc_rec.description ,
px_asset_desc_rec.tag_number ,
px_asset_desc_rec.serial_number ,
px_asset_desc_rec.asset_key_ccid ,
px_asset_desc_rec.parent_asset_id ,
px_asset_desc_rec.status ,
px_asset_desc_rec.manufacturer_name ,
px_asset_desc_rec.model_number ,
px_asset_desc_rec.warranty_id ,
px_asset_desc_rec.lease_id ,
px_asset_desc_rec.in_use_flag ,
px_asset_desc_rec.inventorial ,
px_asset_desc_rec.property_type_code ,
px_asset_desc_rec.property_1245_1250_code,
px_asset_desc_rec.owned_leased ,
px_asset_desc_rec.new_used ,
px_asset_desc_rec.current_units ,
px_asset_desc_rec.unit_adjustment_flag ,
px_asset_desc_rec.add_cost_je_flag ,
px_asset_desc_rec.lease_desc_flex.attribute1,
px_asset_desc_rec.lease_desc_flex.attribute2,
px_asset_desc_rec.lease_desc_flex.attribute3,
px_asset_desc_rec.lease_desc_flex.attribute4,
px_asset_desc_rec.lease_desc_flex.attribute5,
px_asset_desc_rec.lease_desc_flex.attribute6,
px_asset_desc_rec.lease_desc_flex.attribute7,
px_asset_desc_rec.lease_desc_flex.attribute8,
px_asset_desc_rec.lease_desc_flex.attribute9,
px_asset_desc_rec.lease_desc_flex.attribute10,
px_asset_desc_rec.lease_desc_flex.attribute11,
px_asset_desc_rec.lease_desc_flex.attribute12,
px_asset_desc_rec.lease_desc_flex.attribute13,
px_asset_desc_rec.lease_desc_flex.attribute14,
px_asset_desc_rec.lease_desc_flex.attribute15,
px_asset_desc_rec.lease_desc_flex.attribute_category_code,
px_asset_desc_rec.global_desc_flex.attribute1,
px_asset_desc_rec.global_desc_flex.attribute2,
px_asset_desc_rec.global_desc_flex.attribute3,
px_asset_desc_rec.global_desc_flex.attribute4,
px_asset_desc_rec.global_desc_flex.attribute5,
px_asset_desc_rec.global_desc_flex.attribute6,
px_asset_desc_rec.global_desc_flex.attribute7,
px_asset_desc_rec.global_desc_flex.attribute8,
px_asset_desc_rec.global_desc_flex.attribute9,
px_asset_desc_rec.global_desc_flex.attribute10,
px_asset_desc_rec.global_desc_flex.attribute11,
px_asset_desc_rec.global_desc_flex.attribute12,
px_asset_desc_rec.global_desc_flex.attribute13,
px_asset_desc_rec.global_desc_flex.attribute14,
px_asset_desc_rec.global_desc_flex.attribute15,
px_asset_desc_rec.global_desc_flex.attribute16,
px_asset_desc_rec.global_desc_flex.attribute17,
px_asset_desc_rec.global_desc_flex.attribute18,
px_asset_desc_rec.global_desc_flex.attribute19,
px_asset_desc_rec.global_desc_flex.attribute20,
px_asset_desc_rec.global_desc_flex.attribute_category_code,
px_asset_desc_rec.commitment, -- Bug:5372429
px_asset_desc_rec.investment_law -- Bug:5372429
from fa_additions_vl
where asset_id = p_asset_hdr_rec.asset_id;
select attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category_code
into px_asset_desc_rec.lease_desc_flex.attribute1,
px_asset_desc_rec.lease_desc_flex.attribute2,
px_asset_desc_rec.lease_desc_flex.attribute3,
px_asset_desc_rec.lease_desc_flex.attribute4,
px_asset_desc_rec.lease_desc_flex.attribute5,
px_asset_desc_rec.lease_desc_flex.attribute6,
px_asset_desc_rec.lease_desc_flex.attribute7,
px_asset_desc_rec.lease_desc_flex.attribute8,
px_asset_desc_rec.lease_desc_flex.attribute9,
px_asset_desc_rec.lease_desc_flex.attribute10,
px_asset_desc_rec.lease_desc_flex.attribute11,
px_asset_desc_rec.lease_desc_flex.attribute12,
px_asset_desc_rec.lease_desc_flex.attribute13,
px_asset_desc_rec.lease_desc_flex.attribute14,
px_asset_desc_rec.lease_desc_flex.attribute15,
px_asset_desc_rec.lease_desc_flex.attribute_category_code
from fa_leases
where lease_id = px_asset_desc_rec.lease_id;
select warranty_id
into px_asset_desc_rec.warranty_id
from fa_add_warranties
where asset_id = p_asset_hdr_rec.asset_id
and date_ineffective is NULL;
select Po_Vendor_Id ,
Asset_Invoice_Id ,
Fixed_Assets_Cost , --
Deleted_Flag , --
Po_Number ,
Invoice_Number ,
Payables_Batch_Name ,
Payables_Code_Combination_Id ,
Feeder_System_Name ,
Create_Batch_Date ,
Create_Batch_Id ,
Invoice_Date ,
Payables_Cost , --
Post_Batch_Id ,
Invoice_Id ,
Ap_Distribution_Line_Number ,
Payables_Units ,
Split_Merged_Code ,
Description ,
Parent_Mass_Addition_Id ,
Attribute1 ,
Attribute2 ,
Attribute3 ,
Attribute4 ,
Attribute5 ,
Attribute6 ,
Attribute7 ,
Attribute8 ,
Attribute9 ,
Attribute10 ,
Attribute11 ,
Attribute12 ,
Attribute13 ,
Attribute14 ,
Attribute15 ,
Attribute_Category_Code ,
Unrevalued_Cost , --
Merged_Code ,
Split_Code ,
Merge_Parent_Mass_Additions_Id ,
Split_Parent_Mass_Additions_Id ,
Project_Asset_Line_Id ,
Project_Id ,
Task_Id ,
Depreciate_In_Group_Flag ,
Material_Indicator_Flag ,
NULL
into px_inv_rec.Po_Vendor_Id ,
px_inv_rec.Asset_Invoice_Id ,
px_inv_rec.Fixed_Assets_Cost ,
px_inv_rec.Deleted_Flag ,
px_inv_rec.Po_Number ,
px_inv_rec.Invoice_Number ,
px_inv_rec.Payables_Batch_Name ,
px_inv_rec.Payables_Code_Combination_Id ,
px_inv_rec.Feeder_System_Name ,
px_inv_rec.Create_Batch_Date ,
px_inv_rec.Create_Batch_Id ,
px_inv_rec.Invoice_Date ,
px_inv_rec.Payables_Cost ,
px_inv_rec.Post_Batch_Id ,
px_inv_rec.Invoice_Id ,
px_inv_rec.Ap_Distribution_Line_Number ,
px_inv_rec.Payables_Units ,
px_inv_rec.Split_Merged_Code ,
px_inv_rec.Description ,
px_inv_rec.Parent_Mass_Addition_Id ,
px_inv_rec.Attribute1 ,
px_inv_rec.Attribute2 ,
px_inv_rec.Attribute3 ,
px_inv_rec.Attribute4 ,
px_inv_rec.Attribute5 ,
px_inv_rec.Attribute6 ,
px_inv_rec.Attribute7 ,
px_inv_rec.Attribute8 ,
px_inv_rec.Attribute9 ,
px_inv_rec.Attribute10 ,
px_inv_rec.Attribute11 ,
px_inv_rec.Attribute12 ,
px_inv_rec.Attribute13 ,
px_inv_rec.Attribute14 ,
px_inv_rec.Attribute15 ,
px_inv_rec.Attribute_Category_Code ,
px_inv_rec.Unrevalued_Cost ,
px_inv_rec.Merged_Code ,
px_inv_rec.Split_Code ,
px_inv_rec.Merge_Parent_Mass_Additions_Id ,
px_inv_rec.Split_Parent_Mass_Additions_Id ,
px_inv_rec.Project_Asset_Line_Id ,
px_inv_rec.Project_Id ,
px_inv_rec.Task_Id ,
px_inv_rec.Depreciate_In_Group_Flag ,
px_inv_rec.Material_Indicator_Flag ,
px_inv_rec.prior_source_line_id
from fa_asset_invoices_mrc_v ai,
fa_invoice_transactions it
where ai.source_line_id = px_inv_rec.source_line_id
and it.invoice_transaction_id = ai.invoice_transaction_id_in
and it.transaction_type = 'RETIREMENT';
select Po_Vendor_Id ,
Asset_Invoice_Id ,
Fixed_Assets_Cost , --
Deleted_Flag , --
Po_Number ,
Invoice_Number ,
Payables_Batch_Name ,
Payables_Code_Combination_Id ,
Feeder_System_Name ,
Create_Batch_Date ,
Create_Batch_Id ,
Invoice_Date ,
Payables_Cost , --
Post_Batch_Id ,
Invoice_Id ,
Ap_Distribution_Line_Number ,
Payables_Units ,
Split_Merged_Code ,
Description ,
Parent_Mass_Addition_Id ,
Attribute1 ,
Attribute2 ,
Attribute3 ,
Attribute4 ,
Attribute5 ,
Attribute6 ,
Attribute7 ,
Attribute8 ,
Attribute9 ,
Attribute10 ,
Attribute11 ,
Attribute12 ,
Attribute13 ,
Attribute14 ,
Attribute15 ,
Attribute_Category_Code ,
Unrevalued_Cost , --
Merged_Code ,
Split_Code ,
Merge_Parent_Mass_Additions_Id ,
Split_Parent_Mass_Additions_Id ,
Project_Asset_Line_Id ,
Project_Id ,
Task_Id ,
Source_Line_ID ,
Depreciate_In_Group_Flag ,
Material_Indicator_Flag ,
NULL
into px_inv_rec.Po_Vendor_Id ,
px_inv_rec.Asset_Invoice_Id ,
px_inv_rec.Fixed_Assets_Cost ,
px_inv_rec.Deleted_Flag ,
px_inv_rec.Po_Number ,
px_inv_rec.Invoice_Number ,
px_inv_rec.Payables_Batch_Name ,
px_inv_rec.Payables_Code_Combination_Id ,
px_inv_rec.Feeder_System_Name ,
px_inv_rec.Create_Batch_Date ,
px_inv_rec.Create_Batch_Id ,
px_inv_rec.Invoice_Date ,
px_inv_rec.Payables_Cost ,
px_inv_rec.Post_Batch_Id ,
px_inv_rec.Invoice_Id ,
px_inv_rec.Ap_Distribution_Line_Number ,
px_inv_rec.Payables_Units ,
px_inv_rec.Split_Merged_Code ,
px_inv_rec.Description ,
px_inv_rec.Parent_Mass_Addition_Id ,
px_inv_rec.Attribute1 ,
px_inv_rec.Attribute2 ,
px_inv_rec.Attribute3 ,
px_inv_rec.Attribute4 ,
px_inv_rec.Attribute5 ,
px_inv_rec.Attribute6 ,
px_inv_rec.Attribute7 ,
px_inv_rec.Attribute8 ,
px_inv_rec.Attribute9 ,
px_inv_rec.Attribute10 ,
px_inv_rec.Attribute11 ,
px_inv_rec.Attribute12 ,
px_inv_rec.Attribute13 ,
px_inv_rec.Attribute14 ,
px_inv_rec.Attribute15 ,
px_inv_rec.Attribute_Category_Code ,
px_inv_rec.Unrevalued_Cost ,
px_inv_rec.Merged_Code ,
px_inv_rec.Split_Code ,
px_inv_rec.Merge_Parent_Mass_Additions_Id ,
px_inv_rec.Split_Parent_Mass_Additions_Id ,
px_inv_rec.Project_Asset_Line_Id ,
px_inv_rec.Project_Id ,
px_inv_rec.Task_Id ,
px_inv_rec.Source_Line_Id ,
px_inv_rec.Depreciate_In_Group_Flag ,
px_inv_rec.Material_Indicator_Flag ,
px_inv_rec.Prior_Source_Line_ID
from fa_asset_invoices ai,
fa_invoice_transactions it
where ai.source_line_id = px_inv_rec.source_line_id
and it.invoice_transaction_id = ai.invoice_transaction_id_in
and it.transaction_type = 'RETIREMENT';
select Po_Vendor_Id ,
Asset_Invoice_Id ,
Fixed_Assets_Cost , --
Deleted_Flag , --
Po_Number ,
Invoice_Number ,
Payables_Batch_Name ,
Payables_Code_Combination_Id ,
Feeder_System_Name ,
Create_Batch_Date ,
Create_Batch_Id ,
Invoice_Date ,
Payables_Cost , --
Post_Batch_Id ,
Invoice_Id ,
Ap_Distribution_Line_Number ,
Payables_Units ,
Split_Merged_Code ,
Description ,
Parent_Mass_Addition_Id ,
Attribute1 ,
Attribute2 ,
Attribute3 ,
Attribute4 ,
Attribute5 ,
Attribute6 ,
Attribute7 ,
Attribute8 ,
Attribute9 ,
Attribute10 ,
Attribute11 ,
Attribute12 ,
Attribute13 ,
Attribute14 ,
Attribute15 ,
Attribute_Category_Code ,
Unrevalued_Cost , --
Merged_Code ,
Split_Code ,
Merge_Parent_Mass_Additions_Id ,
Split_Parent_Mass_Additions_Id ,
Project_Asset_Line_Id ,
Project_Id ,
Task_Id ,
Depreciate_In_Group_Flag ,
Material_Indicator_Flag ,
NULL
into px_inv_rec.Po_Vendor_Id ,
px_inv_rec.Asset_Invoice_Id ,
px_inv_rec.Fixed_Assets_Cost ,
px_inv_rec.Deleted_Flag ,
px_inv_rec.Po_Number ,
px_inv_rec.Invoice_Number ,
px_inv_rec.Payables_Batch_Name ,
px_inv_rec.Payables_Code_Combination_Id ,
px_inv_rec.Feeder_System_Name ,
px_inv_rec.Create_Batch_Date ,
px_inv_rec.Create_Batch_Id ,
px_inv_rec.Invoice_Date ,
px_inv_rec.Payables_Cost ,
px_inv_rec.Post_Batch_Id ,
px_inv_rec.Invoice_Id ,
px_inv_rec.Ap_Distribution_Line_Number ,
px_inv_rec.Payables_Units ,
px_inv_rec.Split_Merged_Code ,
px_inv_rec.Description ,
px_inv_rec.Parent_Mass_Addition_Id ,
px_inv_rec.Attribute1 ,
px_inv_rec.Attribute2 ,
px_inv_rec.Attribute3 ,
px_inv_rec.Attribute4 ,
px_inv_rec.Attribute5 ,
px_inv_rec.Attribute6 ,
px_inv_rec.Attribute7 ,
px_inv_rec.Attribute8 ,
px_inv_rec.Attribute9 ,
px_inv_rec.Attribute10 ,
px_inv_rec.Attribute11 ,
px_inv_rec.Attribute12 ,
px_inv_rec.Attribute13 ,
px_inv_rec.Attribute14 ,
px_inv_rec.Attribute15 ,
px_inv_rec.Attribute_Category_Code ,
px_inv_rec.Unrevalued_Cost ,
px_inv_rec.Merged_Code ,
px_inv_rec.Split_Code ,
px_inv_rec.Merge_Parent_Mass_Additions_Id ,
px_inv_rec.Split_Parent_Mass_Additions_Id ,
px_inv_rec.Project_Asset_Line_Id ,
px_inv_rec.Project_Id ,
px_inv_rec.Task_Id ,
px_inv_rec.Depreciate_In_Group_Flag ,
px_inv_rec.Material_Indicator_Flag ,
px_inv_rec.prior_source_line_id
from fa_asset_invoices_mrc_v
where source_line_id = px_inv_rec.source_line_id
and date_ineffective is null;
select Po_Vendor_Id ,
Asset_Invoice_Id ,
Fixed_Assets_Cost , --
Deleted_Flag , --
Po_Number ,
Invoice_Number ,
Payables_Batch_Name ,
Payables_Code_Combination_Id ,
Feeder_System_Name ,
Create_Batch_Date ,
Create_Batch_Id ,
Invoice_Date ,
Payables_Cost , --
Post_Batch_Id ,
Invoice_Id ,
Ap_Distribution_Line_Number ,
Payables_Units ,
Split_Merged_Code ,
Description ,
Parent_Mass_Addition_Id ,
Attribute1 ,
Attribute2 ,
Attribute3 ,
Attribute4 ,
Attribute5 ,
Attribute6 ,
Attribute7 ,
Attribute8 ,
Attribute9 ,
Attribute10 ,
Attribute11 ,
Attribute12 ,
Attribute13 ,
Attribute14 ,
Attribute15 ,
Attribute_Category_Code ,
Unrevalued_Cost , --
Merged_Code ,
Split_Code ,
Merge_Parent_Mass_Additions_Id ,
Split_Parent_Mass_Additions_Id ,
Project_Asset_Line_Id ,
Project_Id ,
Task_Id ,
Source_Line_ID ,
Depreciate_In_Group_Flag ,
Material_Indicator_Flag ,
NULL
into px_inv_rec.Po_Vendor_Id ,
px_inv_rec.Asset_Invoice_Id ,
px_inv_rec.Fixed_Assets_Cost ,
px_inv_rec.Deleted_Flag ,
px_inv_rec.Po_Number ,
px_inv_rec.Invoice_Number ,
px_inv_rec.Payables_Batch_Name ,
px_inv_rec.Payables_Code_Combination_Id ,
px_inv_rec.Feeder_System_Name ,
px_inv_rec.Create_Batch_Date ,
px_inv_rec.Create_Batch_Id ,
px_inv_rec.Invoice_Date ,
px_inv_rec.Payables_Cost ,
px_inv_rec.Post_Batch_Id ,
px_inv_rec.Invoice_Id ,
px_inv_rec.Ap_Distribution_Line_Number ,
px_inv_rec.Payables_Units ,
px_inv_rec.Split_Merged_Code ,
px_inv_rec.Description ,
px_inv_rec.Parent_Mass_Addition_Id ,
px_inv_rec.Attribute1 ,
px_inv_rec.Attribute2 ,
px_inv_rec.Attribute3 ,
px_inv_rec.Attribute4 ,
px_inv_rec.Attribute5 ,
px_inv_rec.Attribute6 ,
px_inv_rec.Attribute7 ,
px_inv_rec.Attribute8 ,
px_inv_rec.Attribute9 ,
px_inv_rec.Attribute10 ,
px_inv_rec.Attribute11 ,
px_inv_rec.Attribute12 ,
px_inv_rec.Attribute13 ,
px_inv_rec.Attribute14 ,
px_inv_rec.Attribute15 ,
px_inv_rec.Attribute_Category_Code ,
px_inv_rec.Unrevalued_Cost ,
px_inv_rec.Merged_Code ,
px_inv_rec.Split_Code ,
px_inv_rec.Merge_Parent_Mass_Additions_Id ,
px_inv_rec.Split_Parent_Mass_Additions_Id ,
px_inv_rec.Project_Asset_Line_Id ,
px_inv_rec.Project_Id ,
px_inv_rec.Task_Id ,
px_inv_rec.Source_Line_Id ,
px_inv_rec.Depreciate_In_Group_Flag ,
px_inv_rec.Material_Indicator_Flag ,
px_inv_rec.Prior_Source_Line_ID
from fa_asset_invoices
where source_line_id = px_inv_rec.source_line_id
and date_ineffective is null;
select 1
from fnd_id_flex_segments
where application_id = 140
and id_flex_code = 'KEY#'
and id_flex_num = p_asset_key_chart_id
and required_flag = 'Y';
select units
into x_current_units
from fa_asset_history
where asset_id = p_asset_id
and date_ineffective is null;
value1 => 'SELECT',
token2 => 'TABLE',
value2 => 'FA_ASSET_HISTORY'
,p_log_level_rec => p_log_level_rec);
select max(transaction_date_entered)
into x_latest_trans_date
from fa_transaction_headers
where asset_id = p_asset_id
and book_type_code = p_book
and transaction_type_code not in ('REINSTATEMENT','FULL RETIREMENT')
and transaction_type_code not like '%/VOID';
select max(transaction_date_entered)
into x_latest_trans_date
from fa_transaction_headers
where asset_id = p_asset_id
and book_type_code = p_book
and transaction_type_code in ('TAX', 'REVALUATION');
value1 => 'SELECT',
token2 => 'TABLE',
value2 => 'FA_TRANSACTION_HEADERS'
,p_log_level_rec => p_log_level_rec);
select retirement_id
,asset_id
,book_type_code
,transaction_header_id_in
,date_retired
,cost_retired
,status
,retirement_prorate_convention
,transaction_header_id_out
,units
,cost_of_removal
,nbv_retired
,gain_loss_amount
,proceeds_of_sale
,gain_loss_type_code
,retirement_type_code
,itc_recaptured
,itc_recapture_id
,reference_num
,sold_to
,trade_in_asset_id
,stl_method_code
,stl_life_in_months
,stl_deprn_amount
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute_category_code
,reval_reserve_retired
,unrevalued_cost_retired
,bonus_reserve_retired
,recognize_gain_loss
,recapture_reserve_flag
,limit_proceeds_flag
,terminal_gain_loss
,reserve_retired
,eofy_reserve
,reduction_rate
,recapture_amount
,rowid
into
px_asset_retire_rec.retirement_id
,px_asset_retire_rec.detail_info.asset_id
,px_asset_retire_rec.detail_info.book_type_code
,px_asset_retire_rec.detail_info.transaction_header_id_in
,px_asset_retire_rec.date_retired
,px_asset_retire_rec.cost_retired
,px_asset_retire_rec.status
,px_asset_retire_rec.retirement_prorate_convention
,px_asset_retire_rec.detail_info.transaction_header_id_out
,px_asset_retire_rec.units_retired
,px_asset_retire_rec.cost_of_removal
,px_asset_retire_rec.detail_info.nbv_retired
,px_asset_retire_rec.detail_info.gain_loss_amount
,px_asset_retire_rec.proceeds_of_sale
,px_asset_retire_rec.detail_info.gain_loss_type_code
,px_asset_retire_rec.retirement_type_code
,px_asset_retire_rec.detail_info.itc_recaptured
,px_asset_retire_rec.detail_info.itc_recapture_id
,px_asset_retire_rec.reference_num
,px_asset_retire_rec.sold_to
,px_asset_retire_rec.trade_in_asset_id
,px_asset_retire_rec.detail_info.stl_method_code
,px_asset_retire_rec.detail_info.stl_life_in_months
,px_asset_retire_rec.detail_info.stl_deprn_amount
,px_asset_retire_rec.desc_flex.attribute1
,px_asset_retire_rec.desc_flex.attribute2
,px_asset_retire_rec.desc_flex.attribute3
,px_asset_retire_rec.desc_flex.attribute4
,px_asset_retire_rec.desc_flex.attribute5
,px_asset_retire_rec.desc_flex.attribute6
,px_asset_retire_rec.desc_flex.attribute7
,px_asset_retire_rec.desc_flex.attribute8
,px_asset_retire_rec.desc_flex.attribute9
,px_asset_retire_rec.desc_flex.attribute10
,px_asset_retire_rec.desc_flex.attribute11
,px_asset_retire_rec.desc_flex.attribute12
,px_asset_retire_rec.desc_flex.attribute13
,px_asset_retire_rec.desc_flex.attribute14
,px_asset_retire_rec.desc_flex.attribute15
,px_asset_retire_rec.desc_flex.attribute_category_code
,px_asset_retire_rec.detail_info.reval_reserve_retired
,px_asset_retire_rec.detail_info.unrevalued_cost_retired
,px_asset_retire_rec.detail_info.bonus_reserve_retired
,px_asset_retire_rec.recognize_gain_loss
,px_asset_retire_rec.recapture_reserve_flag
,px_asset_retire_rec.limit_proceeds_flag
,px_asset_retire_rec.terminal_gain_loss
,px_asset_retire_rec.reserve_retired
,px_asset_retire_rec.eofy_reserve
,px_asset_retire_rec.reduction_rate
,px_asset_retire_rec.detail_info.recapture_amount
,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
from fa_retirements_mrc_v
where retirement_id = px_asset_retire_rec.retirement_id;
select retirement_id
,asset_id
,book_type_code
,transaction_header_id_in
,date_retired
,cost_retired
,status
,retirement_prorate_convention
,transaction_header_id_out
,units
,cost_of_removal
,nbv_retired
,gain_loss_amount
,proceeds_of_sale
,gain_loss_type_code
,retirement_type_code
,itc_recaptured
,itc_recapture_id
,reference_num
,sold_to
,trade_in_asset_id
,stl_method_code
,stl_life_in_months
,stl_deprn_amount
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute_category_code
,reval_reserve_retired
,unrevalued_cost_retired
,bonus_reserve_retired
,recognize_gain_loss
,recapture_reserve_flag
,limit_proceeds_flag
,terminal_gain_loss
,reserve_retired
,eofy_reserve
,reduction_rate
,recapture_amount
,rowid
into
px_asset_retire_rec.retirement_id
,px_asset_retire_rec.detail_info.asset_id
,px_asset_retire_rec.detail_info.book_type_code
,px_asset_retire_rec.detail_info.transaction_header_id_in
,px_asset_retire_rec.date_retired
,px_asset_retire_rec.cost_retired
,px_asset_retire_rec.status
,px_asset_retire_rec.retirement_prorate_convention
,px_asset_retire_rec.detail_info.transaction_header_id_out
,px_asset_retire_rec.units_retired
,px_asset_retire_rec.cost_of_removal
,px_asset_retire_rec.detail_info.nbv_retired
,px_asset_retire_rec.detail_info.gain_loss_amount
,px_asset_retire_rec.proceeds_of_sale
,px_asset_retire_rec.detail_info.gain_loss_type_code
,px_asset_retire_rec.retirement_type_code
,px_asset_retire_rec.detail_info.itc_recaptured
,px_asset_retire_rec.detail_info.itc_recapture_id
,px_asset_retire_rec.reference_num
,px_asset_retire_rec.sold_to
,px_asset_retire_rec.trade_in_asset_id
,px_asset_retire_rec.detail_info.stl_method_code
,px_asset_retire_rec.detail_info.stl_life_in_months
,px_asset_retire_rec.detail_info.stl_deprn_amount
,px_asset_retire_rec.desc_flex.attribute1
,px_asset_retire_rec.desc_flex.attribute2
,px_asset_retire_rec.desc_flex.attribute3
,px_asset_retire_rec.desc_flex.attribute4
,px_asset_retire_rec.desc_flex.attribute5
,px_asset_retire_rec.desc_flex.attribute6
,px_asset_retire_rec.desc_flex.attribute7
,px_asset_retire_rec.desc_flex.attribute8
,px_asset_retire_rec.desc_flex.attribute9
,px_asset_retire_rec.desc_flex.attribute10
,px_asset_retire_rec.desc_flex.attribute11
,px_asset_retire_rec.desc_flex.attribute12
,px_asset_retire_rec.desc_flex.attribute13
,px_asset_retire_rec.desc_flex.attribute14
,px_asset_retire_rec.desc_flex.attribute15
,px_asset_retire_rec.desc_flex.attribute_category_code
,px_asset_retire_rec.detail_info.reval_reserve_retired
,px_asset_retire_rec.detail_info.unrevalued_cost_retired
,px_asset_retire_rec.detail_info.bonus_reserve_retired
,px_asset_retire_rec.recognize_gain_loss
,px_asset_retire_rec.recapture_reserve_flag
,px_asset_retire_rec.limit_proceeds_flag
,px_asset_retire_rec.terminal_gain_loss
,px_asset_retire_rec.reserve_retired
,px_asset_retire_rec.eofy_reserve
,px_asset_retire_rec.reduction_rate
,px_asset_retire_rec.detail_info.recapture_amount
,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
from fa_retirements
where retirement_id = px_asset_retire_rec.retirement_id;
SELECT bc.book_type_code
INTO p_corp_book
FROM fa_books bks,
fa_book_controls bc
WHERE bks.book_type_code = bc.distribution_source_book
AND bks.book_type_code = bc.book_type_code
AND bks.asset_id = p_asset_id
AND bks.transaction_header_id_out is null
AND rownum < 2;
value1 => 'SELECT',
token2 => 'TABLE',
value2 => 'FA_BOOKS'
,p_log_level_rec => p_log_level_rec);
SELECT ds.deprn_amount
INTO l_deprn_amt
FROM fa_deprn_summary ds,
fa_book_controls bc
WHERE bc.book_type_code = X_book
AND ds.book_type_code = bc.book_type_code
AND ds.period_counter = bc.last_period_counter + 1
AND ds.asset_id = X_asset_id
AND ds.deprn_source_code in ('DEPRN','TRACK');
select ds.deprn_amount
into l_deprn_amt
FROM fa_deprn_summary ds,
fa_book_controls bc,
fa_books bks,
fa_additions_b ad
WHERE bc.book_type_code = X_Book
AND ds.book_type_code = bc.book_type_code
AND ds.period_counter = bc.last_period_counter + 1
AND ds.asset_id = bks.asset_id
AND ds.deprn_source_code in ('DEPRN','TRACK')
AND bks.group_asset_id = X_Asset_ID
AND bks.book_type_code = bc.book_type_code
AND bks.transaction_header_id_out is null
AND ad.asset_id = X_Asset_ID
AND ad.asset_type = 'GROUP';
SELECT ds.deprn_amount
INTO l_deprn_amt
FROM fa_mc_deprn_summary ds,
fa_book_controls bc
WHERE bc.book_type_code = X_book
AND ds.book_type_code = bc.book_type_code
AND ds.period_counter = bc.last_period_counter + 1
AND ds.asset_id = X_asset_id
AND ds.deprn_source_code in ('DEPRN','TRACK');