APPS.JA_TW_AR_AUTO_INVOICE SQL Statements

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

Line: 39

    SELECT l.interface_line_id
         , l.customer_trx_id
         , l.cust_trx_type_id
         , l.trx_date
         , l.tax_code
         , l.line_type
      FROM
           ra_interface_lines_gt l
     WHERE
           l.request_id = x_request_id
       AND NVL(l.interface_status, '~') <> 'P'
       AND l.customer_trx_id IS NOT NULL
     ORDER BY l.trx_date;

Line: 219

      SELECT TO_NUMBER(cr.argument3)
        INTO l_batch_source_id
        FROM fnd_concurrent_requests cr
       WHERE request_id = p_request_id;