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_CUSTOMER_AGING dependencies on AR_PAYMENT_SCHEDULES

Line 229: ar_payment_schedules ps

225: decode(v_bucket_category,
226: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
227: 1))) b6
228: from ra_cust_trx_types,
229: ar_payment_schedules ps
230: where ps.gl_date <= p_as_of_date
231: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
232: and ps.gl_date_closed > p_as_of_date
233: and ps.customer_id = p_customer_id

Line 388: from ar_payment_schedules ps,

384: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
385: decode(v_bucket_category,
386: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
387: 1))) b6
388: from ar_payment_schedules ps,
389: ar_receivable_applications app
390: where app.gl_date+0 <= p_as_of_date
391: and ps.cash_receipt_id+0 = app.cash_receipt_id
392: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')

Line 560: from ar_payment_schedules ps,

556: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
557: decode(v_bucket_category,
558: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
559: 1))) b6
560: from ar_payment_schedules ps,
561: ar_receivable_applications app
562: where app.gl_date+0 > p_as_of_date
563: and ps.cash_receipt_id = app.cash_receipt_id /*4436914*/
564: and (ps.payment_schedule_id = app.applied_payment_schedule_id

Line 601: ar_payment_schedules_all ps

597: ps.payment_schedule_id
598: UNION ALL
599: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
600: FROM ar_adjustments adj,
601: ar_payment_schedules_all ps
602: WHERE adj.GL_date > p_as_of_date
603: AND ps.payment_schedule_id = adj.payment_schedule_id
604: AND adj.status = 'A'
605: AND ps.gl_date_closed > p_as_of_date

Line 766: from ar_payment_schedules ps,

762: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
763: decode(v_bucket_category,
764: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
765: 1))) b6
766: from ar_payment_schedules ps,
767: ra_cust_trx_types rctt
768: where ps.gl_date <= p_as_of_date
769: and ps.gl_date_closed > p_as_of_date
770: and ps.cust_trx_type_id = rctt.cust_trx_type_id

Line 918: from ar_payment_schedules ps,

914: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
915: decode(v_bucket_category,
916: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
917: 1))) b6
918: from ar_payment_schedules ps,
919: ar_receivable_applications app
920: where app.gl_date+0 <= p_as_of_date
921: and ps.cash_receipt_id+0 = app.cash_receipt_id
922: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')

Line 1088: from ar_payment_schedules ps,

1084: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
1085: decode(v_bucket_category,
1086: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1087: 1))) b6
1088: from ar_payment_schedules ps,
1089: ar_receivable_applications app
1090: where app.gl_date+0 > p_as_of_date
1091: and ps.cash_receipt_id = app.cash_receipt_id /*4436914*/
1092: and (ps.payment_schedule_id = app.applied_payment_schedule_id

Line 1127: ar_payment_schedules_all ps

1123: ps.payment_schedule_id
1124: UNION ALL
1125: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
1126: FROM ar_adjustments adj,
1127: ar_payment_schedules_all ps
1128: WHERE adj.GL_date > p_as_of_date
1129: AND ps.payment_schedule_id = adj.payment_schedule_id
1130: AND adj.status = 'A'
1131: AND ps.gl_date_closed > p_as_of_date

Line 1290: ar_payment_schedules ps

1286: decode(v_bucket_category,
1287: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1288: 1))) b6
1289: from ra_cust_trx_types,
1290: ar_payment_schedules ps
1291: where ps.gl_date <= p_as_of_date
1292: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
1293: and ps.gl_date_closed > p_as_of_date
1294: and ps.customer_id = p_customer_id

Line 1447: from ar_payment_schedules ps,

1443: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
1444: decode(v_bucket_category,
1445: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1446: 1))) b6
1447: from ar_payment_schedules ps,
1448: ar_receivable_applications app
1449: where app.gl_date+0 <= p_as_of_date
1450: and ps.cash_receipt_id+0 = app.cash_receipt_id
1451: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')

Line 1617: from ar_payment_schedules ps,

1613: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
1614: decode(v_bucket_category,
1615: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1616: 1))) b6
1617: from ar_payment_schedules ps,
1618: ar_receivable_applications app
1619: where app.gl_date+0 > p_as_of_date
1620: and ps.cash_receipt_id = app.cash_receipt_id /*4436914*/
1621: and (ps.payment_schedule_id = app.applied_payment_schedule_id

Line 1656: ar_payment_schedules_all ps

1652: ps.payment_schedule_id
1653: UNION ALL
1654: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
1655: FROM ar_adjustments adj,
1656: ar_payment_schedules_all ps
1657: WHERE adj.GL_date > p_as_of_date
1658: AND ps.payment_schedule_id = adj.payment_schedule_id
1659: AND adj.status = 'A'
1660: AND ps.gl_date_closed > p_as_of_date

Line 1818: from ar_payment_schedules ps,

1814: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
1815: decode(v_bucket_category,
1816: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1817: 1))) b6
1818: from ar_payment_schedules ps,
1819: ra_cust_trx_types rctt
1820: where ps.gl_date <= p_as_of_date
1821: and ps.gl_date_closed > p_as_of_date
1822: and ps.cust_trx_type_id = rctt.cust_trx_type_id

Line 1969: from ar_payment_schedules ps,

1965: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
1966: decode(v_bucket_category,
1967: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1968: 1))) b6
1969: from ar_payment_schedules ps,
1970: ar_receivable_applications app
1971: where app.gl_date+0 <= p_as_of_date
1972: and ps.cash_receipt_id+0 = app.cash_receipt_id
1973: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')

Line 2138: from ar_payment_schedules ps,

2134: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
2135: decode(v_bucket_category,
2136: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2137: 1))) b6
2138: from ar_payment_schedules ps,
2139: ar_receivable_applications app
2140: where app.gl_date+0 > p_as_of_date
2141: and ps.cash_receipt_id = app.cash_receipt_id /*4436914*/
2142: and (ps.payment_schedule_id = app.applied_payment_schedule_id

Line 2176: ar_payment_schedules_all ps

2172: ps.payment_schedule_id
2173: UNION ALL
2174: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
2175: FROM ar_adjustments adj,
2176: ar_payment_schedules_all ps
2177: WHERE adj.GL_date > p_as_of_date
2178: AND ps.payment_schedule_id = adj.payment_schedule_id
2179: AND adj.status = 'A'
2180: AND ps.gl_date_closed > p_as_of_date

Line 2338: ar_payment_schedules ps

2334: decode(v_bucket_category,
2335: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2336: 1))) b6
2337: from ra_cust_trx_types,
2338: ar_payment_schedules ps
2339: where ps.gl_date <= p_as_of_date
2340: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
2341: and ps.gl_date_closed > p_as_of_date
2342: and ps.customer_id = p_customer_id

Line 2494: from ar_payment_schedules ps,

2490: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
2491: decode(v_bucket_category,
2492: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2493: 1))) b6
2494: from ar_payment_schedules ps,
2495: ar_receivable_applications app
2496: where app.gl_date+0 <= p_as_of_date
2497: and ps.cash_receipt_id+0 = app.cash_receipt_id
2498: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')

Line 2663: from ar_payment_schedules ps,

2659: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
2660: decode(v_bucket_category,
2661: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2662: 1))) b6
2663: from ar_payment_schedules ps,
2664: ar_receivable_applications app
2665: where app.gl_date+0 > p_as_of_date
2666: and ps.cash_receipt_id = app.cash_receipt_id /*4436914*/
2667: and (ps.payment_schedule_id = app.applied_payment_schedule_id

Line 2701: ar_payment_schedules_all ps

2697: ps.payment_schedule_id
2698: UNION ALL
2699: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
2700: FROM ar_adjustments adj,
2701: ar_payment_schedules_all ps
2702: WHERE adj.GL_date > p_as_of_date
2703: AND ps.payment_schedule_id = adj.payment_schedule_id
2704: AND adj.status = 'A'
2705: AND ps.gl_date_closed > p_as_of_date

Line 3051: FROM ar_payment_schedules ps,

3047: CURSOR c_credits IS
3048: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
3049: ps.acctd_amount_due_remaining,
3050: ps.amount_due_remaining)), 0)
3051: FROM ar_payment_schedules ps,
3052: ra_cust_trx_line_gl_dist gld
3053: WHERE ps.customer_id = p_customer_id
3054: AND decode(p_customer_site_use_id,
3055: NULL, ps.customer_site_use_id,

Line 3115: ar_payment_schedules ps

3111: DECODE(p_currency_code, NULL,
3112: -app.acctd_amount_applied_from,
3113: -app.amount_applied),0), 0) ), 0)
3114: FROM ar_receivable_applications app,
3115: ar_payment_schedules ps
3116: WHERE ps.customer_id = p_customer_id
3117: AND ps.cash_receipt_id = app.cash_receipt_id
3118: AND nvl( app.confirmed_flag, 'Y' ) = 'Y'
3119: AND app.status in ( 'UNAPP', 'ACC' ,'OTHER ACC')

Line 3142: ar_payment_schedules ps

3138: DECODE(p_currency_code, NULL,
3139: -app.acctd_amount_applied_from,
3140: -app.amount_applied),0), 0) ), 0)
3141: FROM ar_receivable_applications app,
3142: ar_payment_schedules ps
3143: WHERE ps.customer_id = p_customer_id
3144: AND ps.customer_site_use_id = p_customer_site_use_id
3145: AND ps.cash_receipt_id = app.cash_receipt_id
3146: AND nvl( app.confirmed_flag, 'Y' ) = 'Y'

Line 3170: ar_payment_schedules ps

3166: DECODE(p_currency_code, NULL,
3167: -app.acctd_amount_applied_from,
3168: -app.amount_applied),0), 0) ), 0)
3169: FROM ar_receivable_applications app,
3170: ar_payment_schedules ps
3171: WHERE ps.customer_id = p_customer_id
3172: AND ps.cash_receipt_id = app.cash_receipt_id
3173: AND nvl( app.confirmed_flag, 'Y' ) = 'Y'
3174: AND app.status in ( 'UNAPP', 'ACC' ,'OTHER ACC')

Line 3198: ar_payment_schedules ps

3194: DECODE(p_currency_code, NULL,
3195: -app.acctd_amount_applied_from,
3196: -app.amount_applied),0), 0) ), 0)
3197: FROM ar_receivable_applications app,
3198: ar_payment_schedules ps
3199: WHERE ps.customer_id = p_customer_id
3200: AND ps.customer_site_use_id = p_customer_site_use_id
3201: AND ps.cash_receipt_id = app.cash_receipt_id
3202: AND nvl( app.confirmed_flag, 'Y' ) = 'Y'

Line 3300: FROM ar_payment_schedules ps

3296: p_dispute OUT NOCOPY NUMBER
3297: ) IS
3298: CURSOR c_dispute IS
3299: SELECT NVL(SUM(decode(p_currency_code,NULL,ps.amount_in_dispute * nvl(ps.exchange_rate,1), ps.amount_in_dispute)),0)
3300: FROM ar_payment_schedules ps
3301: WHERE ps.customer_id = p_customer_id
3302: AND decode(p_customer_site_use_id,
3303: NULL, ps.customer_site_use_id,
3304: p_customer_site_use_id) = ps.customer_site_use_id

Line 3336: FROM ar_payment_schedules ps

3332: p_pending_adj OUT NOCOPY NUMBER
3333: ) IS
3334: CURSOR c_pending_adj IS
3335: SELECT NVL( SUM( ps.amount_adjusted_pending ), 0)
3336: FROM ar_payment_schedules ps
3337: WHERE ps.customer_id = p_customer_id
3338: AND decode(p_customer_site_use_id,
3339: NULL, ps.customer_site_use_id,
3340: p_customer_site_use_id) = ps.customer_site_use_id