[Home] [Help]
1223: decode(apsa.payment_schedule_id, -1, null, APSA.due_date),
1224: ara.amount_applied amount,
1225: apsa.invoice_currency_Code currency_code ,
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,
1276: IF l_show_last_pmt_due = 'Y' THEN
1277: l_data_query := 'SELECT TRX_SUM.LAST_PAYMENT_DATE, CR.CASH_RECEIPT_ID, ';
1278: l_data_query := l_data_query || ' DECODE(PS.PAYMENT_SCHEDULE_ID, -1, NULL, PS.DUE_DATE), ';
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 ';
1382: -- decode(ps.payment_schedule_id, -1, null, ps.due_date),
1383: -- trx_sum.last_payment_amount,
1384: -- trx_sum.currency,
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
1409: cr.cash_receipt_id,
1410: trx_sum.last_payment_amount,
1411: trx_sum.currency,
1412: trx_sum.last_payment_number,
1413: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1414: FROM ar_trx_bal_summary trx_sum,
1415: hz_cust_accounts ca, ar_cash_receipts cr
1416: WHERE trx_sum.cust_account_id = ca.cust_account_id
1417: AND ca.party_id = p_object_id
1446: -- decode(ps.payment_schedule_id, -1, null, ps.due_date),
1447: -- trx_sum.last_payment_amount,
1448: -- trx_sum.currency,
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
1472: cr.cash_receipt_id,
1473: trx_sum.last_payment_amount,
1474: trx_sum.currency,
1475: trx_sum.last_payment_number,
1476: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1477: FROM ar_trx_bal_summary trx_sum,
1478: ar_cash_receipts cr
1479: WHERE trx_sum.cust_account_id = p_object_id
1480: AND cr.receipt_number = trx_sum.last_payment_number
1510: decode(apsa.payment_schedule_id, -1, null, APSA.due_date),
1511: ara.amount_applied amount,
1512: apsa.invoice_currency_Code currency_code ,
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,
1560: cr.cash_receipt_id,
1561: trx_sum.last_payment_amount,
1562: trx_sum.currency,
1563: trx_sum.last_payment_number,
1564: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1565: FROM ar_trx_bal_summary trx_sum,
1566: ar_cash_receipts cr
1567: WHERE trx_sum.site_use_id = p_object_id
1568: AND cr.receipt_number = trx_sum.last_payment_number
1744: SELECT DECODE(CONTACT_POINT_PURPOSE, 'COLLECTIONS', 1, 2) C1,
1745: DECODE(PRIMARY_BY_PURPOSE, 'Y', 1, 2) C2,
1746: DECODE(PRIMARY_FLAG, 'Y', 1, 2) C3,
1747: contact_point_id, phone_country_code, phone_area_code, phone_number, phone_extension,
1748: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('PHONE_LINE_TYPE', phone_line_type) phone_line_type_meaning,
1749: email_address, contact_point_type
1750: FROM hz_contact_points
1751: WHERE owner_table_name = 'HZ_PARTIES'
1752: AND owner_table_id = x_party_id