[Home] [Help]
1113: decode(apsa.payment_schedule_id, -1, null, APSA.due_date),
1114: ara.amount_applied amount,
1115: apsa.invoice_currency_Code currency_code ,
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,
1166: IF l_show_last_pmt_due = 'Y' THEN
1167: l_data_query := 'SELECT TRX_SUM.LAST_PAYMENT_DATE, CR.CASH_RECEIPT_ID, ';
1168: l_data_query := l_data_query || ' DECODE(PS.PAYMENT_SCHEDULE_ID, -1, NULL, PS.DUE_DATE), ';
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 ';
1267: -- decode(ps.payment_schedule_id, -1, null, ps.due_date),
1268: -- trx_sum.last_payment_amount,
1269: -- trx_sum.currency,
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
1294: cr.cash_receipt_id,
1295: trx_sum.last_payment_amount,
1296: trx_sum.currency,
1297: trx_sum.last_payment_number,
1298: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1299: FROM ar_trx_bal_summary trx_sum,
1300: hz_cust_accounts ca, ar_cash_receipts cr
1301: WHERE trx_sum.cust_account_id = ca.cust_account_id
1302: AND ca.party_id = p_object_id
1331: -- decode(ps.payment_schedule_id, -1, null, ps.due_date),
1332: -- trx_sum.last_payment_amount,
1333: -- trx_sum.currency,
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
1357: cr.cash_receipt_id,
1358: trx_sum.last_payment_amount,
1359: trx_sum.currency,
1360: trx_sum.last_payment_number,
1361: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1362: FROM ar_trx_bal_summary trx_sum,
1363: ar_cash_receipts cr
1364: WHERE trx_sum.cust_account_id = p_object_id
1365: AND cr.receipt_number = trx_sum.last_payment_number
1395: decode(apsa.payment_schedule_id, -1, null, APSA.due_date),
1396: ara.amount_applied amount,
1397: apsa.invoice_currency_Code currency_code ,
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,
1445: cr.cash_receipt_id,
1446: trx_sum.last_payment_amount,
1447: trx_sum.currency,
1448: trx_sum.last_payment_number,
1449: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', cr.status)
1450: FROM ar_trx_bal_summary trx_sum,
1451: ar_cash_receipts cr
1452: WHERE trx_sum.site_use_id = p_object_id
1453: AND cr.receipt_number = trx_sum.last_payment_number
1629: SELECT DECODE(CONTACT_POINT_PURPOSE, 'COLLECTIONS', 1, 2) C1,
1630: DECODE(PRIMARY_BY_PURPOSE, 'Y', 1, 2) C2,
1631: DECODE(PRIMARY_FLAG, 'Y', 1, 2) C3,
1632: contact_point_id, phone_country_code, phone_area_code, phone_number, phone_extension,
1633: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('PHONE_LINE_TYPE', phone_line_type) phone_line_type_meaning,
1634: email_address, contact_point_type
1635: FROM hz_contact_points
1636: WHERE owner_table_name = 'HZ_PARTIES'
1637: AND owner_table_id = x_party_id