APPS.ARP_CMERGE SQL Statements

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

Line: 13

     SELECT 1
     FROM   ra_customer_merges m
     WHERE  m.request_id = req_id
     AND    m.set_number = set_num
     AND EXISTS
     (
      SELECT 1
      FROM  ar_cons_inv ci
      WHERE ci.site_use_id IN (m.customer_site_id, m.duplicate_site_id)
      AND   ci.status = 'DRAFT'
     );