APPS.ARP_RECONCILE dependencies on AR_ADJUSTMENTS

Line 447: ar_adjustments adj,

443: nvl(adj.tax_adjusted,0) br_adj_tax_amt ,
444: nvl(adj.freight_adjusted,0) br_adj_frt_amt ,
445: nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
446: FROM ra_customer_trx_lines ctl,
447: ar_adjustments adj,
448: ra_customer_trx ct
449: WHERE ctl.customer_trx_id = p_customer_trx_id
450: AND ctl.br_adjustment_id = adj.adjustment_id
451: AND ct.customer_trx_id = ctl.br_ref_customer_trx_id

Line 697: ar_adjustments adj

693:
694: -- Get the Reconciliation entries created for Adjustments
695:
696: from2_stmt VARCHAR2(150) := ' from ar_distributions ard,
697: ar_adjustments adj
698: where ';
699:
700: where2_stmt VARCHAR2(3000) := ' adj.customer_trx_id = :p_customer_trx_id
701: and :p_calling_point IN (''TRAN'', ''BLTR'')

Line 840: -- ar_adjustments adj

836:
837: --where1_mrc_stmt VARCHAR2(150) := ' ard.set_of_books_id = :sob_id and ';
838:
839: --from2_mrc_stmt VARCHAR2(150) := ' from ar_mc_distributions_all ard,
840: -- ar_adjustments adj
841: -- where ';
842:
843: --from3_mrc_stmt VARCHAR2(150) := ' from ra_customer_trx_lines ctl,
844: -- ar_mc_distributions_all ard

Line 1156: FROM ar_adjustments adj,

1152: sum(nvl(adj.line_adjusted,0) * -1) line_amount,
1153: sum(nvl(adj.tax_adjusted,0) * -1) tax_amount,
1154: sum(nvl(adj.freight_adjusted,0) * -1) freight_amount,
1155: sum(nvl(adj.receivables_charges_adjusted,0) * -1) receivables_charges_amount
1156: FROM ar_adjustments adj,
1157: ar_payment_schedules pay
1158: WHERE adj.customer_trx_id = p_customer_trx_id
1159: AND adj.payment_schedule_id = pay.payment_schedule_id
1160: AND adj.status = 'A'

Line 1571: ar_adjustments adj,

1567: nvl(adj.tax_adjusted,0) br_adj_tax_amt ,
1568: nvl(adj.freight_adjusted,0) br_adj_frt_amt ,
1569: nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
1570: FROM ra_customer_trx_lines ctl,
1571: ar_adjustments adj,
1572: ra_customer_trx ct
1573: WHERE ctl.customer_trx_id = p_customer_trx_id
1574: AND ctl.br_adjustment_id = adj.adjustment_id
1575: AND ct.customer_trx_id = ctl.br_ref_customer_trx_id

Line 2346: ar_adjustments adj

2342: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2343: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2344: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2345: from ar_distributions ard,
2346: ar_adjustments adj
2347: where p_ae_sys_rec.sob_type = 'P'
2348: and adj.customer_trx_id = p_customer_trx_id
2349: and p_calling_point IN ('TRAN', 'BLTR')
2350: and adj.status = 'A'

Line 2437: l_adj_rec ar_adjustments%ROWTYPE;

2433:
2434: l_ae_rule_rec ae_rule_rec_type;
2435:
2436: l_app_rec ar_receivable_applications%ROWTYPE;
2437: l_adj_rec ar_adjustments%ROWTYPE;
2438:
2439: l_tax_ctr NUMBER := 0;
2440: l_tax_ctr1 NUMBER := 0;
2441: l_ctr NUMBER;