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 862: FROM ar_adjustments

858: SELECT DECODE( MAX(adjustment_id),
859: NULL, 'N',
860: 'Y')
861: INTO l_activity_flag
862: FROM ar_adjustments
863: WHERE customer_trx_id = p_customer_trx_id;
864:
865: IF (l_activity_flag = 'Y')
866: THEN RETURN('Y');

Line 1853: ar_adjustments aa

1849: where ct.batch_source_id = bs.batch_source_id
1850: and ct.org_id = bs.org_id --anuj
1851: and ct.customer_trx_id = (select max(ctt.customer_trx_id)
1852: from ra_customer_trx ctt,
1853: ar_adjustments aa
1854: where aa.chargeback_customer_trx_id = p_customer_trx_id
1855: and aa.org_id = ctt.org_id --anuj
1856: and aa.customer_trx_id = ctt.customer_trx_id
1857: );

Line 2583: FROM ar_adjustments

2579: /* Bug 2453245 Added the query to retrieve the Adjustment
2580: Amount applied to the Invoice */
2581: SELECT nvl(sum(amount),0)
2582: INTO p_adj_amount_applied
2583: FROM ar_adjustments
2584: WHERE payment_schedule_id = p_applied_payment_schedule_id
2585: AND status = 'A'
2586: AND apply_date <= p_as_of_date;
2587: