DBA Data[Home] [Help]

APPS.ARP_PROC_TRANSACTION_HISTORY dependencies on RA_CUSTOMER_TRX_LINES

Line 885: FROM ra_customer_trx_lines ctl,

881: sum(nvl(line_adjusted,0)) total_line,
882: sum(nvl(freight_adjusted,0)) total_freight,
883: sum(nvl(tax_adjusted,0)) total_tax,
884: sum(nvl(receivables_charges_adjusted,0)) total_charges
885: FROM ra_customer_trx_lines ctl,
886: ar_adjustments adj
887: WHERE ctl.customer_trx_id = p_customer_trx_id
888: AND adj.adjustment_id = ctl.br_adjustment_id;
889: