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 RA_CUST_TRX_TYPES

Line 913: ra_cust_trx_types tt

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',
917: ps.status)

Line 922: ra_cust_trx_types tt

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
926: (

Line 1451: ra_cust_trx_types tt

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',
1455: ps.status)

Line 1460: ra_cust_trx_types tt

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 */
1464: (

Line 1981: ra_cust_trx_types tt

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',
1985: ps.status)

Line 1990: ra_cust_trx_types tt

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
1994: (

Line 2517: ra_cust_trx_types tt

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',
2521: ps.status)

Line 2526: ra_cust_trx_types tt

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
2530: (

Line 3049: ra_cust_trx_types tt

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',
3053: ps.status)

Line 3058: ra_cust_trx_types tt

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
3062: (

Line 3580: ra_cust_trx_types tt

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',
3584: ps.status)

Line 3589: ra_cust_trx_types tt

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
3593: (

Line 4110: ra_cust_trx_types tt

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',
4114: ps.status)

Line 4119: ra_cust_trx_types tt

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
4123: (

Line 4641: ra_cust_trx_types tt

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',
4645: ps.status)

Line 4650: ra_cust_trx_types tt

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
4654: (