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_PAYMENT_SCHEDULES

Line 230: FROM ar_payment_schedules PS,

226: 1, NULL,
227: printing_count - 1)
228: WHERE customer_trx_id IN
229: (SELECT PS.customer_trx_id
230: FROM ar_payment_schedules PS,
231: ar_cons_inv_trx IT,
232: ar_cons_inv CI
233: WHERE IT.transaction_type IN ('INVOICE','CREDIT_MEMO')
234: AND CI.cons_inv_id = IT.cons_inv_id

Line 242: UPDATE ar_payment_schedules

238: CI.concurrent_request_id)
239: AND CI.status = 'DRAFT'
240: AND PS.payment_schedule_id = IT.adj_ps_id);
241:
242: UPDATE ar_payment_schedules
243: SET cons_inv_id = NULL
244: WHERE payment_schedule_id IN
245: (SELECT IT.adj_ps_id
246: FROM ar_cons_inv CI,

Line 257: UPDATE ar_payment_schedules

253: NULL, P_request_id,
254: CI.concurrent_request_id)
255: AND CI.status = 'DRAFT');
256:
257: UPDATE ar_payment_schedules
258: SET cons_inv_id_rev = NULL
259: WHERE payment_schedule_id IN
260: (SELECT IT.adj_ps_id
261: FROM ar_cons_inv CI,

Line 450: | AR_PAYMENT_SCHEDULES_N11. |

446: | 27-SEP-99 Frank Breslin 1006767: Changed all occurance of |
447: | PS.class to PS.class||'' in the WHERE |
448: | clause of SQL in the generate function |
449: | in order to supress the use of index |
450: | AR_PAYMENT_SCHEDULES_N11. |
451: | 12-DEC-01 Hiroshi Yoshiahra 2134375: Added "+1" to C_cutoff_date |
452: | of c_inv_trx cursor in generate |
453: | procedure when P_last_day_of_month |
454: | flag is 'Y' and C_cutoff_date is last |

Line 575: ar_payment_schedules PS

571: PS.tax_original tax,
572: PS.invoice_currency_code currency
573: FROM
574: ra_customer_trx CT,
575: ar_payment_schedules PS
576: WHERE
577: PS.customer_site_use_id = C_site_use_id
578: AND PS.cons_inv_id IS NULL
579: AND PS.invoice_currency_code = P_currency

Line 1160: SELECT /+ index (PS AR_PAYMENT_SCHEDULES_N5) /

1156: tax_original,
1157: adj_ps_id,
1158: cons_inv_line_number,
1159: org_id)
1160: SELECT /*+ index (PS AR_PAYMENT_SCHEDULES_N5) */
1161: l_consinv_id,
1162: 'ADJUSTMENT',
1163: PS.trx_number,
1164: RA.gl_date,

Line 1172: ar_payment_schedules PS

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 */
1176: AND RA.gl_date < l_real_cutoff_date

Line 1208: ar_payment_schedules PS,

1204: PS.payment_schedule_id,
1205: NULL,
1206: PS.org_id
1207: FROM
1208: ar_payment_schedules PS,
1209: ar_cash_receipts CR
1210: WHERE
1211: PS.customer_site_use_id = L_sites.site_id
1212: AND PS.cons_inv_id IS NULL

Line 1243: ar_payment_schedules PS,

1239: PS.payment_schedule_id,
1240: NULL,
1241: CR.org_id
1242: FROM
1243: ar_payment_schedules PS,
1244: ar_cash_receipts CR
1245: WHERE
1246: PS.customer_site_use_id = L_sites.site_id
1247: AND PS.cons_inv_id_rev IS NULL

Line 1287: ar_payment_schedules ps_cash,

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
1291: AND RA.status = 'APP'

Line 1288: ar_payment_schedules ps_inv

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
1291: AND RA.status = 'APP'
1292: AND RA.application_type = 'CASH'

Line 1331: ar_payment_schedules ps_cash,

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
1335: AND ra.status = 'APP'

Line 1332: ar_payment_schedules ps_inv

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
1335: AND ra.status = 'APP'
1336: AND ra.application_type = 'CASH'

Line 1385: ar_payment_schedules ps_cash,

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
1389: AND RA.status = 'APP'

Line 1386: ar_payment_schedules ps_inv

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
1389: AND RA.status = 'APP'
1390: AND RA.application_type = 'CASH'

Line 1429: ar_payment_schedules ps_cash,

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
1433: AND ra.status = 'APP'

Line 1430: ar_payment_schedules ps_inv

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
1433: AND ra.status = 'APP'
1434: AND ra.application_type = 'CASH'

Line 1470: ar_payment_schedules PS1,

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
1474: */

Line 1471: ar_payment_schedules PS2

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
1474: */
1475: WHERE

Line 1518: ar_payment_schedules PS1,

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
1522: */

Line 1519: ar_payment_schedules PS2

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
1522: */
1523: WHERE

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 1571: UPDATE ar_payment_schedules PS

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
1573: WHERE PS.payment_schedule_id IN
1574: (SELECT IT.adj_ps_id
1575: FROM ar_cons_inv_trx IT

Line 1580: UPDATE ar_payment_schedules PS

1576: WHERE IT.cons_inv_id = l_consinv_id
1577: AND IT.transaction_type IN ('INVOICE','CREDIT_MEMO',
1578: 'RECEIPT'));
1579:
1580: UPDATE ar_payment_schedules PS
1581: SET PS.cons_inv_id_rev = l_consinv_id
1582: WHERE PS.payment_schedule_id IN
1583: (SELECT IT.adj_ps_id
1584: FROM ar_cons_inv_trx IT

Line 1649: FROM ar_payment_schedules PS1,

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,
1650: ar_payment_schedules PS2,
1651: ar_receivable_applications RA1
1652: WHERE RA1.cons_inv_id IS NULL
1653: AND RA1.status = 'APP'

Line 1650: ar_payment_schedules PS2,

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,
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')

Line 1716: FROM ar_payment_schedules PS,

1712: P_request_id IN NUMBER) IS
1713:
1714: CURSOR c_pending_trx IS
1715: SELECT PS.customer_trx_id
1716: FROM ar_payment_schedules PS,
1717: ar_cons_inv_trx IT,
1718: ar_cons_inv CI
1719: WHERE
1720: CI.print_status = 'PENDING'

Line 1741: FROM ar_payment_schedules PS,

1737: 'REPRINT', 0,
1738: 1)
1739: WHERE CT.customer_trx_id IN
1740: (SELECT PS.customer_trx_id
1741: FROM ar_payment_schedules PS,
1742: ar_cons_inv_trx IT,
1743: ar_cons_inv CI
1744: WHERE (
1745: (P_print_option = 'REPRINT'