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 1155: FROM ar_adjustments adj,

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

Line 1570: ar_adjustments adj,

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

Line 2345: ar_adjustments adj

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

Line 2436: l_adj_rec ar_adjustments%ROWTYPE;

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

Line 3610: FROM ar_adjustments

3606: SELECT ard.code_combination_id
3607: FROM ar_distributions ard
3608: WHERE ard.source_table = 'ADJ'
3609: AND source_id IN (SELECT adjustment_id
3610: FROM ar_adjustments
3611: WHERE customer_trx_id = p_customer_trx_id
3612: AND status = 'A')
3613: AND ard.tax_code_id = nvl(p_tax_code_id,-999)
3614: AND source_type = 'TAX'