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 (EXISTS
876: (

Line 912: FROM ar_payment_schedules ps,

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

Line 921: from ar_payment_schedules ps,

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

Line 1410: FROM ar_payment_schedules ps

1406: and 1097549 */
1407: BEGIN
1408: SELECT sum(count(distinct ps.customer_trx_id))
1409: INTO l_tot_trx2
1410: FROM ar_payment_schedules ps
1411: WHERE ps.trx_number = l_matching_number2
1412: AND ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1413: AND (EXISTS
1414: (

Line 1450: FROM ar_payment_schedules ps,

1446: SELECT invoice_currency_code,
1447: amount_due_remaining
1448: INTO ps_currency_code2,
1449: trx_amt_due_rem2
1450: FROM ar_payment_schedules ps,
1451: ra_cust_trx_types tt
1452: WHERE ps.trx_number = l_matching_number2
1453: AND ps.status = decode(tt.allow_overapplication_flag,
1454: 'N', 'OP',

Line 1459: from ar_payment_schedules ps,

1455: ps.status)
1456: AND ps.class NOT IN ('PMT','GUAR')
1457: AND ps.payment_schedule_id =
1458: (select min(ps.payment_schedule_id)
1459: from ar_payment_schedules ps,
1460: ra_cust_trx_types tt
1461: where ps.trx_number = l_matching_number2
1462: and ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1463: and (EXISTS /* subquery */

Line 1940: FROM ar_payment_schedules ps

1936: and 1097549 */
1937: BEGIN
1938: SELECT sum(count(distinct ps.customer_trx_id))
1939: INTO l_tot_trx3
1940: FROM ar_payment_schedules ps
1941: WHERE ps.trx_number = l_matching_number3
1942: AND ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1943: AND (EXISTS
1944: (

Line 1980: FROM ar_payment_schedules ps,

1976: SELECT invoice_currency_code,
1977: amount_due_remaining
1978: INTO ps_currency_code3,
1979: trx_amt_due_rem3
1980: FROM ar_payment_schedules ps,
1981: ra_cust_trx_types tt
1982: WHERE ps.trx_number = l_matching_number3
1983: AND ps.status = decode(tt.allow_overapplication_flag,
1984: 'N', 'OP',

Line 1989: from ar_payment_schedules ps,

1985: ps.status)
1986: AND ps.class NOT IN ('PMT','GUAR')
1987: AND ps.payment_schedule_id =
1988: (select min(ps.payment_schedule_id)
1989: from ar_payment_schedules ps,
1990: ra_cust_trx_types tt
1991: where ps.trx_number = l_matching_number3
1992: and ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1993: and (EXISTS

Line 2476: FROM ar_payment_schedules ps

2472: and 1097549 */
2473: BEGIN
2474: SELECT sum(count(distinct ps.customer_trx_id))
2475: INTO l_tot_trx4
2476: FROM ar_payment_schedules ps
2477: WHERE ps.trx_number = l_matching_number4
2478: AND ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2479: AND (EXISTS
2480: (

Line 2516: FROM ar_payment_schedules ps,

2512: SELECT invoice_currency_code,
2513: amount_due_remaining
2514: INTO ps_currency_code4,
2515: trx_amt_due_rem4
2516: FROM ar_payment_schedules ps,
2517: ra_cust_trx_types tt
2518: WHERE ps.trx_number = l_matching_number4
2519: AND ps.status = decode(tt.allow_overapplication_flag,
2520: 'N', 'OP',

Line 2525: from ar_payment_schedules ps,

2521: ps.status)
2522: AND ps.class NOT IN ('PMT','GUAR')
2523: AND ps.payment_schedule_id =
2524: (select min(ps.payment_schedule_id)
2525: from ar_payment_schedules ps,
2526: ra_cust_trx_types tt
2527: where ps.trx_number = l_matching_number4
2528: and ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2529: and (EXISTS

Line 3008: FROM ar_payment_schedules ps

3004: and 1097549 */
3005: BEGIN
3006: SELECT sum(count(distinct ps.customer_trx_id))
3007: INTO l_tot_trx5
3008: FROM ar_payment_schedules ps
3009: WHERE ps.trx_number = l_matching_number5
3010: AND ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
3011: AND (EXISTS
3012: (

Line 3048: FROM ar_payment_schedules ps,

3044: SELECT invoice_currency_code,
3045: amount_due_remaining
3046: INTO ps_currency_code5,
3047: trx_amt_due_rem5
3048: FROM ar_payment_schedules ps,
3049: ra_cust_trx_types tt
3050: WHERE ps.trx_number = l_matching_number5
3051: AND ps.status = decode(tt.allow_overapplication_flag,
3052: 'N', 'OP',

Line 3057: from ar_payment_schedules ps,

3053: ps.status)
3054: AND ps.class NOT IN ('PMT','GUAR')
3055: AND ps.payment_schedule_id =
3056: (select min(ps.payment_schedule_id)
3057: from ar_payment_schedules ps,
3058: ra_cust_trx_types tt
3059: where ps.trx_number = l_matching_number5
3060: and ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
3061: and (EXISTS

Line 3539: FROM ar_payment_schedules ps

3535: and 1097549 */
3536: BEGIN
3537: SELECT sum(count(distinct ps.customer_trx_id))
3538: INTO l_tot_trx6
3539: FROM ar_payment_schedules ps
3540: WHERE ps.trx_number = l_matching_number6
3541: AND ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3542: AND (EXISTS
3543: (

Line 3579: FROM ar_payment_schedules ps,

3575: SELECT invoice_currency_code,
3576: amount_due_remaining
3577: INTO ps_currency_code6,
3578: trx_amt_due_rem6
3579: FROM ar_payment_schedules ps,
3580: ra_cust_trx_types tt
3581: WHERE ps.trx_number = l_matching_number6
3582: AND ps.status = decode(tt.allow_overapplication_flag,
3583: 'N', 'OP',

Line 3588: from ar_payment_schedules ps,

3584: ps.status)
3585: AND ps.class NOT IN ('PMT','GUAR')
3586: AND ps.payment_schedule_id =
3587: (select min(ps.payment_schedule_id)
3588: from ar_payment_schedules ps,
3589: ra_cust_trx_types tt
3590: where ps.trx_number = l_matching_number6
3591: and ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3592: and (EXISTS

Line 4069: FROM ar_payment_schedules ps

4065: and 1097549 */
4066: BEGIN
4067: SELECT sum(count(distinct ps.customer_trx_id))
4068: INTO l_tot_trx7
4069: FROM ar_payment_schedules ps
4070: WHERE ps.trx_number = l_matching_number7
4071: AND ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4072: AND (EXISTS
4073: (

Line 4109: FROM ar_payment_schedules ps,

4105: SELECT invoice_currency_code,
4106: amount_due_remaining
4107: INTO ps_currency_code7,
4108: trx_amt_due_rem7
4109: FROM ar_payment_schedules ps,
4110: ra_cust_trx_types tt
4111: WHERE ps.trx_number = l_matching_number7
4112: AND ps.status = decode(tt.allow_overapplication_flag,
4113: 'N', 'OP',

Line 4118: from ar_payment_schedules ps,

4114: ps.status)
4115: AND ps.class NOT IN ('PMT','GUAR')
4116: AND ps.payment_schedule_id =
4117: (select min(ps.payment_schedule_id)
4118: from ar_payment_schedules ps,
4119: ra_cust_trx_types tt
4120: where ps.trx_number = l_matching_number7
4121: and ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4122: and (EXISTS

Line 4600: FROM ar_payment_schedules ps

4596: and 1097549 */
4597: BEGIN
4598: SELECT sum(count(distinct ps.customer_trx_id))
4599: INTO l_tot_trx8
4600: FROM ar_payment_schedules ps
4601: WHERE ps.trx_number = l_matching_number8
4602: AND ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4603: AND (EXISTS
4604: (

Line 4640: FROM ar_payment_schedules ps,

4636: SELECT invoice_currency_code,
4637: amount_due_remaining
4638: INTO ps_currency_code8,
4639: trx_amt_due_rem8
4640: FROM ar_payment_schedules ps,
4641: ra_cust_trx_types tt
4642: WHERE ps.trx_number = l_matching_number8
4643: AND ps.status = decode(tt.allow_overapplication_flag,
4644: 'N', 'OP',

Line 4649: from ar_payment_schedules ps,

4645: ps.status)
4646: AND ps.class NOT IN ('PMT','GUAR')
4647: AND ps.payment_schedule_id =
4648: (select min(ps.payment_schedule_id)
4649: from ar_payment_schedules ps,
4650: ra_cust_trx_types tt
4651: where ps.trx_number = l_matching_number8
4652: and ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4653: and (EXISTS