APPS.OEP_CMERGE_OEDIS SQL Statements

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

Line: 12

    select discount_line_id
    from so_discount_lines
    where  entity_value in (select to_char(m.duplicate_site_id)
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    and entity_id = 1009
    for update nowait;

Line: 23

    select discount_line_id
    from so_discount_lines
    where  entity_value in (select to_char(m.duplicate_site_id)
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    and entity_id = 1008
    for update nowait;

Line: 34

    select discount_line_id
    from so_discount_lines
    where  entity_value in (select to_char(m.duplicate_site_id)
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    and entity_id = 1007
    for update nowait;

Line: 45

    select discount_line_id
    from so_discount_lines
    where  entity_value in (select to_char(m.duplicate_id)
                                 from   ra_customer_merges  m
                                 where  m.process_flag = 'N'
			         and    m.request_id = req_id
			         and    m.set_number = set_num)
    and entity_id = 1000
    for update nowait;

Line: 84

/* site level update */
  arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line: 88

    UPDATE SO_DISCOUNT_LINES  a
    set (entity_value) = (select distinct to_char(m.customer_site_id)
                                   from   ra_customer_merges m
                                   where  to_number(a.entity_value) =
                                                 m.duplicate_site_id
			           and    m.request_id = req_id
                                   and    m.process_flag = 'N'
			           and    m.set_number = set_num),
           last_update_date = sysdate,
           last_updated_by = arp_standard.profile.user_id,
           last_update_login = arp_standard.profile.last_update_login
    where  entity_value in (select to_char(m.duplicate_site_id)
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    and entity_id = 1009;

Line: 108

  arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

Line: 112

/* site level update */
  arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line: 116

    UPDATE SO_DISCOUNT_LINES  a
    set (entity_value) = (select distinct to_char(m.customer_site_id)
                                   from   ra_customer_merges m
                                   where  to_number(a.entity_value) =
                                                 m.duplicate_site_id
			           and    m.request_id = req_id
                                   and    m.process_flag = 'N'
			           and    m.set_number = set_num),
           last_update_date = sysdate,
           last_updated_by = arp_standard.profile.user_id,
           last_update_login = arp_standard.profile.last_update_login
    where  entity_value in (select to_char(m.duplicate_site_id)
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    and entity_id = 1008;

Line: 136

  arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

Line: 140

/* site level update */
  arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line: 144

    UPDATE SO_DISCOUNT_LINES  a
    set (entity_value) = (select distinct to_char(m.customer_site_id)
                                   from   ra_customer_merges m
                                   where  to_number(a.entity_value) =
                                                 m.duplicate_site_id
			           and    m.request_id = req_id
                                   and    m.process_flag = 'N'
			           and    m.set_number = set_num),
           last_update_date = sysdate,
           last_updated_by = arp_standard.profile.user_id,
           last_update_login = arp_standard.profile.last_update_login
    where  entity_value in (select to_char(m.duplicate_site_id)
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    and entity_id = 1003;

Line: 164

  arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

Line: 168

/* customer level update */
  arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line: 172

    UPDATE SO_DISCOUNT_LINES  a
    set    entity_value = (select distinct to_char(m.customer_id)
                                from   ra_customer_merges m
                                where  to_number(a.entity_value) =
				 		m.duplicate_id
                                and    m.process_flag = 'N'
			        and    m.request_id = req_id
			        and    m.set_number = set_num),
           last_update_date = sysdate,
           last_updated_by = arp_standard.profile.user_id,
           last_update_login = arp_standard.profile.last_update_login
    where  entity_value in (select to_char(m.duplicate_id)
                                 from   ra_customer_merges  m
                                 where  m.process_flag = 'N'
			         and    m.request_id = req_id
			         and    m.set_number = set_num)
    and entity_id = 1000;

Line: 192

  arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

Line: 217

    select discount_customer_id
    from so_discount_customers
    where  site_use_id in (select m.duplicate_site_id
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num)
    for update nowait;

Line: 227

    select discount_customer_id
    from so_discount_customers
    where  customer_id in (select m.duplicate_id
                                 from   ra_customer_merges  m
                                 where  m.process_flag = 'N'
			         and    m.request_id = req_id
			         and    m.set_number = set_num)
    for update nowait;

Line: 259

/* site level update */
  arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line: 263

    UPDATE SO_DISCOUNT_CUSTOMERS  a
    set (site_use_id) = (select distinct m.customer_site_id
                                   from   ra_customer_merges m
                                   where  a.site_use_id =
                                                 m.duplicate_site_id
			           and    m.request_id = req_id
                                   and    m.process_flag = 'N'
			           and    m.set_number = set_num),
           last_update_date = sysdate,
           last_updated_by = arp_standard.profile.user_id,
           last_update_login = arp_standard.profile.last_update_login
    where  site_use_id in (select m.duplicate_site_id
                                    from   ra_customer_merges  m
                                    where  m.process_flag = 'N'
			            and    m.request_id = req_id
			            and    m.set_number = set_num);

Line: 282

  arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

Line: 285

/* customer level update */
  arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line: 289

    UPDATE SO_DISCOUNT_CUSTOMERS  a
    set    customer_id = (select distinct m.customer_id
                                from   ra_customer_merges m
                                where  a.customer_id =
				 		m.duplicate_id
                                and    m.process_flag = 'N'
			        and    m.request_id = req_id
			        and    m.set_number = set_num),
           last_update_date = sysdate,
           last_updated_by = arp_standard.profile.user_id,
           last_update_login = arp_standard.profile.last_update_login
    where  customer_id in (select m.duplicate_id
                                 from   ra_customer_merges  m
                                 where  m.process_flag = 'N'
			         and    m.request_id = req_id
			         and    m.set_number = set_num);

Line: 308

  arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );