[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select organization_id,
inventory_item_id,
lot_number,
grade_code,
origination_date,
expiration_date,
maturity_date,
expiration_action_date,
expiration_action_code,
hold_date,
retest_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
c_attribute1,
c_attribute2,
c_attribute3,
c_attribute4,
c_attribute5,
c_attribute6,
c_attribute7,
c_attribute8,
c_attribute9,
c_attribute10,
c_attribute11,
c_attribute12,
c_attribute13,
c_attribute14,
c_attribute15,
c_attribute16,
c_attribute17,
c_attribute18,
c_attribute19,
c_attribute20,
d_attribute1,
d_attribute2,
d_attribute3,
d_attribute4,
d_attribute5,
d_attribute6,
d_attribute7,
d_attribute8,
d_attribute9,
d_attribute10,
n_attribute1,
n_attribute2,
n_attribute3,
n_attribute4,
n_attribute5,
n_attribute6,
n_attribute7,
n_attribute8,
n_attribute9,
n_attribute10
from MTL_LOTATT_SYNC_REPORT_TEMP
where flag = 1
and group_id = p_group_id;
select organization_id,
inventory_item_id,
lot_number
from MTL_LOTATT_SYNC_REPORT_TEMP
where lot_number = p_lot_number
and inventory_item_id = p_item_id
and flag = 2
and group_id = p_group_id;
update mtl_lot_numbers
set grade_code = l_grade_code,
origination_date = l_orig_date,
expiration_date = l_exp_date,
maturity_date = l_mat_date,
expiration_action_date = l_exp_action_date,
expiration_action_code = l_exp_action_code,
hold_date = l_hold_date,
retest_date = l_retest_date
where organization_id = l_dest_org_id
and inventory_item_id = l_dest_item_id
and lot_number = l_dest_lot_number;
update mtl_lot_numbers
set grade_code = l_grade_code,
origination_date = l_orig_date,
expiration_date = l_exp_date,
maturity_date = l_mat_date,
expiration_action_date = l_exp_action_date,
expiration_action_code = l_exp_action_code,
hold_date = l_hold_date,
retest_date = l_retest_date,
attribute_category = l_attribute_category,
attribute1 = l_attribute1,
attribute2 = l_attribute2,
attribute3 = l_attribute3,
attribute4 = l_attribute4,
attribute5 = l_attribute5,
attribute6 = l_attribute6,
attribute7 = l_attribute7,
attribute8 = l_attribute8,
attribute9 = l_attribute9,
attribute10 = l_attribute10,
attribute11 = l_attribute11,
attribute12 = l_attribute12,
attribute13 = l_attribute13,
attribute14 = l_attribute14,
attribute15 = l_attribute15,
c_attribute1 = l_c_attribute1,
c_attribute2 = l_c_attribute2,
c_attribute3 = l_c_attribute3,
c_attribute4 = l_c_attribute4,
c_attribute5 = l_c_attribute5,
c_attribute6 = l_c_attribute6,
c_attribute7 = l_c_attribute7,
c_attribute8 = l_c_attribute8,
c_attribute9 = l_c_attribute9,
c_attribute10 = l_c_attribute10,
c_attribute11 = l_c_attribute11,
c_attribute12 = l_c_attribute12,
c_attribute13 = l_c_attribute13,
c_attribute14 = l_c_attribute14,
c_attribute15 = l_c_attribute15,
c_attribute16 = l_c_attribute16,
c_attribute17 = l_c_attribute17,
c_attribute18 = l_c_attribute18,
c_attribute19 = l_c_attribute19,
c_attribute20 = l_c_attribute20,
d_attribute1 = l_d_attribute1,
d_attribute2 = l_d_attribute2,
d_attribute3 = l_d_attribute3,
d_attribute4 = l_d_attribute4,
d_attribute5 = l_d_attribute5,
d_attribute6 = l_d_attribute6,
d_attribute7 = l_d_attribute7,
d_attribute8 = l_d_attribute8,
d_attribute9 = l_d_attribute9,
d_attribute10 = l_d_attribute10,
n_attribute1 = l_n_attribute1,
n_attribute2 = l_n_attribute2,
n_attribute3 = l_n_attribute3,
n_attribute4 = l_n_attribute4,
n_attribute5 = l_n_attribute5,
n_attribute6 = l_n_attribute6,
n_attribute7 = l_n_attribute7,
n_attribute8 = l_n_attribute8,
n_attribute9 = l_n_attribute9,
n_attribute10 = l_n_attribute10
where organization_id = l_dest_org_id
and inventory_item_id = l_dest_item_id
and lot_number = l_dest_lot_number;