[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select lookup_code
from fa_lookups
where lookup_type = c_lookup_type
and enabled_flag = 'Y';
select asset_id, asset_category_id, parent_asset_id, asset_key_ccid
from fa_additions
where asset_category_id = l_category_id
and asset_key_ccid = l_asset_key_ccid;
Select MASS_ADDITION_ID,
ASSET_NUMBER,
TAG_NUMBER,
DESCRIPTION,
ASSET_CATEGORY_ID,
MANUFACTURER_NAME,
SERIAL_NUMBER,
MODEL_NUMBER,
BOOK_TYPE_CODE,
DATE_PLACED_IN_SERVICE,
FIXED_ASSETS_COST,
PAYABLES_UNITS,
FIXED_ASSETS_UNITS,
PAYABLES_CODE_COMBINATION_ID,
EXPENSE_CODE_COMBINATION_ID,
LOCATION_ID,
ASSIGNED_TO,
FEEDER_SYSTEM_NAME,
CREATE_BATCH_DATE,
CREATE_BATCH_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
REVIEWER_COMMENTS,
INVOICE_NUMBER,
VENDOR_NUMBER,
PO_VENDOR_ID,
PO_NUMBER,
POSTING_STATUS,
QUEUE_NAME,
INVOICE_DATE,
INVOICE_CREATED_BY,
INVOICE_UPDATED_BY,
PAYABLES_COST,
INVOICE_ID,
PAYABLES_BATCH_NAME,
DEPRECIATE_FLAG,
PARENT_MASS_ADDITION_ID,
PARENT_ASSET_ID,
SPLIT_MERGED_CODE,
AP_DISTRIBUTION_LINE_NUMBER,
POST_BATCH_ID,
ADD_TO_ASSET_ID,
AMORTIZE_FLAG,
NEW_MASTER_FLAG,
ASSET_KEY_CCID,
ASSET_TYPE,
DEPRN_RESERVE,
YTD_DEPRN,
BEGINNING_NBV,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
SALVAGE_VALUE,
ACCOUNTING_DATE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY_CODE,
FULLY_RSVD_REVALS_COUNTER,
MERGE_INVOICE_NUMBER,
MERGE_VENDOR_NUMBER,
PRODUCTION_CAPACITY,
REVAL_AMORTIZATION_BASIS,
REVAL_RESERVE,
UNIT_OF_MEASURE,
UNREVALUED_COST,
YTD_REVAL_DEPRN_EXPENSE,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
MERGED_CODE,
SPLIT_CODE,
MERGE_PARENT_MASS_ADDITIONS_ID,
SPLIT_PARENT_MASS_ADDITIONS_ID,
PROJECT_ASSET_LINE_ID,
PROJECT_ID,
TASK_ID,
SUM_UNITS,
DIST_NAME,
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,
CONTEXT,
INVENTORIAL,
SHORT_FISCAL_YEAR_FLAG,
CONVERSION_DATE,
ORIGINAL_DEPRN_START_DATE,
GROUP_ASSET_ID,
CUA_PARENT_HIERARCHY_ID,
UNITS_TO_ADJUST,
BONUS_YTD_DEPRN,
BONUS_DEPRN_RESERVE,
AMORTIZE_NBV_FLAG,
AMORTIZATION_START_DATE,
TRANSACTION_TYPE_CODE,
TRANSACTION_DATE,
WARRANTY_ID,
LEASE_ID,
LESSOR_ID,
PROPERTY_TYPE_CODE,
PROPERTY_1245_1250_CODE,
IN_USE_FLAG,
OWNED_LEASED,
NEW_USED,
ASSET_ID,
MATERIAL_INDICATOR_FLAG,
cast(multiset (select MASSADD_DIST_ID dist_id,
MASS_ADDITION_ID mass_add_id,
UNITS,
DEPRN_EXPENSE_CCID,
LOCATION_ID,
EMPLOYEE_ID
from FA_MASSADD_DISTRIBUTIONS mass_dist
where mass_dist.mass_addition_id =
mass_add.mass_addition_id) as
fa_mass_add_dist_tbl) dists
into l_mass_add_rec
FROM fa_mass_additions mass_add
where mass_addition_id = px_group_asset_rec.mass_addition_id;
SELECT segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10
INTO l_akey_segment(1),
l_akey_segment(2),
l_akey_segment(3),
l_akey_segment(4),
l_akey_segment(5),
l_akey_segment(6),
l_akey_segment(7),
l_akey_segment(8),
l_akey_segment(9),
l_akey_segment(10)
FROM fa_asset_keywords
WHERE code_combination_id = l_akey_ccid;
select parent_flex_value
into l_parent_value
from FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
fnd_flex_value_sets val_set
where val_norm.flex_value_set_id = val_set.flex_value_set_id
and val_set.flex_value_set_name = l_value_set_name
and l_here_key_seg_val between val_norm.child_flex_value_low and
val_norm.child_flex_value_high;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7
into l_cat_segment(1),
l_cat_segment(2),
l_cat_segment(3),
l_cat_segment(4),
l_cat_segment(5),
l_cat_segment(6),
l_cat_segment(7)
from fa_categories
where category_id = l_mass_add_rec.asset_category_id;
select code_combination_id
into l_akey_ccid
from fa_asset_keywords
where decode(l_akey_segment(1), null, '-1', segment1) =
decode(l_akey_segment(1), null, '-1', l_akey_segment(1))
and decode(l_akey_segment(2), null, '-1', segment2) =
decode(l_akey_segment(2), null, '-1', l_akey_segment(2))
and decode(l_akey_segment(3), null, '-1', segment3) =
decode(l_akey_segment(3), null, '-1', l_akey_segment(3))
and decode(l_akey_segment(4), null, '-1', segment4) =
decode(l_akey_segment(4), null, '-1', l_akey_segment(4))
and decode(l_akey_segment(5), null, '-1', segment5) =
decode(l_akey_segment(5), null, '-1', l_akey_segment(5))
and decode(l_akey_segment(6), null, '-1', segment6) =
decode(l_akey_segment(6), null, '-1', l_akey_segment(6))
and decode(l_akey_segment(7), null, '-1', segment7) =
decode(l_akey_segment(7), null, '-1', l_akey_segment(7))
and decode(l_akey_segment(8), null, '-1', segment8) =
decode(l_akey_segment(8), null, '-1', l_akey_segment(8))
and decode(l_akey_segment(9), null, '-1', segment9) =
decode(l_akey_segment(9), null, '-1', l_akey_segment(9))
and decode(l_akey_segment(10), null,'-1', segment10) =
decode(l_akey_segment(10), null, '-1', l_akey_segment(10));
select category_id
into l_cat_id
from fa_categories
where decode(l_cat_segment(1), null,'-1', segment1) =
decode(l_cat_segment(1), null, '-1', l_cat_segment(1))
and decode(l_cat_segment(2), null, '-1', segment2) =
decode(l_cat_segment(2), null, '-1', l_cat_segment(2))
and decode(l_cat_segment(3), null, '-1', segment3) =
decode(l_cat_segment(3), null, '-1', l_cat_segment(3))
and decode(l_cat_segment(4), null, '-1', segment4) =
decode(l_cat_segment(4), null, '-1', l_cat_segment(4))
and decode(l_cat_segment(5), null, '-1', segment5) =
decode(l_cat_segment(5), null, '-1', l_cat_segment(5))
and decode(l_cat_segment(6), null, '-1', segment6) =
decode(l_cat_segment(6), null, '-1', l_cat_segment(6))
and decode(l_cat_segment(7), null, '-1', segment7) =
decode(l_cat_segment(7), null, '-1', l_cat_segment(7));
select l_temp + 1
into l_temp
from fa_books
where book_type_code = l_mass_add_rec.book_type_code
and transaction_header_id_out is null
and asset_id = rec.asset_id;
update fa_mass_additions
set posting_status = 'ON-HOLD', Queue_name = 'ON-HOLD'
where mass_addition_id = l_mass_add_rec.mass_addition_id;
l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
update fa_mass_additions
set posting_status = 'POST',
Queue_name = 'POST',
group_asset_id = l_mass_add_rec.group_asset_id
where mass_addition_id = l_mass_add_rec.mass_addition_id;
l_debug_str := 'Update the mass addition line with parent asset id';
update fa_mass_additions
set posting_status = 'POST',
Queue_name = 'POST',
group_asset_id = l_parent_asset_id
where mass_addition_id = l_mass_add_rec.mass_addition_id;
select asset_key_ccid, asset_type, asset_category_id
into l_akey_ccid, l_asset_type, l_category_id
from fa_Additions
where asset_id = px_group_asset_rec.asset_id;
select l_temp + 1
into l_temp
from fa_books
where book_type_code = px_group_asset_rec.book_type_code
and transaction_header_id_out is null
and asset_id = px_group_asset_rec.asset_id;
select CALENDAR_PERIOD_OPEN_DATE
into l_CALENDAR_PERIOD_OPEN_DATE
from fa_deprn_periods
where period_close_date is null
and book_type_code = px_group_asset_rec.book_type_code;
l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
select location_id, code_combination_id
into l_asset_dist_rec.location_ccid,
l_asset_dist_rec.expense_ccid
from fa_distribution_history
where asset_id = px_group_asset_rec.asset_id
and book_type_code = px_group_asset_rec.book_type_code
and date_ineffective is null;