APPS.ARP_BF_BILL dependencies on AR_ADJUSTMENTS

Line 345: UPDATE ar_adjustments

341: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
342: where i.status = 'PRE_REJECTED'));
343:
344:
345: UPDATE ar_adjustments
346: SET cons_inv_id = NULL
347: WHERE adjustment_id IN
348: (SELECT IT.adj_ps_id
349: FROM ar_cons_inv CI,

Line 1656: ar_adjustments ADJ,

1652: ADJ.adjustment_id,
1653: NULL,
1654: ps.org_id
1655: FROM
1656: ar_adjustments ADJ,
1657: ar_payment_schedules PS
1658: WHERE
1659: ADJ.cons_inv_id is NULL
1660: AND ADJ.gl_date <= l_billing_date

Line 1696: ar_adjustments ADJ,

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

Line 2251: and ar_adjustments **/

2247: l_period_adj + l_period_credits + l_period_finchrg
2248: WHERE cons_inv_id = l_consinv_id;
2249:
2250: /** For Site: update ar_payment_schedules, ar_receivable_applications
2251: and ar_adjustments **/
2252:
2253: write_debug_and_log('Updating AR_PAYMENT_SCHEDULES');
2254:
2255: UPDATE ar_payment_schedules PS

Line 2300: write_debug_and_log('Updating AR_ADJUSTMENTS');

2296: 'XSITE XCURR RECAPP',
2297: 'EXCLUDE RECAPP',
2298: 'EXCLUDE_CMAPP'));
2299:
2300: write_debug_and_log('Updating AR_ADJUSTMENTS');
2301:
2302: UPDATE ar_adjustments RA
2303: SET RA.cons_inv_id = l_consinv_id
2304: WHERE RA.adjustment_id IN

Line 2302: UPDATE ar_adjustments RA

2298: 'EXCLUDE_CMAPP'));
2299:
2300: write_debug_and_log('Updating AR_ADJUSTMENTS');
2301:
2302: UPDATE ar_adjustments RA
2303: SET RA.cons_inv_id = l_consinv_id
2304: WHERE RA.adjustment_id IN
2305: (SELECT /*+ index (IT AR_CONS_INV_TRX_N1) */
2306: IT.adj_ps_id