[Home] [Help]
1116: acr.receipt_number,
1117: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1118: FROM ar_payment_schedules apsa,
1119: ar_cash_receipts acr,
1120: ar_receivable_applications ara,
1121: ar_cash_receipt_history acrh,
1122: iex_delinquencies del
1123: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1124: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1169: l_data_query := l_data_query || ' TRX_SUM.LAST_PAYMENT_AMOUNT, TRX_SUM.CURRENCY, TRX_SUM.LAST_PAYMENT_NUMBER, ';
1170: l_data_query := l_data_query || ' ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(''CHECK_STATUS'', CR.STATUS) ';
1171: l_data_from := 'FROM ';
1172: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA, AR_CASH_RECEIPTS CR, ';
1173: l_data_from := l_data_from || ' AR_RECEIVABLE_APPLICATIONS RA, AR_PAYMENT_SCHEDULES PS ';
1174: l_data_where := 'WHERE TRX_SUM.CUST_ACCOUNT_ID = :1 ';
1175: l_data_where := l_data_where || ' and TRX_SUM.SITE_USE_ID = :2 ';
1176: l_data_where := l_data_where || ' and TRX_SUM.ORG_ID = :3 ';
1177: l_data_where := l_data_where || ' and TRX_SUM.CURRENCY = :4 ';
1236: -- Begin - fix bug #5665646- ehuh -2/27/2007-remove duplicate code
1237: -- IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1238: -- OPEN c_last_pmt2 FOR
1239: -- SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1240: -- FROM ar_receivable_applications ra,
1241: -- ar_payment_schedules ps
1242: -- WHERE ra.cash_receipt_id = l_receipt
1243: -- AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1244: --
1270: -- trx_sum.last_payment_number,
1271: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1272: -- FROM ar_trx_bal_summary trx_sum,
1273: -- hz_cust_accounts ca, ar_cash_receipts cr,
1274: -- ar_receivable_applications ra,
1275: -- ar_payment_schedules ps
1276: -- WHERE trx_sum.cust_account_id = ca.cust_account_id
1277: -- AND ca.party_id = p_object_id
1278: -- AND cr.receipt_number = trx_sum.last_payment_number
1314: IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1315:
1316: OPEN c_last_pmt2 FOR
1317: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1318: FROM ar_receivable_applications ra,
1319: ar_payment_schedules ps
1320: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1321: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1322:
1334: -- trx_sum.last_payment_number,
1335: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1336: -- FROM ar_trx_bal_summary trx_sum,
1337: -- ar_cash_receipts cr,
1338: -- ar_receivable_applications ra,
1339: -- ar_payment_schedules ps
1340: -- WHERE trx_sum.cust_account_id = p_object_id
1341: -- AND cr.receipt_number = trx_sum.last_payment_number
1342: -- AND ra.cash_receipt_id(+) = cr.cash_receipt_id
1377: IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1378:
1379: OPEN c_last_pmt2 FOR
1380: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1381: FROM ar_receivable_applications ra,
1382: ar_payment_schedules ps
1383: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1384: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1385:
1398: acr.receipt_number,
1399: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1400: FROM ar_payment_schedules apsa,
1401: ar_cash_receipts acr,
1402: ar_receivable_applications ara,
1403: ar_cash_receipt_history acrh,
1404: iex_delinquencies del
1405: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1406: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1415: -- Begin fix bug #4932926-JYPARK-02/07/2006-remove unecesaary query for performance
1416: --AND ACR.receipt_date =
1417: -- (SELECT max(a.receipt_date)
1418: -- FROM ar_cash_receipts a,
1419: -- ar_receivable_applications b,
1420: -- ar_cash_receipt_history c
1421: -- WHERE a.cash_receipt_id = b.cash_receipt_id
1422: -- AND b.applied_payment_schedule_id = apsa.payment_schedule_id
1423: -- AND a.reversal_date is null
1464: IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1465:
1466: OPEN c_last_pmt2 FOR
1467: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1468: FROM ar_receivable_applications ra,
1469: ar_payment_schedules ps
1470: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1471: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1472: