[Home] [Help]
302: NULL, P_request_id,
303: CI.concurrent_request_id)
304: AND CI.status = 'DRAFT');
305:
306: UPDATE ar_adjustments
307: SET cons_inv_id = NULL
308: WHERE adjustment_id IN
309: (SELECT IT.adj_ps_id
310: FROM ar_cons_inv CI,
410: | 06-AUG-97 Jack Martinez bug 522890: |
411: | ignore guarantees when collecting |
412: | adjustments. When an invoice is |
413: | applied against a guarantee, a row is |
414: | created in ar_adjustments and is |
415: | applied against the payment schedule of|
416: | the guarantee. When gathering adjust- |
417: | ments, ignore if the class of the |
418: | related payment schedule is 'GUAR'. |
1137: /** gathering adjustments, check the class of the related **/
1138: /** payment schedule and omit if class = 'GUAR'. **/
1139:
1140: /*
1141: 1357024 fbreslin put AR_ADJUSTMENTS.tax_adjusted into AR_CONS_INV.TAX_ORIGINAL
1142: */
1143:
1144: /*
1145: 1340426 fbreslin: Only include approved adjustments
1167: RA.adjustment_id,
1168: NULL,
1169: ps.org_id
1170: FROM
1171: ar_adjustments RA,
1172: ar_payment_schedules PS
1173: WHERE
1174: RA.cons_inv_id is NULL
1175: /* bug2434295 Changed P_cutoff_date to l_real_cutoff_date */
1564: beginning_balance + l_new_billed + l_period_receipts
1565: WHERE cons_inv_id = l_consinv_id;
1566:
1567: /** For Site: update ar_payment_schedules, ar_receivable_applications **/
1568: /** and ar_adjustments **/
1569: /** Cross Currency functionality. **/
1570:
1571: UPDATE ar_payment_schedules PS
1572: SET PS.cons_inv_id = l_consinv_id
1615: 'EXCLUDE RECAPP',
1616: 'EXCLUDE_CMAPP'));
1617:
1618: /* bug2922922 : Added hint */
1619: UPDATE ar_adjustments RA
1620: SET RA.cons_inv_id = l_consinv_id
1621: WHERE RA.adjustment_id IN
1622: (SELECT /*+ index (IT AR_CONS_INV_TRX_N1) */
1623: IT.adj_ps_id