APPS.ARP_BR_ALLOC_WRAPPER_PKG SQL Statements

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

Line: 213

   SELECT ctl.customer_trx_id                     br_cust_trx_id             ,
          ctl.customer_trx_line_id                br_customer_trx_line_id    ,
          ctl.br_ref_customer_trx_id              br_ref_customer_trx_id     ,
          ctl.br_ref_payment_schedule_id          br_ref_payment_schedule_id ,
          ct.drawee_id                            drawee_id                  ,
          ct.drawee_site_use_id                   drawee_site_use_id         ,
          ct.invoice_currency_code                invoice_currency_code      ,
          ct.exchange_rate                        exchange_rate              ,
          ct.exchange_rate_type                   exchange_rate_type         ,
          ct.exchange_date                        exchange_date              ,
          ct.trx_date                             trx_date                   ,
          ct.bill_to_customer_id                  bill_to_customer_id        ,
          ct.bill_to_site_use_id                  bill_to_site_use_id        ,
          adj.adjustment_id                       br_adj_id                  ,
          nvl(adj.amount,0)                       br_adj_amt                 ,
          nvl(adj.acctd_amount,0)                 br_adj_acctd_amt           ,
          nvl(adj.line_adjusted,0)                br_adj_line_amt            ,
          nvl(adj.tax_adjusted,0)                 br_adj_tax_amt             ,
          nvl(adj.freight_adjusted,0)             br_adj_frt_amt             ,
          nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
FROM ra_customer_trx_lines ctl,
     ar_adjustments  adj,
     ra_customer_trx ct
WHERE ctl.customer_trx_id = p_customer_trx_id
AND   ctl.br_adjustment_id = adj.adjustment_id
AND   ct.customer_trx_id = ctl.br_ref_customer_trx_id
AND   adj.status = 'A'
order by ctl.customer_trx_line_id;