APPS.XTR_TRANS_INTERFACE SQL Statements

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

Line: 6

  select dealer_code
  from xtr_dealer_codes_v
  where user_id = fnd_user_id;

Line: 12

  select distinct e.SOURCE
   from  XTR_EXT_IMPORT_INTERFACE_V e
   where e.SELECT_FOR_TRANSFER = 'Y'
   and e.TRANSFER_BY = x_user;

Line: 18

  select s.SOURCE,s.TRANSFER_TRAILER_YN,s.REVERSE_ON_TRANSFER_YN,
         s.VERIFY_TRAILER_TOTALS,s.CURRENCY,s.ACCOUNT_NUMBER,
         s.COMPANY_CODE,s.IMPORT_INCLUDES_DECIMAL
   from XTR_SOURCE_OF_IMPORTS_V s
   where s.SOURCE = l_imp_source;

Line: 25

  select distinct CREATION_DATE
   from XTR_EXT_IMPORT_INTERFACE_V
   where SELECT_FOR_TRANSFER = 'Y'
   and TRANSFER_BY = x_user
   and SOURCE = l_source
   and CURRENCY = l_ccy;

Line: 33

  select sum(b.AMOUNT / l_divisor),count(b.TRANSACTION_CODE)
   from XTR_EXT_IMPORT_INTERFACE_V b
   where b.SOURCE = l_source
   and b.CURRENCY = l_ccy
   and b.CREATION_DATE = l_cre_date
   and to_number(b.TRANSACTION_CODE) <= 49
   and b.RECORD_TYPE IN ('1','01');

Line: 42

  select sum(b.AMOUNT / l_divisor),count(b.TRANSACTION_CODE)
   from XTR_EXT_IMPORT_INTERFACE_V b
   where b.SOURCE = l_source
   and b.CURRENCY = l_ccy
   and b.CREATION_DATE = l_cre_date
   and to_number(b.TRANSACTION_CODE) >= 50
   and b.RECORD_TYPE IN ('1','01');

Line: 51

  select nvl(a.AMOUNT,0) / l_divisor,nvl(a.DEBIT_AMOUNT,0) / l_divisor,
         nvl(a.CREDIT_AMOUNT,0) / l_divisor,
         nvl(a.NUMBER_OF_TRANSACTIONS,0)
   from XTR_EXT_IMPORT_INTERFACE_V a
   where a.SOURCE = l_source
   and a.CURRENCY = l_ccy
   and a.CREATION_DATE = l_cre_date
   and a.RECORD_TYPE IN ('2','02');

Line: 61

  select a.ACCOUNT_NUMBER
   from  XTR_EXT_IMPORT_INTERFACE_V a
   where a.SOURCE = l_source
   and a.CURRENCY = l_ccy
   and a.CREATION_DATE = l_cre_date
   and a.RECORD_TYPE IN ('0','00','2','02')
   order by a.RECORD_TYPE asc;

Line: 70

  select 1
   from XTR_BANK_ACCOUNTS_V
   where PARTY_CODE = l_company
   and CURRENCY = l_ccy;

Line: 76

  select *
   from XTR_EXT_IMPORT_INTERFACE_V
   where SELECT_FOR_TRANSFER = 'Y'
   and TRANSFER_BY = x_user
   and SOURCE = l_source
   and CREATION_DATE = l_cre_date
   and CURRENCY = l_ccy
   order by SOURCE,RECORD_TYPE
   for update of CREATION_DATE;

Line: 87

  select XTR_DEAL_DATE_AMOUNTS_S.NEXTVAL
   from  DUAL;

Line: 140

   UPDATE XTR_EXT_IMPORT_INTERFACE
    set SELECT_FOR_TRANSFER = 'Y',
        TRANSFER_BY = X_user
    where CREATION_DATE = NVL(G_creation_date, creation_date)
    	and SOURCE = NVL(G_source, source)
        and CURRENCY = NVL(G_currency, currency);

Line: 185

     insert into XTR_IMPORT_TRANSFER_ERRORS_V
      (SOURCE,CREATION_DATE,CURRENCY,NET_AMOUNT,NET_DEBIT_AMOUNT,
       NET_CREDIT_AMOUNT,NET_TRANS_NOS,TRANSFER_ON,TRANSFER_BY,COMMENTS)
     values
     (l_source,l_cre_date,l_ccy,NULL,NULL,NULL,NULL, sysdate, x_user,error_msg);

Line: 193

   update XTR_EXT_IMPORT_INTERFACE_V
    set SELECT_FOR_TRANSFER = NULL
    where CREATION_DATE = l_cre_date
    and SOURCE = l_source
    and CURRENCY = l_ccy
    and TRANSFER_BY = x_user;

Line: 207

    insert into XTR_IMPORT_TRANSFER_ERRORS_V
     (SOURCE,CREATION_DATE,CURRENCY,NET_AMOUNT,NET_DEBIT_AMOUNT,
      NET_CREDIT_AMOUNT,NET_TRANS_NOS,TRANSFER_ON,TRANSFER_BY,COMMENTS)
    values
     (l_source,l_cre_date,l_ccy,NULL,NULL,NULL,NULL, sysdate, x_user,error_msg);

Line: 215

   update XTR_EXT_IMPORT_INTERFACE_V
    set SELECT_FOR_TRANSFER = NULL
    where CREATION_DATE = l_cre_date
    and SOURCE = l_source
    and CURRENCY = l_ccy
    and TRANSFER_BY = x_user;

Line: 243

       insert into XTR_IMPORT_TRANSFER_ERRORS_V
        (SOURCE,CREATION_DATE,CURRENCY,NET_AMOUNT,NET_DEBIT_AMOUNT,
        NET_CREDIT_AMOUNT,NET_TRANS_NOS,TRANSFER_ON,TRANSFER_BY,COMMENTS)
       values
        (l_source,l_cre_date,l_ccy,nvl(l_net_amount,0) - nvl(l_total,0),
         NULL,NULL,NULL, sysdate, x_user,error_msg);

Line: 251

   update XTR_EXT_IMPORT_INTERFACE_V
    set SELECT_FOR_TRANSFER = NULL
    where CREATION_DATE = l_cre_date
    and SOURCE = l_source
    and CURRENCY = l_ccy
    and TRANSFER_BY = x_user;

Line: 266

      insert into XTR_IMPORT_TRANSFER_ERRORS_V
       (SOURCE,CREATION_DATE,CURRENCY,NET_AMOUNT,NET_DEBIT_AMOUNT,
        NET_CREDIT_AMOUNT,NET_TRANS_NOS,TRANSFER_ON,TRANSFER_BY,COMMENTS)
      values
       (l_source,l_cre_date,l_ccy,NULL,
        nvl(l_net_debit,0)  - nvl(l_db_total,0),
        nvl(l_net_credit,0) - nvl(l_cr_total,0),
        nvl(l_net_trans,0)  - nvl(l_num_trans,0),
        sysdate, x_user,error_msg);

Line: 278

   update XTR_EXT_IMPORT_INTERFACE_V
    set SELECT_FOR_TRANSFER = NULL
    where CREATION_DATE = l_cre_date
    and SOURCE = l_source
    and CURRENCY = l_ccy
    and TRANSFER_BY = x_user;

Line: 299

     insert into XTR_IMPORT_TRANSFER_ERRORS_V
      (SOURCE,CREATION_DATE,CURRENCY,NET_AMOUNT,NET_DEBIT_AMOUNT,
       NET_CREDIT_AMOUNT,NET_TRANS_NOS,TRANSFER_ON,TRANSFER_BY,COMMENTS)
     values
     (l_source,l_cre_date,l_ccy,NULL,NULL,NULL,NULL, sysdate,
       x_user,error_msg);

Line: 307

   update XTR_EXT_IMPORT_INTERFACE_V
    set SELECT_FOR_TRANSFER = NULL
    where CREATION_DATE = l_cre_date
    and SOURCE = l_source
    and CURRENCY = l_ccy
    and TRANSFER_BY = x_user;

Line: 341

       insert into XTR_PAY_REC_RECONCILIATION_V
        (IMPORT_REFERENCE,VALUE_DATE,PARTY_NAME,PARTICULARS,
         SERIAL_REFERENCE,RECORD_TYPE,DEBIT_AMOUNT,CREDIT_AMOUNT,
         COMMENTS)
       values
        (l_import_nos,row_det.VALUE_DATE,row_det.PARTY_NAME,
         row_det.PARTICULARS,row_det.SERIAL_REFERENCE,
         row_det.RECORD_TYPE,row_det.DEBIT_AMOUNT,
         row_det.CREDIT_AMOUNT,row_det.COMMENTS);

Line: 352

       insert into XTR_IMPORT_TRAILER_DETAILS_V
        (SOURCE,IMPORT_REFERENCE,ACCOUNT_NUMBER,CURRENCY,CREATION_DATE)
       values
       (l_source,l_import_nos,nvl(l_batch_acct,l_acct),l_ccy,l_cre_date);

Line: 375

        insert into XTR_PAY_REC_RECONCILIATION_V
         (IMPORT_REFERENCE,VALUE_DATE,PARTY_NAME,PARTICULARS,
          SERIAL_REFERENCE,RECORD_TYPE,DEBIT_AMOUNT,CREDIT_AMOUNT,
          COMMENTS)
        values
         (l_import_nos,row_det.VALUE_DATE,row_det.PARTY_NAME,
          row_det.PARTICULARS,row_det.SERIAL_REFERENCE,
          row_det.RECORD_TYPE,row_det.DEBIT_AMOUNT,
          row_det.CREDIT_AMOUNT,row_det.COMMENTS);

Line: 386

    /* Do Not Delete for Test purposes*/
      -- Delete Successful transfer from Interface Table
      delete from XTR_EXT_IMPORT_INTERFACE_V
       where SELECT_FOR_TRANSFER = 'Y'
       and CREATION_DATE = row_det.CREATION_DATE
       and SOURCE = row_det.SOURCE
       and TRANSFER_BY = row_det.TRANSFER_BY;