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 910: ra_cust_trx_types tt

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

Line 919: ra_cust_trx_types tt

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

Line 1442: ra_cust_trx_types tt

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

Line 1451: ra_cust_trx_types tt

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

Line 1966: ra_cust_trx_types tt

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

Line 1975: ra_cust_trx_types tt

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

Line 2496: ra_cust_trx_types tt

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

Line 2505: ra_cust_trx_types tt

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

Line 3022: ra_cust_trx_types tt

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

Line 3031: ra_cust_trx_types tt

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

Line 3547: ra_cust_trx_types tt

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

Line 3556: ra_cust_trx_types tt

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

Line 4071: ra_cust_trx_types tt

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

Line 4080: ra_cust_trx_types tt

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

Line 4596: ra_cust_trx_types tt

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

Line 4605: ra_cust_trx_types tt

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