[Home] [Help]
450: decode(v_bucket_category,
451: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
452: 1))) b6
453: from ar_payment_schedules ps,
454: ar_receivable_applications app
455: where app.gl_date+0 <= p_as_of_date
456: and ps.cash_receipt_id+0 = app.cash_receipt_id
457: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')
458: and nvl(app.confirmed_flag, 'Y') = 'Y'
1081: DECODE(app.applied_payment_schedule_id, -7,
1082: DECODE(p_currency_code, NULL,
1083: -app.acctd_amount_applied_from,
1084: -app.amount_applied),0), 0) ), 0)
1085: FROM ar_receivable_applications app,
1086: ar_payment_schedules ps,
1087: hz_cust_accounts hzca
1088: WHERE ps.customer_id = hzca.cust_account_id
1089: AND hzca.party_id = p_filter_id
1117: DECODE(app.applied_payment_schedule_id, -7,
1118: DECODE(p_currency_code, NULL,
1119: -app.acctd_amount_applied_from,
1120: -app.amount_applied),0), 0) ), 0)
1121: FROM ar_receivable_applications app,
1122: ar_payment_schedules ps,
1123: hz_cust_accounts hzca
1124: WHERE ps.customer_id = hzca.cust_account_id
1125: AND hzca.party_id IN
1166: DECODE(app.applied_payment_schedule_id, -7,
1167: DECODE(p_currency_code, NULL,
1168: -app.acctd_amount_applied_from,
1169: -app.amount_applied),0), 0) ), 0)
1170: FROM ar_receivable_applications app,
1171: ar_payment_schedules ps
1172: WHERE ps.customer_id = p_filter_id
1173: AND decode(p_customer_site_use_id,
1174: NULL, nvl(ps.customer_site_use_id,-10),
1202: DECODE(app.applied_payment_schedule_id, -7,
1203: DECODE(p_currency_code, NULL,
1204: -app.acctd_amount_applied_from,
1205: -app.amount_applied),0), 0) ), 0)
1206: FROM ar_receivable_applications app,
1207: ar_payment_schedules ps
1208: WHERE ps.customer_site_use_id = p_filter_id
1209: AND ps.cash_receipt_id = app.cash_receipt_id
1210: AND nvl( app.confirmed_flag, 'Y' ) = 'Y'
1234: DECODE(app.applied_payment_schedule_id, -7,
1235: DECODE(p_currency_code, NULL,
1236: -app.acctd_amount_applied_from,
1237: -app.amount_applied),0), 0) ), 0)
1238: FROM ar_receivable_applications app,
1239: ar_payment_schedules ps,
1240: hz_cust_site_uses hzsu,
1241: hz_cust_acct_sites hzas
1242: WHERE ps.customer_id = hzas.cust_account_id
1353: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1354: /* 06-AUG-2000 J Rautiainen BR Implementation
1355: * Short term debt applications are not considered as receipts at risk */
1356: and not exists (select 'X'
1357: from ar_receivable_applications rap
1358: where rap.cash_receipt_id = cr.cash_receipt_id
1359: and rap.applied_payment_schedule_id = -2
1360: and rap.display = 'Y');
1361:
1384: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1385: /* 06-AUG-2000 J Rautiainen BR Implementation
1386: * Short term debt applications are not considered as receipts at risk */
1387: and not exists (select 'X'
1388: from ar_receivable_applications rap
1389: where rap.cash_receipt_id = cr.cash_receipt_id
1390: and rap.applied_payment_schedule_id = -2
1391: and rap.display = 'Y');
1392:
1423: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1424: /* 06-AUG-2000 J Rautiainen BR Implementation
1425: * Short term debt applications are not considered as receipts at risk */
1426: and not exists (select 'X'
1427: from ar_receivable_applications rap
1428: where rap.cash_receipt_id = cr.cash_receipt_id
1429: and rap.applied_payment_schedule_id = -2
1430: and rap.display = 'Y');
1431:
1454: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1455: /* 06-AUG-2000 J Rautiainen BR Implementation
1456: * Short term debt applications are not considered as receipts at risk */
1457: and not exists (select 'X'
1458: from ar_receivable_applications rap
1459: where rap.cash_receipt_id = cr.cash_receipt_id
1460: and rap.applied_payment_schedule_id = -2
1461: and rap.display = 'Y')
1462: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */