APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_ADJUSTMENTS

Line 46: ar_adjustments_all aa --anuj

42:
43: SELECT MAX( ct.trx_number )
44: INTO l_inv_trx_number
45: FROM ra_customer_trx ct,
46: ar_adjustments_all aa --anuj
47: WHERE aa.chargeback_customer_trx_id = p_customer_trx_id
48: and ct.org_id = aa.org_id
49: AND aa.customer_trx_id = ct.customer_trx_id;
50:

Line 930: FROM ar_adjustments

926: SELECT DECODE( MAX(adjustment_id),
927: NULL, 'N',
928: 'Y')
929: INTO l_activity_flag
930: FROM ar_adjustments
931: WHERE customer_trx_id = p_customer_trx_id;
932:
933: IF (l_activity_flag = 'Y')
934: THEN RETURN('Y');

Line 1943: ar_adjustments aa

1939: where ct.batch_source_id = bs.batch_source_id
1940: and ct.org_id = bs.org_id --anuj
1941: and ct.customer_trx_id = (select max(ctt.customer_trx_id)
1942: from ra_customer_trx ctt,
1943: ar_adjustments aa
1944: where aa.chargeback_customer_trx_id = p_customer_trx_id
1945: and aa.org_id = ctt.org_id --anuj
1946: and aa.customer_trx_id = ctt.customer_trx_id
1947: );

Line 2702: FROM ar_adjustments

2698: /* Bug 2453245 Added the query to retrieve the Adjustment
2699: Amount applied to the Invoice */
2700: SELECT nvl(sum(amount),0)
2701: INTO p_adj_amount_applied
2702: FROM ar_adjustments
2703: WHERE payment_schedule_id = p_applied_payment_schedule_id
2704: AND status = 'A'
2705: AND apply_date <= p_as_of_date;
2706: