APPS.ARP_BF_BILL dependencies on AR_ADJUSTMENTS

Line 325: UPDATE ar_adjustments

321: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
322: where i.status = 'PRE_REJECTED'));
323:
324:
325: UPDATE ar_adjustments
326: SET cons_inv_id = NULL
327: WHERE adjustment_id IN
328: (SELECT IT.adj_ps_id
329: FROM ar_cons_inv CI,

Line 1695: ar_adjustments ADJ,

1691: ADJ.adjustment_id,
1692: NULL,
1693: ps.org_id
1694: FROM
1695: ar_adjustments ADJ,
1696: ar_payment_schedules PS
1697: WHERE
1698: ADJ.cons_inv_id is NULL
1699: AND ADJ.apply_date <= l_billing_date

Line 1741: ar_adjustments ADJ,

1737: ADJ.adjustment_id,
1738: NULL,
1739: ps.org_id
1740: FROM
1741: ar_adjustments ADJ,
1742: ar_payment_schedules PS
1743: WHERE
1744: ADJ.cons_inv_id is NULL
1745: AND ADJ.apply_date <= l_billing_date

Line 2500: and ar_adjustments **/

2496: l_period_adj + l_period_credits + l_period_finchrg
2497: WHERE cons_inv_id = l_consinv_id;
2498:
2499: /** For Site: update ar_payment_schedules, ar_receivable_applications
2500: and ar_adjustments **/
2501:
2502: write_debug_and_log('Updating AR_PAYMENT_SCHEDULES');
2503:
2504: UPDATE ar_payment_schedules PS

Line 2551: write_debug_and_log('Updating AR_ADJUSTMENTS');

2547: 'XSITE XCURR RECAPP',
2548: 'EXCLUDE RECAPP',
2549: 'EXCLUDE_CMAPP'));
2550:
2551: write_debug_and_log('Updating AR_ADJUSTMENTS');
2552:
2553: UPDATE ar_adjustments RA
2554: SET RA.cons_inv_id = l_consinv_id
2555: WHERE RA.adjustment_id IN

Line 2553: UPDATE ar_adjustments RA

2549: 'EXCLUDE_CMAPP'));
2550:
2551: write_debug_and_log('Updating AR_ADJUSTMENTS');
2552:
2553: UPDATE ar_adjustments RA
2554: SET RA.cons_inv_id = l_consinv_id
2555: WHERE RA.adjustment_id IN
2556: (SELECT /*+ index (IT AR_CONS_INV_TRX_N1) */
2557: IT.adj_ps_id