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.AR_CC_LOCKBOX dependencies on AR_PAYMENT_SCHEDULES

Line 519: ps_currency_code1 ar_payment_schedules.invoice_currency_code%type;

515: /* declare variable for currency code of the receipt */
516: l_currency_code ar_payments_interface.currency_code%type;
517: --
518: /* declare variables to hold the currency code from payment schedules */
519: ps_currency_code1 ar_payment_schedules.invoice_currency_code%type;
520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;
521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;

Line 520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;

516: l_currency_code ar_payments_interface.currency_code%type;
517: --
518: /* declare variables to hold the currency code from payment schedules */
519: ps_currency_code1 ar_payment_schedules.invoice_currency_code%type;
520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;
521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;

Line 521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;

517: --
518: /* declare variables to hold the currency code from payment schedules */
519: ps_currency_code1 ar_payment_schedules.invoice_currency_code%type;
520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;
521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;
525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;

Line 522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;

518: /* declare variables to hold the currency code from payment schedules */
519: ps_currency_code1 ar_payment_schedules.invoice_currency_code%type;
520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;
521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;
525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;
526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;

Line 523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;

519: ps_currency_code1 ar_payment_schedules.invoice_currency_code%type;
520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;
521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;
525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;
526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;
527: --

Line 524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;

520: ps_currency_code2 ar_payment_schedules.invoice_currency_code%type;
521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;
525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;
526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;
527: --
528: /* Bug 883345: need to retrieve the amount_due_remaining of the transaction*/

Line 525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;

521: ps_currency_code3 ar_payment_schedules.invoice_currency_code%type;
522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;
525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;
526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;
527: --
528: /* Bug 883345: need to retrieve the amount_due_remaining of the transaction*/
529:

Line 526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;

522: ps_currency_code4 ar_payment_schedules.invoice_currency_code%type;
523: ps_currency_code5 ar_payment_schedules.invoice_currency_code%type;
524: ps_currency_code6 ar_payment_schedules.invoice_currency_code%type;
525: ps_currency_code7 ar_payment_schedules.invoice_currency_code%type;
526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;
527: --
528: /* Bug 883345: need to retrieve the amount_due_remaining of the transaction*/
529:
530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;

Line 530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;

526: ps_currency_code8 ar_payment_schedules.invoice_currency_code%type;
527: --
528: /* Bug 883345: need to retrieve the amount_due_remaining of the transaction*/
529:
530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;
531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;
532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;

Line 531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;

527: --
528: /* Bug 883345: need to retrieve the amount_due_remaining of the transaction*/
529:
530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;
531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;
532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;

Line 532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;

528: /* Bug 883345: need to retrieve the amount_due_remaining of the transaction*/
529:
530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;
531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;
532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;
536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;

Line 533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;

529:
530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;
531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;
532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;
536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;
537: trx_amt_due_rem8 ar_payment_schedules.amount_due_remaining%type;

Line 534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;

530: trx_amt_due_rem1 ar_payment_schedules.amount_due_remaining%type;
531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;
532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;
536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;
537: trx_amt_due_rem8 ar_payment_schedules.amount_due_remaining%type;
538: amt_applied_from_tc ar_payments_interface.amount_applied_from1%type;

Line 535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;

531: trx_amt_due_rem2 ar_payment_schedules.amount_due_remaining%type;
532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;
536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;
537: trx_amt_due_rem8 ar_payment_schedules.amount_due_remaining%type;
538: amt_applied_from_tc ar_payments_interface.amount_applied_from1%type;
539:

Line 536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;

532: trx_amt_due_rem3 ar_payment_schedules.amount_due_remaining%type;
533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;
536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;
537: trx_amt_due_rem8 ar_payment_schedules.amount_due_remaining%type;
538: amt_applied_from_tc ar_payments_interface.amount_applied_from1%type;
539:
540: l_receipt_date ar_payments_interface.receipt_date%type;

Line 537: trx_amt_due_rem8 ar_payment_schedules.amount_due_remaining%type;

533: trx_amt_due_rem4 ar_payment_schedules.amount_due_remaining%type;
534: trx_amt_due_rem5 ar_payment_schedules.amount_due_remaining%type;
535: trx_amt_due_rem6 ar_payment_schedules.amount_due_remaining%type;
536: trx_amt_due_rem7 ar_payment_schedules.amount_due_remaining%type;
537: trx_amt_due_rem8 ar_payment_schedules.amount_due_remaining%type;
538: amt_applied_from_tc ar_payments_interface.amount_applied_from1%type;
539:
540: l_receipt_date ar_payments_interface.receipt_date%type;
541: --

Line 872: FROM ar_payment_schedules ps

868: **************************************************************************/
869: BEGIN
870: SELECT sum(count(distinct ps.customer_trx_id))
871: INTO l_tot_trx1
872: FROM ar_payment_schedules ps
873: WHERE ps.trx_number = l_matching_number1
874: AND ps.trx_date = l_resolved_matching1_date /* Bug fix 2926664 */
875: AND (ps.customer_id IN
876: (

Line 909: FROM ar_payment_schedules ps,

905: SELECT invoice_currency_code,
906: amount_due_remaining
907: INTO ps_currency_code1,
908: trx_amt_due_rem1
909: FROM ar_payment_schedules ps,
910: ra_cust_trx_types tt
911: WHERE ps.trx_number = l_matching_number1
912: AND ps.status = decode(tt.allow_overapplication_flag,
913: 'N', 'OP',

Line 918: from ar_payment_schedules ps,

914: ps.status)
915: AND ps.class NOT IN ('PMT','GUAR')
916: AND ps.payment_schedule_id =
917: (select min(ps.payment_schedule_id)
918: from ar_payment_schedules ps,
919: ra_cust_trx_types tt
920: where ps.trx_number = l_matching_number1
921: and ps.trx_date = l_resolved_matching1_date /* Bug fix 2926664 */
922: and (ps.customer_id IN

Line 1404: FROM ar_payment_schedules ps

1400: and 1097549 */
1401: BEGIN
1402: SELECT sum(count(distinct ps.customer_trx_id))
1403: INTO l_tot_trx2
1404: FROM ar_payment_schedules ps
1405: WHERE ps.trx_number = l_matching_number2
1406: AND ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1407: AND (ps.customer_id IN
1408: (

Line 1441: FROM ar_payment_schedules ps,

1437: SELECT invoice_currency_code,
1438: amount_due_remaining
1439: INTO ps_currency_code2,
1440: trx_amt_due_rem2
1441: FROM ar_payment_schedules ps,
1442: ra_cust_trx_types tt
1443: WHERE ps.trx_number = l_matching_number2
1444: AND ps.status = decode(tt.allow_overapplication_flag,
1445: 'N', 'OP',

Line 1450: from ar_payment_schedules ps,

1446: ps.status)
1447: AND ps.class NOT IN ('PMT','GUAR')
1448: AND ps.payment_schedule_id =
1449: (select min(ps.payment_schedule_id)
1450: from ar_payment_schedules ps,
1451: ra_cust_trx_types tt
1452: where ps.trx_number = l_matching_number2
1453: and ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1454: and (ps.customer_id IN

Line 1928: FROM ar_payment_schedules ps

1924: and 1097549 */
1925: BEGIN
1926: SELECT sum(count(distinct ps.customer_trx_id))
1927: INTO l_tot_trx3
1928: FROM ar_payment_schedules ps
1929: WHERE ps.trx_number = l_matching_number3
1930: AND ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1931: AND (ps.customer_id IN
1932: (

Line 1965: FROM ar_payment_schedules ps,

1961: SELECT invoice_currency_code,
1962: amount_due_remaining
1963: INTO ps_currency_code3,
1964: trx_amt_due_rem3
1965: FROM ar_payment_schedules ps,
1966: ra_cust_trx_types tt
1967: WHERE ps.trx_number = l_matching_number3
1968: AND ps.status = decode(tt.allow_overapplication_flag,
1969: 'N', 'OP',

Line 1974: from ar_payment_schedules ps,

1970: ps.status)
1971: AND ps.class NOT IN ('PMT','GUAR')
1972: AND ps.payment_schedule_id =
1973: (select min(ps.payment_schedule_id)
1974: from ar_payment_schedules ps,
1975: ra_cust_trx_types tt
1976: where ps.trx_number = l_matching_number3
1977: and ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1978: and (ps.customer_id IN

Line 2458: FROM ar_payment_schedules ps

2454: and 1097549 */
2455: BEGIN
2456: SELECT sum(count(distinct ps.customer_trx_id))
2457: INTO l_tot_trx4
2458: FROM ar_payment_schedules ps
2459: WHERE ps.trx_number = l_matching_number4
2460: AND ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2461: AND (ps.customer_id IN
2462: (

Line 2495: FROM ar_payment_schedules ps,

2491: SELECT invoice_currency_code,
2492: amount_due_remaining
2493: INTO ps_currency_code4,
2494: trx_amt_due_rem4
2495: FROM ar_payment_schedules ps,
2496: ra_cust_trx_types tt
2497: WHERE ps.trx_number = l_matching_number4
2498: AND ps.status = decode(tt.allow_overapplication_flag,
2499: 'N', 'OP',

Line 2504: from ar_payment_schedules ps,

2500: ps.status)
2501: AND ps.class NOT IN ('PMT','GUAR')
2502: AND ps.payment_schedule_id =
2503: (select min(ps.payment_schedule_id)
2504: from ar_payment_schedules ps,
2505: ra_cust_trx_types tt
2506: where ps.trx_number = l_matching_number4
2507: and ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2508: and (ps.customer_id IN

Line 2984: FROM ar_payment_schedules ps

2980: and 1097549 */
2981: BEGIN
2982: SELECT sum(count(distinct ps.customer_trx_id))
2983: INTO l_tot_trx5
2984: FROM ar_payment_schedules ps
2985: WHERE ps.trx_number = l_matching_number5
2986: AND ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
2987: AND (ps.customer_id IN
2988: (

Line 3021: FROM ar_payment_schedules ps,

3017: SELECT invoice_currency_code,
3018: amount_due_remaining
3019: INTO ps_currency_code5,
3020: trx_amt_due_rem5
3021: FROM ar_payment_schedules ps,
3022: ra_cust_trx_types tt
3023: WHERE ps.trx_number = l_matching_number5
3024: AND ps.status = decode(tt.allow_overapplication_flag,
3025: 'N', 'OP',

Line 3030: from ar_payment_schedules ps,

3026: ps.status)
3027: AND ps.class NOT IN ('PMT','GUAR')
3028: AND ps.payment_schedule_id =
3029: (select min(ps.payment_schedule_id)
3030: from ar_payment_schedules ps,
3031: ra_cust_trx_types tt
3032: where ps.trx_number = l_matching_number5
3033: and ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
3034: and (ps.customer_id IN

Line 3509: FROM ar_payment_schedules ps

3505: and 1097549 */
3506: BEGIN
3507: SELECT sum(count(distinct ps.customer_trx_id))
3508: INTO l_tot_trx6
3509: FROM ar_payment_schedules ps
3510: WHERE ps.trx_number = l_matching_number6
3511: AND ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3512: AND (ps.customer_id IN
3513: (

Line 3546: FROM ar_payment_schedules ps,

3542: SELECT invoice_currency_code,
3543: amount_due_remaining
3544: INTO ps_currency_code6,
3545: trx_amt_due_rem6
3546: FROM ar_payment_schedules ps,
3547: ra_cust_trx_types tt
3548: WHERE ps.trx_number = l_matching_number6
3549: AND ps.status = decode(tt.allow_overapplication_flag,
3550: 'N', 'OP',

Line 3555: from ar_payment_schedules ps,

3551: ps.status)
3552: AND ps.class NOT IN ('PMT','GUAR')
3553: AND ps.payment_schedule_id =
3554: (select min(ps.payment_schedule_id)
3555: from ar_payment_schedules ps,
3556: ra_cust_trx_types tt
3557: where ps.trx_number = l_matching_number6
3558: and ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3559: and (ps.customer_id IN

Line 4033: FROM ar_payment_schedules ps

4029: and 1097549 */
4030: BEGIN
4031: SELECT sum(count(distinct ps.customer_trx_id))
4032: INTO l_tot_trx7
4033: FROM ar_payment_schedules ps
4034: WHERE ps.trx_number = l_matching_number7
4035: AND ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4036: AND (ps.customer_id IN
4037: (

Line 4070: FROM ar_payment_schedules ps,

4066: SELECT invoice_currency_code,
4067: amount_due_remaining
4068: INTO ps_currency_code7,
4069: trx_amt_due_rem7
4070: FROM ar_payment_schedules ps,
4071: ra_cust_trx_types tt
4072: WHERE ps.trx_number = l_matching_number7
4073: AND ps.status = decode(tt.allow_overapplication_flag,
4074: 'N', 'OP',

Line 4079: from ar_payment_schedules ps,

4075: ps.status)
4076: AND ps.class NOT IN ('PMT','GUAR')
4077: AND ps.payment_schedule_id =
4078: (select min(ps.payment_schedule_id)
4079: from ar_payment_schedules ps,
4080: ra_cust_trx_types tt
4081: where ps.trx_number = l_matching_number7
4082: and ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4083: and (ps.customer_id IN

Line 4558: FROM ar_payment_schedules ps

4554: and 1097549 */
4555: BEGIN
4556: SELECT sum(count(distinct ps.customer_trx_id))
4557: INTO l_tot_trx8
4558: FROM ar_payment_schedules ps
4559: WHERE ps.trx_number = l_matching_number8
4560: AND ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4561: AND (ps.customer_id IN
4562: (

Line 4595: FROM ar_payment_schedules ps,

4591: SELECT invoice_currency_code,
4592: amount_due_remaining
4593: INTO ps_currency_code8,
4594: trx_amt_due_rem8
4595: FROM ar_payment_schedules ps,
4596: ra_cust_trx_types tt
4597: WHERE ps.trx_number = l_matching_number8
4598: AND ps.status = decode(tt.allow_overapplication_flag,
4599: 'N', 'OP',

Line 4604: from ar_payment_schedules ps,

4600: ps.status)
4601: AND ps.class NOT IN ('PMT','GUAR')
4602: AND ps.payment_schedule_id =
4603: (select min(ps.payment_schedule_id)
4604: from ar_payment_schedules ps,
4605: ra_cust_trx_types tt
4606: where ps.trx_number = l_matching_number8
4607: and ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4608: and (ps.customer_id IN