APPS.ARP_BAL_UTIL dependencies on AR_ADJUSTMENTS

Line 795: FROM ar_adjustments

791: ,l_new_line_acctd_amt
792: ,l_new_frt_acctd_amt
793: ,l_new_chrg_acctd_amt
794: ,l_new_tax_acctd_amt
795: FROM ar_adjustments
796: WHERE customer_trx_id = p_customer_trx_id
797: AND status = 'A'
798: AND receivables_trx_id <> -15;
799:

Line 821: FROM ar_adjustments

817: l_afreight_adjustments,
818: l_acharges_adjustments,
819: l_base_atotal_adjustments,
820: l_atotal_adjustments
821: FROM ar_adjustments
822: WHERE customer_trx_id = p_customer_trx_id
823: AND status = 'A'
824: AND receivables_trx_id = -15;
825:

Line 2084: ar_adjustments adj

2080: )
2081: INTO l_commitment_bal
2082: FROM ra_customer_trx trx,
2083: ra_cust_trx_types type,
2084: ar_adjustments adj
2085: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
2086: AND trx.initial_customer_trx_id = p_customer_trx_id
2087: AND trx.complete_flag = 'Y'
2088: AND adj.adjustment_type = 'C'

Line 2153: FROM ar_adjustments

2149: SUM( amount ),
2150: 0
2151: )
2152: INTO l_commitment_bal
2153: FROM ar_adjustments
2154: WHERE customer_trx_id = p_customer_trx_id
2155: AND adjustment_type <> 'C';
2156:
2157: END IF; -- end Guarantee case

Line 2244: ar_adjustments a

2240: INTO l_actual_amount1,
2241: l_acctd_amount1
2242: FROM ra_customer_trx t,
2243: ra_cust_trx_types ty,
2244: ar_adjustments a
2245: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2246: and t.customer_trx_id = a.customer_trx_id
2247: and ty.type not in ('DEP', 'GUAR')
2248: and a.adjustment_type = 'C'

Line 2260: ar_adjustments a

2256: INTO l_actual_amount1,
2257: l_acctd_amount1
2258: FROM ra_customer_trx t,
2259: ra_cust_trx_types ty,
2260: ar_adjustments a
2261: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2262: and t.customer_trx_id = a.subsequent_trx_id
2263: and ty.type not in ('DEP', 'GUAR')
2264: and a.adjustment_type = 'C'

Line 2276: ar_adjustments a

2272: INTO l_actual_amount1,
2273: l_acctd_amount1
2274: FROM ra_customer_trx t,
2275: ra_cust_trx_types ty,
2276: ar_adjustments a
2277: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2278: and a.subsequent_trx_id IN
2279: (select cma.customer_trx_id
2280: from ar_receivable_applications cma

Line 2291: FROM ar_adjustments aa1

2287: -- following was added for Bug # 3702956
2288: AND adjustment_id NOT IN
2289: (
2290: SELECT adjustment_id
2291: FROM ar_adjustments aa1
2292: WHERE aa1.customer_trx_id = t.customer_trx_id
2293: AND aa1.adjustment_type = 'C'
2294: )
2295: AND adjustment_id NOT IN

Line 2298: FROM ar_adjustments aa2

2294: )
2295: AND adjustment_id NOT IN
2296: (
2297: SELECT adjustment_id
2298: FROM ar_adjustments aa2
2299: WHERE aa2.subsequent_trx_id = t.customer_trx_id
2300: AND aa2.adjustment_type = 'C'
2301: );
2302: