[Home] [Help]
1226: acr.receipt_number,
1227: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1228: FROM ar_payment_schedules apsa,
1229: ar_cash_receipts acr,
1230: ar_receivable_applications ara,
1231: ar_cash_receipt_history acrh,
1232: iex_delinquencies del
1233: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1234: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1279: l_data_query := l_data_query || ' TRX_SUM.LAST_PAYMENT_AMOUNT, TRX_SUM.CURRENCY, TRX_SUM.LAST_PAYMENT_NUMBER, ';
1280: l_data_query := l_data_query || ' ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(''CHECK_STATUS'', CR.STATUS) ';
1281: l_data_from := 'FROM ';
1282: l_data_from := l_data_from || ' AR_TRX_BAL_SUMMARY TRX_SUM, HZ_CUST_ACCOUNTS CA, AR_CASH_RECEIPTS CR, ';
1283: l_data_from := l_data_from || ' AR_RECEIVABLE_APPLICATIONS RA, AR_PAYMENT_SCHEDULES PS ';
1284: l_data_where := 'WHERE TRX_SUM.CUST_ACCOUNT_ID = :1 ';
1285: l_data_where := l_data_where || ' and TRX_SUM.SITE_USE_ID = :2 ';
1286: l_data_where := l_data_where || ' and TRX_SUM.ORG_ID = :3 ';
1287: l_data_where := l_data_where || ' and TRX_SUM.CURRENCY = :4 ';
1351: -- Begin - fix bug #5665646- ehuh -2/27/2007-remove duplicate code
1352: -- IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1353: -- OPEN c_last_pmt2 FOR
1354: -- SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1355: -- FROM ar_receivable_applications ra,
1356: -- ar_payment_schedules ps
1357: -- WHERE ra.cash_receipt_id = l_receipt
1358: -- AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1359: --
1385: -- trx_sum.last_payment_number,
1386: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1387: -- FROM ar_trx_bal_summary trx_sum,
1388: -- hz_cust_accounts ca, ar_cash_receipts cr,
1389: -- ar_receivable_applications ra,
1390: -- ar_payment_schedules ps
1391: -- WHERE trx_sum.cust_account_id = ca.cust_account_id
1392: -- AND ca.party_id = p_object_id
1393: -- AND cr.receipt_number = trx_sum.last_payment_number
1429: IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1430:
1431: OPEN c_last_pmt2 FOR
1432: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1433: FROM ar_receivable_applications ra,
1434: ar_payment_schedules ps
1435: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1436: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1437:
1449: -- trx_sum.last_payment_number,
1450: -- ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1451: -- FROM ar_trx_bal_summary trx_sum,
1452: -- ar_cash_receipts cr,
1453: -- ar_receivable_applications ra,
1454: -- ar_payment_schedules ps
1455: -- WHERE trx_sum.cust_account_id = p_object_id
1456: -- AND cr.receipt_number = trx_sum.last_payment_number
1457: -- AND ra.cash_receipt_id(+) = cr.cash_receipt_id
1492: IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1493:
1494: OPEN c_last_pmt2 FOR
1495: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1496: FROM ar_receivable_applications ra,
1497: ar_payment_schedules ps
1498: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1499: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1500:
1513: acr.receipt_number,
1514: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1515: FROM ar_payment_schedules apsa,
1516: ar_cash_receipts acr,
1517: ar_receivable_applications ara,
1518: ar_cash_receipt_history acrh,
1519: iex_delinquencies del
1520: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1521: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1530: -- Begin fix bug #4932926-JYPARK-02/07/2006-remove unecesaary query for performance
1531: --AND ACR.receipt_date =
1532: -- (SELECT max(a.receipt_date)
1533: -- FROM ar_cash_receipts a,
1534: -- ar_receivable_applications b,
1535: -- ar_cash_receipt_history c
1536: -- WHERE a.cash_receipt_id = b.cash_receipt_id
1537: -- AND b.applied_payment_schedule_id = apsa.payment_schedule_id
1538: -- AND a.reversal_date is null
1579: IF x_last_pmt_info_rec.cash_receipt_id IS NOT NULL THEN
1580:
1581: OPEN c_last_pmt2 FOR
1582: SELECT decode(ps.payment_schedule_id, -1, null, ps.due_date)
1583: FROM ar_receivable_applications ra,
1584: ar_payment_schedules ps
1585: WHERE ra.cash_receipt_id = x_last_pmt_info_rec.cash_receipt_id
1586: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
1587: