APPS.IBY_AR_UTILS SQL Statements

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

Line: 47

     SELECT
       XMLConcat(XMLAgg(document_headers),
                 XMLElement("DocumentReceivableCount",count(trxn_extension_id)))
     FROM iby_xml_fndcpt_doc_headers_v
     WHERE trxn_extension_id = c_extension_id;

Line: 142

     SELECT extended_amount
     FROM ar_invoice_lines_v
     WHERE (link_to_cust_trx_line_id IS NULL)
       AND (line_type = 'FREIGHT')
       AND (customer_trx_id = ci_cust_trx_id);

Line: 151

     SELECT SUM(extended_amount)
     FROM ar_invoice_lines_v
     WHERE
       (line_type = 'FREIGHT')
       AND (customer_trx_id = ci_cust_trx_id);

Line: 200

     SELECT customer_trx_line_id
     FROM ar_invoice_lines_v
     WHERE
       ( line_type = 'LINE')
       AND (customer_trx_id = ci_cust_trx_id);

Line: 226

     SELECT extended_amount
     FROM ar_invoice_lines_v
     WHERE
       ( line_type = 'LINE')
       AND (customer_trx_id = ci_cust_trx_id);

Line: 254

     SELECT extended_amount, location_rate_id, location_segment_id
     FROM ar_invoice_lines_v
     WHERE
       (line_type='TAX')
       AND (customer_trx_id = ci_cust_trx_id)
       AND (link_to_cust_trx_line_id = ci_cust_trx_line_id);

Line: 299

     SELECT location_rate_id, location_segment_id, tax_rate
     FROM ar_invoice_lines_v
     WHERE
       (line_type='TAX')
       AND (customer_trx_id = ci_cust_trx_id)
       AND (link_to_cust_trx_line_id = ci_cust_trx_line_id);

Line: 336

 SELECT decode(summ.status,   NULL,   'N',   'Y') AUTHORIZED_FLAG
         into x_auth_flag
   FROM iby_trxn_summaries_all summ
      , iby_fndcpt_tx_operations op
   WHERE summ.transactionid = op.transactionid
      AND reqtype = 'ORAPMTREQ'
      AND status IN(0,  100)
      AND trxntypeid IN(2,  3, 20)
      AND op.trxn_extension_id = p_trxn_extension_id
      AND summ.trxnmid = (SELECT MAX(trxnmid)
                          FROM iby_trxn_summaries_all summ1
                             , iby_fndcpt_tx_operations op1
                         WHERE summ1.transactionid = op1.transactionid
                           AND summ1.reqtype = 'ORAPMTREQ'
                           AND summ1.status IN(0, 100)
                           AND summ1.trxntypeid IN(2,  3,   20)
                           AND op1.trxn_extension_id = op.trxn_extension_id);