APPS.FV_CMERGE SQL Statements

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

Line: 71

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,yt.CUSTOMER_ID
              ,yt.CHARGE_ID
              ,yt.CUSTOMER_ID
         FROM FV_CUST_FINANCE_CHRGS yt, ra_customer_merges m
         WHERE (
            yt.CUSTOMER_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 97

    delete from fv_cust_finance_chrgs
                where (customer_id, charge_id) in
                                (select duplicate_id, charge_id
                                   from ra_customer_merges racm,
                                        fv_cust_finance_chrgs fcfc
                                     where  racm.process_flag = 'N'
                                       and racm.request_id = req_id
                                       and racm.set_number = set_num
                             and racm.customer_id = fcfc.customer_id
                             and fcfc.charge_id in
                                (select charge_id
                                   from fv_cust_finance_chrgs
                                  where customer_id = racm.duplicate_id));

Line: 131

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY1,
           PRIMARY_KEY2,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES (         HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'FV_CUST_FINANCE_CHRGS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY1_LIST(I),
         PRIMARY_KEY2_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 163

      UPDATE FV_CUST_FINANCE_CHRGS yt SET
           CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE CUSTOMER_ID=PRIMARY_KEY1_LIST(I)
      AND CHARGE_ID=PRIMARY_KEY2_LIST(I)
         ;

Line: 177

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

Line: 226

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,CUST_VEND_XREF_ID
              ,yt.CUSTOMER_ID
         FROM FV_CUST_VEND_XREFS yt, ra_customer_merges m
         WHERE (
            yt.CUSTOMER_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 251

    delete from fv_cust_vend_xrefs
                 where customer_id IN (select  duplicate_id
                                        from ra_customer_merges racm,
                                             fv_cust_vend_xrefs t
                                      where  racm.process_flag = 'N'
                                        and racm.request_id =  req_id
                                        and racm.set_number = set_num
                                        and racm.customer_id = t.customer_id);

Line: 262

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

Line: 287

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES (         HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'FV_CUST_VEND_XREFS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 317

      UPDATE FV_CUST_VEND_XREFS yt SET
           CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE CUST_VEND_XREF_ID=PRIMARY_KEY_ID_LIST(I)
         ;

Line: 330

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

Line: 376

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,INTERAGENCY_FUND_ID
              ,yt.CUSTOMER_ID
         FROM FV_INTERAGENCY_FUNDS yt, ra_customer_merges m
         WHERE (
            yt.CUSTOMER_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 418

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES (         HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'FV_INTERAGENCY_FUNDS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 448

      UPDATE FV_INTERAGENCY_FUNDS yt SET
           CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE INTERAGENCY_FUND_ID=PRIMARY_KEY_ID_LIST(I)
         ;

Line: 461

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

Line: 526

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,BATCH_ID
              ,yt.CUSTOMER_ID
              ,CUSTOMER_TRX_ID
              ,RECEIPT_NUMBER
              ,yt.CUSTOMER_ID
              ,yt.SITE_USE_ID
         FROM FV_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m
         WHERE (
            yt.CUSTOMER_ID = m.DUPLICATE_ID
            OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 578

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY1,
           PRIMARY_KEY2,
           PRIMARY_KEY3,
           PRIMARY_KEY4,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           NUM_COL2_ORIG,
           NUM_COL2_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES (         HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'FV_INTERIM_CASH_RECEIPTS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY1_LIST(I),
         PRIMARY_KEY2_LIST(I),
         PRIMARY_KEY3_LIST(I),
         PRIMARY_KEY4_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         NUM_COL2_ORIG_LIST(I),
         NUM_COL2_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 618

      UPDATE FV_INTERIM_CASH_RECEIPTS yt SET
           CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
          ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE BATCH_ID=PRIMARY_KEY1_LIST(I)
      AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
      AND CUSTOMER_TRX_ID=PRIMARY_KEY3_LIST(I)
      AND RECEIPT_NUMBER=PRIMARY_KEY4_LIST(I)
         ;

Line: 635

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

Line: 691

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,CUSTOMER_TRX_ID
              ,yt.CUSTOMER_ID
              ,CHARGE_ID
              ,yt.CUSTOMER_ID
         FROM FV_INVOICE_FINANCE_CHRGS yt, ra_customer_merges m
         WHERE (
            yt.CUSTOMER_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 737

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY1,
           PRIMARY_KEY2,
           PRIMARY_KEY3,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES (         HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'FV_INVOICE_FINANCE_CHRGS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY1_LIST(I),
         PRIMARY_KEY2_LIST(I),
         PRIMARY_KEY3_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 771

      UPDATE FV_INVOICE_FINANCE_CHRGS yt SET
           CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE CUSTOMER_TRX_ID=PRIMARY_KEY1_LIST(I)
      AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
      AND CHARGE_ID=PRIMARY_KEY3_LIST(I)
         ;

Line: 786

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

Line: 833

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,IPAC_BILLING_ID
              ,yt.CUSTOMER_ID
         FROM FV_IPAC_TRX yt, ra_customer_merges m
         WHERE (
            yt.CUSTOMER_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 875

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY1,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES (         HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'FV_IPAC_TRX',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY1_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 905

      UPDATE FV_IPAC_TRX yt SET
           CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE IPAC_BILLING_ID=PRIMARY_KEY1_LIST(I)
         ;

Line: 918

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