[Home] [Help]
448: decode(v_bucket_category,
449: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
450: 1))) b6
451: from ar_payment_schedules ps,
452: ar_receivable_applications app
453: where app.gl_date+0 <= p_as_of_date
454: and ps.cash_receipt_id+0 = app.cash_receipt_id
455: and app.status in ( 'ACC', 'UNAPP', 'UNID','OTHER ACC')
456: and nvl(app.confirmed_flag, 'Y') = 'Y'
1061: DECODE(app.applied_payment_schedule_id, -7,
1062: DECODE(p_currency_code, NULL,
1063: -app.acctd_amount_applied_from,
1064: -app.amount_applied),0), 0) ), 0)
1065: FROM ar_receivable_applications app,
1066: ar_payment_schedules ps,
1067: hz_cust_accounts hzca
1068: WHERE ps.customer_id = hzca.cust_account_id
1069: AND hzca.party_id = p_filter_id
1097: DECODE(app.applied_payment_schedule_id, -7,
1098: DECODE(p_currency_code, NULL,
1099: -app.acctd_amount_applied_from,
1100: -app.amount_applied),0), 0) ), 0)
1101: FROM ar_receivable_applications app,
1102: ar_payment_schedules ps,
1103: hz_cust_accounts hzca
1104: WHERE ps.customer_id = hzca.cust_account_id
1105: AND hzca.party_id IN
1146: DECODE(app.applied_payment_schedule_id, -7,
1147: DECODE(p_currency_code, NULL,
1148: -app.acctd_amount_applied_from,
1149: -app.amount_applied),0), 0) ), 0)
1150: FROM ar_receivable_applications app,
1151: ar_payment_schedules ps
1152: WHERE ps.customer_id = p_filter_id
1153: AND decode(p_customer_site_use_id,
1154: NULL, nvl(ps.customer_site_use_id,-10),
1182: DECODE(app.applied_payment_schedule_id, -7,
1183: DECODE(p_currency_code, NULL,
1184: -app.acctd_amount_applied_from,
1185: -app.amount_applied),0), 0) ), 0)
1186: FROM ar_receivable_applications app,
1187: ar_payment_schedules ps
1188: WHERE ps.customer_site_use_id = p_filter_id
1189: AND ps.cash_receipt_id = app.cash_receipt_id
1190: AND nvl( app.confirmed_flag, 'Y' ) = 'Y'
1214: DECODE(app.applied_payment_schedule_id, -7,
1215: DECODE(p_currency_code, NULL,
1216: -app.acctd_amount_applied_from,
1217: -app.amount_applied),0), 0) ), 0)
1218: FROM ar_receivable_applications app,
1219: ar_payment_schedules ps,
1220: hz_cust_site_uses hzsu,
1221: hz_cust_acct_sites hzas
1222: WHERE ps.customer_id = hzas.cust_account_id
1333: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1334: /* 06-AUG-2000 J Rautiainen BR Implementation
1335: * Short term debt applications are not considered as receipts at risk */
1336: and not exists (select 'X'
1337: from ar_receivable_applications rap
1338: where rap.cash_receipt_id = cr.cash_receipt_id
1339: and rap.applied_payment_schedule_id = -2
1340: and rap.display = 'Y');
1341:
1364: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1365: /* 06-AUG-2000 J Rautiainen BR Implementation
1366: * Short term debt applications are not considered as receipts at risk */
1367: and not exists (select 'X'
1368: from ar_receivable_applications rap
1369: where rap.cash_receipt_id = cr.cash_receipt_id
1370: and rap.applied_payment_schedule_id = -2
1371: and rap.display = 'Y');
1372:
1403: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1404: /* 06-AUG-2000 J Rautiainen BR Implementation
1405: * Short term debt applications are not considered as receipts at risk */
1406: and not exists (select 'X'
1407: from ar_receivable_applications rap
1408: where rap.cash_receipt_id = cr.cash_receipt_id
1409: and rap.applied_payment_schedule_id = -2
1410: and rap.display = 'Y');
1411:
1434: 'RISK_ELIMINATED','N', 'CLEARED'), 'REVERSED' )
1435: /* 06-AUG-2000 J Rautiainen BR Implementation
1436: * Short term debt applications are not considered as receipts at risk */
1437: and not exists (select 'X'
1438: from ar_receivable_applications rap
1439: where rap.cash_receipt_id = cr.cash_receipt_id
1440: and rap.applied_payment_schedule_id = -2
1441: and rap.display = 'Y')
1442: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */