eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CONSINV dependencies on AR_RECEIVABLE_APPLICATIONS

Line 273: UPDATE ar_receivable_applications

269: AND CI.status = 'DRAFT');
270:
271:
272: /* bug2882196 : Added 'EXCLUDE RECREV' and 'EXCLUDE_CMREV' */
273: UPDATE ar_receivable_applications
274: SET cons_inv_id = NULL
275: WHERE receivable_application_id IN
276: (SELECT IT.adj_ps_id
277: FROM ar_cons_inv CI,

Line 290: UPDATE ar_receivable_applications

286: CI.concurrent_request_id)
287: AND CI.status = 'DRAFT');
288:
289: /* bug2882196 : Added 'EXCLUDE RECAPP' and 'EXCLUDE_CMAPP' */
290: UPDATE ar_receivable_applications
291: SET cons_inv_id_to = NULL
292: WHERE receivable_application_id IN
293: (SELECT IT.adj_ps_id
294: FROM ar_cons_inv CI,

Line 464: | ar_receivable_applications table |

460: | Consolidated Bill Transaction Types. |
461: | Used XCURR RECREV and XSITE XCURR RECREV
462: | instead of XCURR RECREC and XSITE |
463: | XCURR RECREC in the update statement for
464: | ar_receivable_applications table |
465: | 13-Dec-02 Sahana Shetty Bug2677085: Period receipt amounts |
466: | were calculated incorrectly when |
467: | receipt location was filled in after |
468: | applications were made to invoices. |

Line 1286: ar_receivable_applications RA,

1282: RA.receivable_application_id,
1283: NULL,
1284: ps_cash.org_id
1285: FROM
1286: ar_receivable_applications RA,
1287: ar_payment_schedules ps_cash,
1288: ar_payment_schedules ps_inv
1289: WHERE
1290: RA.cons_inv_id IS NULL

Line 1330: ar_receivable_applications ra,

1326: NULL,
1327: ps_cash.org_id
1328: FROM
1329: ar_cons_inv_trx inv_trx,
1330: ar_receivable_applications ra,
1331: ar_payment_schedules ps_cash,
1332: ar_payment_schedules ps_inv
1333: WHERE ra.cons_inv_id_to is not null
1334: AND ra.cons_inv_id is null

Line 1384: ar_receivable_applications RA,

1380: RA.receivable_application_id,
1381: NULL,
1382: ps_cash.org_id
1383: FROM
1384: ar_receivable_applications RA,
1385: ar_payment_schedules ps_cash,
1386: ar_payment_schedules ps_inv
1387: WHERE
1388: RA.cons_inv_id_to IS NULL

Line 1428: ar_receivable_applications ra,

1424: NULL,
1425: ps_cash.org_id
1426: FROM
1427: ar_cons_inv_trx inv_trx,
1428: ar_receivable_applications ra,
1429: ar_payment_schedules ps_cash,
1430: ar_payment_schedules ps_inv
1431: WHERE ra.cons_inv_id_to is null
1432: AND ra.cons_inv_id is not null

Line 1469: ar_receivable_applications RA,

1465: RA.receivable_application_id,
1466: NULL,
1467: PS1.org_id
1468: FROM
1469: ar_receivable_applications RA,
1470: ar_payment_schedules PS1,
1471: ar_payment_schedules PS2
1472: /* bug2700662 Removed
1473: ra_customer_trx CT

Line 1517: ar_receivable_applications RA,

1513: RA.receivable_application_id,
1514: NULL,
1515: PS1.org_id
1516: FROM
1517: ar_receivable_applications RA,
1518: ar_payment_schedules PS1,
1519: ar_payment_schedules PS2
1520: /* bug2700662 Removed
1521: ra_customer_trx CT

Line 1567: / For Site: update ar_payment_schedules, ar_receivable_applications /

1563: SET ending_balance =
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

Line 1589: UPDATE ar_receivable_applications RA

1585: WHERE IT.cons_inv_id = l_consinv_id
1586: AND IT.transaction_type = 'RECEIPT REV');
1587:
1588: /* bug2882196 Added 'EXCLUDE RECREV' and 'EXCLUDE_CMREV' */
1589: UPDATE ar_receivable_applications RA
1590: SET RA.cons_inv_id = l_consinv_id
1591: WHERE RA.receivable_application_id IN
1592: (SELECT IT.adj_ps_id
1593: FROM ar_cons_inv_trx IT

Line 1605: UPDATE ar_receivable_applications RA

1601: /*Bug 2650786: Corrected Typo in above statement */
1602:
1603:
1604: /* bug2882196 Added 'EXCLUDE RECAPP' and 'EXCLUDE_CMAPP' */
1605: UPDATE ar_receivable_applications RA
1606: SET RA.cons_inv_id_to = l_consinv_id
1607: WHERE RA.receivable_application_id IN
1608: (SELECT IT.adj_ps_id
1609: FROM ar_cons_inv_trx IT

Line 1645: UPDATE ar_receivable_applications RA

1641: 1226201 fbreslin: change the order of the tables in the WHERE cluase of the
1642: sub-query for performance purposes.
1643: */
1644: /* bug2706497 : Removed meaningless update stmt.
1645: UPDATE ar_receivable_applications RA
1646: SET RA.cons_inv_id = -1
1647: WHERE RA.cons_inv_id IN
1648: (SELECT RA1.cons_inv_id
1649: FROM ar_payment_schedules PS1,

Line 1651: ar_receivable_applications RA1

1647: WHERE RA.cons_inv_id IN
1648: (SELECT RA1.cons_inv_id
1649: FROM ar_payment_schedules PS1,
1650: ar_payment_schedules PS2,
1651: ar_receivable_applications RA1
1652: WHERE RA1.cons_inv_id IS NULL
1653: AND RA1.status = 'APP'
1654: AND RA1.application_type IN ('CM', 'CASH')
1655: AND RA1.apply_date < to_date(l_real_cutoff_date)