APPS.QP_CUST_MRG_DATA_CLEANUP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

    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;

Line: 22

    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;

Line: 51

/** site level update **/

    oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Site Data');

Line: 55

    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);

Line: 74

    oe_debug_pub.add(g_count || ' rows updated');

Line: 76

/**customer level update**/

    oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Data');

Line: 80

    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);

Line: 97

    oe_debug_pub.add(g_count || ' rows updated');

Line: 119

    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;

Line: 133

    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;

Line: 147

    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;

Line: 161

    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;

Line: 198

  /** site level update **/

    oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Ship To');

Line: 203

    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);

Line: 224

    oe_debug_pub.add(g_count || ' rows updated');

Line: 230

    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);

Line: 251

    oe_debug_pub.add(g_count || ' rows updated');

Line: 257

    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);

Line: 278

    oe_debug_pub.add(g_count || ' rows updated');

Line: 281

  /**customer level update**/

    oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Data');

Line: 286

    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);

Line: 307

    oe_debug_pub.add(g_count || ' rows updated');