[Home] [Help]
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')
393: and nvl(app.confirmed_flag, 'Y') = 'Y'
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
565: OR
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')
923: and nvl(app.confirmed_flag, 'Y') = 'Y'
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
1093: OR
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')
1452: and nvl(app.confirmed_flag, 'Y') = 'Y'
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
1622: OR
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')
1974: and nvl(app.confirmed_flag, 'Y') = 'Y'
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
2143: OR
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')
2499: and nvl(app.confirmed_flag, 'Y') = 'Y'
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
2668: OR
3110: DECODE(app.applied_payment_schedule_id, -7,
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'
3137: DECODE(app.applied_payment_schedule_id, -7,
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
3165: DECODE(app.applied_payment_schedule_id, -7,
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'
3193: DECODE(app.applied_payment_schedule_id, -7,
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
3267: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
3268: /* 06-AUG-2000 J Rautiainen BR Implementation
3269: * Short term debt applications are not considered as receipts at risk */
3270: and not exists (select 'X'
3271: from ar_receivable_applications rap
3272: where rap.cash_receipt_id = cr.cash_receipt_id
3273: and rap.applied_payment_schedule_id = -2
3274: and rap.display = 'Y');
3275: -- bug 1865105 ends