APPS.ARP_BAL_UTIL dependencies on AR_ADJUSTMENTS

Line 721: FROM ar_adjustments

717: ,l_new_line_acctd_amt
718: ,l_new_frt_acctd_amt
719: ,l_new_chrg_acctd_amt
720: ,l_new_tax_acctd_amt
721: FROM ar_adjustments
722: WHERE customer_trx_id = p_customer_trx_id
723: AND status = 'A'
724: AND receivables_trx_id <> -15;
725:

Line 747: FROM ar_adjustments

743: l_afreight_adjustments,
744: l_acharges_adjustments,
745: l_base_atotal_adjustments,
746: l_atotal_adjustments
747: FROM ar_adjustments
748: WHERE customer_trx_id = p_customer_trx_id
749: AND status = 'A'
750: AND receivables_trx_id = -15;
751:

Line 1997: ar_adjustments adj

1993: )
1994: INTO l_commitment_bal
1995: FROM ra_customer_trx trx,
1996: ra_cust_trx_types type,
1997: ar_adjustments adj
1998: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
1999: AND trx.initial_customer_trx_id = p_customer_trx_id
2000: AND trx.complete_flag = 'Y'
2001: AND adj.adjustment_type = 'C'

Line 2066: FROM ar_adjustments

2062: SUM( amount ),
2063: 0
2064: )
2065: INTO l_commitment_bal
2066: FROM ar_adjustments
2067: WHERE customer_trx_id = p_customer_trx_id
2068: AND adjustment_type <> 'C';
2069:
2070: END IF; -- end Guarantee case

Line 2157: ar_adjustments a

2153: INTO l_actual_amount1,
2154: l_acctd_amount1
2155: FROM ra_customer_trx t,
2156: ra_cust_trx_types ty,
2157: ar_adjustments a
2158: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2159: and t.customer_trx_id = a.customer_trx_id
2160: and ty.type not in ('DEP', 'GUAR')
2161: and a.adjustment_type = 'C'

Line 2173: ar_adjustments a

2169: INTO l_actual_amount1,
2170: l_acctd_amount1
2171: FROM ra_customer_trx t,
2172: ra_cust_trx_types ty,
2173: ar_adjustments a
2174: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2175: and t.customer_trx_id = a.subsequent_trx_id
2176: and ty.type not in ('DEP', 'GUAR')
2177: and a.adjustment_type = 'C'

Line 2189: ar_adjustments a

2185: INTO l_actual_amount1,
2186: l_acctd_amount1
2187: FROM ra_customer_trx t,
2188: ra_cust_trx_types ty,
2189: ar_adjustments a
2190: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2191: and a.subsequent_trx_id IN
2192: (select cma.customer_trx_id
2193: from ar_receivable_applications cma

Line 2204: FROM ar_adjustments aa1

2200: -- following was added for Bug # 3702956
2201: AND adjustment_id NOT IN
2202: (
2203: SELECT adjustment_id
2204: FROM ar_adjustments aa1
2205: WHERE aa1.customer_trx_id = t.customer_trx_id
2206: AND aa1.adjustment_type = 'C'
2207: )
2208: AND adjustment_id NOT IN

Line 2211: FROM ar_adjustments aa2

2207: )
2208: AND adjustment_id NOT IN
2209: (
2210: SELECT adjustment_id
2211: FROM ar_adjustments aa2
2212: WHERE aa2.subsequent_trx_id = t.customer_trx_id
2213: AND aa2.adjustment_type = 'C'
2214: );
2215: