The following lines contain the word 'select', 'insert', 'update' or 'delete':
select agreement_id
from oe_agreements_b
where invoice_to_org_id in (select m.duplicate_site_id
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
select agreement_id
from oe_agreements_b
where sold_to_org_id in (select m.duplicate_id
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
/** site level update **/
oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Site Data');
UPDATE oe_agreements_b a
SET (invoice_to_org_id) = (select distinct m.customer_site_id
from ra_customer_merges m
where a.invoice_to_org_id = m.duplicate_site_id
and m.request_id = req_id
and m.process_flag = 'Y'
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = -1,
last_update_login = -1
WHERE exists (select 'X'
from ra_customer_merges m
where a.invoice_to_org_id = m.duplicate_site_id
and m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num);
oe_debug_pub.add(g_count || ' rows updated');
/**customer level update**/
oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Data');
UPDATE oe_agreements_b a
SET sold_to_org_id = (select distinct m.customer_id
from ra_customer_merges m
where a.sold_to_org_id = m.duplicate_id
and m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = -1,
last_update_login = -1
WHERE sold_to_org_id in (select m.duplicate_id
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num);
oe_debug_pub.add(g_count || ' rows updated');
select qualifier_id
from qp_qualifiers
where qualifier_context = 'CUSTOMER'
and qualifier_attribute = 'QUALIFIER_ATTRIBUTE11'
and qualifier_attr_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
select qualifier_id
from qp_qualifiers
where qualifier_context = 'CUSTOMER'
and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
and qualifier_attr_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
select qualifier_id
from qp_qualifiers
where qualifier_context = 'CUSTOMER'
and qualifier_attribute = 'QUALIFIER_ATTRIBUTE14'
and qualifier_attr_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
select qualifier_id
from qp_qualifiers
where qualifier_context = 'CUSTOMER'
and qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
and qualifier_attr_value in (select to_char(m.duplicate_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
/** site level update **/
oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Ship To');
UPDATE qp_qualifiers
SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
from ra_customer_merges m
where m.duplicate_site_id =
to_number(qualifier_attr_value)
and m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = -1,
last_update_login = -1
WHERE qualifier_context = 'CUSTOMER'
AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE11'
AND qualifier_attr_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num);
oe_debug_pub.add(g_count || ' rows updated');
UPDATE qp_qualifiers
SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
from ra_customer_merges m
where m.duplicate_site_id =
to_number(qualifier_attr_value)
and m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = -1,
last_update_login = -1
WHERE qualifier_context = 'CUSTOMER'
AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
AND qualifier_attr_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num);
oe_debug_pub.add(g_count || ' rows updated');
UPDATE qp_qualifiers
SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
from ra_customer_merges m
where m.duplicate_site_id =
to_number(qualifier_attr_value)
and m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = -1,
last_update_login = -1
WHERE qualifier_context = 'CUSTOMER'
AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE14'
AND qualifier_attr_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num);
oe_debug_pub.add(g_count || ' rows updated');
/**customer level update**/
oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Data');
UPDATE qp_qualifiers
SET qualifier_attr_value = (select distinct to_char(m.customer_id)
from ra_customer_merges m
where m.duplicate_id =
to_number(qualifier_attr_value)
and m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = -1,
last_update_login = -1
WHERE qualifier_context = 'CUSTOMER'
AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
AND qualifier_attr_value in (select to_char(m.duplicate_id)
from ra_customer_merges m
where m.process_flag = 'Y'
and m.request_id = req_id
and m.set_number = set_num);
oe_debug_pub.add(g_count || ' rows updated');