[Home] [Help]
313: AND CI.cons_inv_id = IT.cons_inv_id
314: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
315: where i.status = 'PRE_REJECTED'));
316:
317: UPDATE ar_receivable_applications
318: SET cons_inv_id = NULL
319: WHERE receivable_application_id IN
320: (SELECT IT.adj_ps_id
321: FROM ar_cons_inv CI,
326: AND CI.cons_inv_id = IT.cons_inv_id
327: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
328: where i.status = 'PRE_REJECTED'));
329:
330: UPDATE ar_receivable_applications
331: SET cons_inv_id_to = NULL
332: WHERE receivable_application_id IN
333: (SELECT IT.adj_ps_id
334: FROM ar_cons_inv CI,
1811: RA.receivable_application_id,
1812: NULL,
1813: ps_cash.org_id
1814: FROM
1815: ar_receivable_applications RA,
1816: ar_payment_schedules ps_cash,
1817: ar_payment_schedules ps_inv
1818: WHERE
1819: RA.cons_inv_id IS NULL
1858: RA.receivable_application_id,
1859: NULL,
1860: ps_cash.org_id
1861: FROM
1862: ar_receivable_applications RA,
1863: ar_payment_schedules ps_cash,
1864: ar_payment_schedules ps_inv
1865: WHERE
1866: RA.cons_inv_id_to IS NULL
1908: NULL,
1909: ps_cash.org_id
1910: FROM
1911: ar_cons_inv_trx inv_trx,
1912: ar_receivable_applications ra,
1913: ar_payment_schedules ps_cash,
1914: ar_payment_schedules ps_inv
1915: WHERE ra.cons_inv_id_to is not null
1916: AND ra.cons_inv_id is null
1954: NULL,
1955: ps_cash.org_id
1956: FROM
1957: ar_cons_inv_trx inv_trx,
1958: ar_receivable_applications ra,
1959: ar_payment_schedules ps_cash,
1960: ar_payment_schedules ps_inv
1961: WHERE ra.cons_inv_id_to is null
1962: AND ra.cons_inv_id is not null
1995: RA.receivable_application_id,
1996: NULL,
1997: PS_CM.org_id
1998: FROM
1999: ar_receivable_applications RA,
2000: ar_payment_schedules PS_CM,
2001: ar_payment_schedules PS_INV
2002: WHERE
2003: RA.cons_inv_id IS NULL
2036: RA.receivable_application_id,
2037: NULL,
2038: PS_CM.org_id
2039: FROM
2040: ar_receivable_applications RA,
2041: ar_payment_schedules PS_CM,
2042: ar_payment_schedules PS_INV
2043: WHERE
2044: RA.cons_inv_id IS NULL
2085: RA.receivable_application_id,
2086: NULL,
2087: PS_INV.org_id
2088: FROM
2089: ar_receivable_applications RA,
2090: ar_payment_schedules PS_INV, -- INV
2091: ar_payment_schedules PS_CM -- CM
2092: WHERE
2093: RA.cons_inv_id_to IS NULL
2246: ending_balance = beginning_balance + l_period_trx + l_period_receipts +
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:
2268: FROM ar_cons_inv_trx IT
2269: WHERE IT.cons_inv_id = l_consinv_id
2270: AND IT.transaction_type = 'RECEIPT REV');
2271:
2272: write_debug_and_log('Updating AR_RECEIVABLE_APPLICATIONS');
2273:
2274: UPDATE ar_receivable_applications RA
2275: SET RA.cons_inv_id = l_consinv_id
2276: WHERE RA.receivable_application_id IN
2270: AND IT.transaction_type = 'RECEIPT REV');
2271:
2272: write_debug_and_log('Updating AR_RECEIVABLE_APPLICATIONS');
2273:
2274: UPDATE ar_receivable_applications RA
2275: SET RA.cons_inv_id = l_consinv_id
2276: WHERE RA.receivable_application_id IN
2277: (SELECT IT.adj_ps_id
2278: FROM ar_cons_inv_trx IT
2283: 'XSITE XCURR RECREV',
2284: 'EXCLUDE RECREV',
2285: 'EXCLUDE_CMREV'));
2286:
2287: UPDATE ar_receivable_applications RA
2288: SET RA.cons_inv_id_to = l_consinv_id
2289: WHERE RA.receivable_application_id IN
2290: (SELECT IT.adj_ps_id
2291: FROM ar_cons_inv_trx IT