eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 2608: FROM ar_payment_schedules_all

2604: SELECT amount_due_remaining,
2605: amount_due_original
2606: INTO l_amt_due_remaining,
2607: l_amt_due_original
2608: FROM ar_payment_schedules_all
2609: WHERE cash_receipt_id = p_cash_receipt_id;
2610:
2611: EXCEPTION
2612: WHEN no_data_found THEN

Line 2624: ar_payment_schedules_all ps

2620: SUM(ra.amount_applied_from)
2621: INTO l_amt_app_prev,
2622: l_amt_app_from_prev
2623: FROM ar_receivable_applications_all ra,
2624: ar_payment_schedules_all ps
2625: WHERE ra.cash_receipt_id = p_cash_receipt_id
2626: AND ra.status = 'APP'
2627: AND ra.display = 'Y'
2628: AND ra.trans_to_receipt_rate = p_trans_to_receipt_rate

Line 3534: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3530: END Default_disc_and_amt_applied;
3531:
3532: FUNCTION Get_trx_Line_amount(
3533: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3534: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3535: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3536: p_return_status OUT NOCOPY VARCHAR2
3537: ) RETURN NUMBER IS
3538:

Line 3551: ar_payment_schedules ps

3547: INTO l_trx_line_amount
3548: FROM ra_customer_trx_lines ctl ,
3549: ra_terms t ,
3550: ra_terms_lines tl ,
3551: ar_payment_schedules ps
3552: WHERE ps.payment_schedule_id = p_payment_schedule_id and
3553: ctl.customer_trx_id = p_customer_trx_id and
3554: ctl.line_type = 'LINE' and
3555: tl.term_id(+) = ps.term_id and

Line 3738: , ar_payment_schedules ps

3734: , ra_batch_sources bs
3735: , ar_lookups lu
3736: , hz_cust_accounts cust
3737: , ra_terms t
3738: , ar_payment_schedules ps
3739: , ar_cons_inv ci
3740: WHERE
3741: ps.class in ('CB','CM','DEP','DM','INV','BR')
3742: AND ps.selected_for_receipt_batch_id is null

Line 3835: , ar_payment_schedules ps

3831: , ra_batch_sources bs
3832: , ar_lookups lu
3833: , hz_cust_accounts cst
3834: , ra_terms t
3835: , ar_payment_schedules ps
3836: , ar_cons_inv ci
3837: WHERE
3838: ps.class in ('CB','CM','DEP','DM','INV','BR')
3839: AND ps.selected_for_receipt_batch_id is null

Line 4280: ar_payment_schedules ps,

4276: p_remittance_bank_account_id,
4277: p_receipt_method_id
4278: FROM ar_cash_receipts cr,
4279: ar_cash_receipt_history crh,
4280: ar_payment_schedules ps,
4281: ce_bank_acct_uses ba
4282: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4283: cr.cash_receipt_id = crh.cash_receipt_id and
4284: crh.first_posted_record_flag = 'Y' and /* bug 3333680 */

Line 4315: ar_payment_schedules ps,

4311: p_remittance_bank_account_id,
4312: p_receipt_method_id
4313: FROM ar_cash_receipts cr,
4314: ar_cash_receipt_history crh,
4315: ar_payment_schedules ps,
4316: ce_bank_acct_uses ba
4317: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4318: cr.cash_receipt_id = crh.cash_receipt_id and
4319: crh.first_posted_record_flag = 'N' and

Line 4711: FROM ar_payment_schedules

4707: p_group_id IN VARCHAR2, /* Bug 5284890 */
4708: p_return_status OUT NOCOPY VARCHAR2 ) IS
4709: CURSOR payment_schedule IS
4710: SELECT customer_trx_id,terms_sequence_number
4711: FROM ar_payment_schedules
4712: WHERE payment_schedule_id = p_applied_payment_schedule_id and
4713: payment_schedule_id >0 and
4714: class in ('INV','DM','DEP','CB','CM','BR');
4715: CURSOR install_number IS

Line 4717: FROM ar_payment_schedules

4713: payment_schedule_id >0 and
4714: class in ('INV','DM','DEP','CB','CM','BR');
4715: CURSOR install_number IS
4716: SELECT terms_sequence_number
4717: FROM ar_payment_schedules
4718: WHERE customer_trx_id = p_customer_trx_id;
4719: l_customer_trx_id NUMBER;
4720: l_installment NUMBER;
4721: p_return_status_lines VARCHAR2(100); /* Bug fix 3435834 */

Line 4784: FROM ar_payment_schedules

4780: IF p_installment IS NULL THEN
4781: BEGIN
4782: SELECT terms_sequence_number
4783: INTO p_installment
4784: FROM ar_payment_schedules
4785: WHERE customer_trx_id = p_customer_trx_id;
4786: EXCEPTION
4787: WHEN no_data_found THEN
4788: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');

Line 4812: from ar_payment_schedules

4808: p_llca_type is NOT NULL
4809: Then
4810: Begin
4811: select terms_sequence_number into l_installment
4812: from ar_payment_schedules
4813: where customer_trx_id = p_customer_trx_id;
4814: Exception
4815: WHEN no_data_found THEN
4816: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');

Line 5329: ar_payment_schedules ps

5325: BEGIN
5326: SELECT ps.payment_schedule_id
5327: INTO l_trx_ps_id
5328: FROM ra_customer_trx ct,
5329: ar_payment_schedules ps
5330: WHERE ct.customer_trx_id = p_customer_trx_id
5331: AND ct.customer_trx_id = ps.customer_trx_id
5332: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5333: AND ps.terms_sequence_number = p_installment

Line 5357: ar_payment_schedules ps

5353: BEGIN
5354: SELECT ps.payment_schedule_id
5355: INTO l_trx_ps_id
5356: FROM ra_customer_trx ct,
5357: ar_payment_schedules ps
5358: WHERE ct.customer_trx_id = p_customer_trx_id
5359: AND ct.customer_trx_id = ps.customer_trx_id
5360: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5361: ;

Line 5382: ar_payment_schedules ps

5378: BEGIN
5379: SELECT ps.payment_schedule_id
5380: INTO l_trx_ps_id
5381: FROM ra_customer_trx ct,
5382: ar_payment_schedules ps
5383: WHERE ct.customer_trx_id = p_customer_trx_id
5384: AND ct.customer_trx_id = ps.customer_trx_id
5385: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5386: AND ps.terms_sequence_number = p_installment

Line 5411: ar_payment_schedules ps

5407: BEGIN
5408: SELECT ps.payment_schedule_id
5409: INTO l_trx_ps_id
5410: FROM ra_customer_trx ct,
5411: ar_payment_schedules ps
5412: WHERE ct.customer_trx_id = p_customer_trx_id
5413: AND ct.customer_trx_id = ps.customer_trx_id
5414: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5415: --these two conditions are to ensure that the trx(bill) is not in remit process

Line 5498: FROM ar_payment_schedules ps

5494: p_called_from IN VARCHAR2,
5495: p_return_status OUT NOCOPY VARCHAR2 ) IS
5496: CURSOR payment_schedule IS
5497: SELECT ps.customer_trx_id, ps.terms_sequence_number
5498: FROM ar_payment_schedules ps
5499: WHERE ps.payment_schedule_id = p_ps_id
5500: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5501: --these two conditions are to ensure that the trx(bill) is not in remit process
5502: AND ps.reserved_type is null

Line 5507: FROM ar_payment_schedules ps

5503: AND ps.reserved_value is null;
5504:
5505: CURSOR payment_schedule_br_remit IS
5506: SELECT ps.customer_trx_id, ps.terms_sequence_number
5507: FROM ar_payment_schedules ps
5508: WHERE ps.payment_schedule_id = p_ps_id
5509: AND ps.class IN ('CB','CM','DEP','DM','INV','BR');
5510:
5511: BEGIN

Line 5563: ar_payment_schedules ps

5559: CURSOR rec_apppln IS
5560: SELECT ra.cash_receipt_id, ra.applied_payment_schedule_id, ra.gl_date /* Bug fix 3451241 */
5561: , ra.applied_customer_trx_id
5562: FROM ar_receivable_applications ra,
5563: ar_payment_schedules ps
5564: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
5565: AND ra.receivable_application_id = p_ra_id
5566: AND ra.display = 'Y'
5567: AND ra.status = 'APP'

Line 6863: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,

6859: END get_doc_seq;
6860:
6861: /* modified for tca uptake */
6862: PROCEDURE Derive_cust_info_from_trx(
6863: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,

6861: /* modified for tca uptake */
6862: PROCEDURE Derive_cust_info_from_trx(
6863: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6869: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

Line 6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6862: PROCEDURE Derive_cust_info_from_trx(
6863: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6869: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6870: p_return_status OUT NOCOPY VARCHAR2

Line 6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,

6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6869: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6870: p_return_status OUT NOCOPY VARCHAR2
6871: )IS
6872: /* modified for tca uptake */

Line 6888: ar_payment_schedules ps

6884: ps.customer_site_use_id
6885: FROM hz_cust_site_uses su,
6886: hz_cust_accounts cust_acct,
6887: ra_cust_trx_types ctt,
6888: ar_payment_schedules ps
6889: WHERE su.site_use_id = ps.customer_site_use_id
6890: and cust_acct.cust_account_id = ps.customer_id
6891: and ctt.cust_trx_type_id = ps.cust_trx_type_id
6892: and ps.selected_for_receipt_batch_id is null

Line 7985: FROM ar_payment_schedules

7981: IF p_applied_ps_id IS NOT NULL
7982: THEN
7983: BEGIN
7984: SELECT cash_receipt_id INTO p_open_cash_receipt_id
7985: FROM ar_payment_schedules
7986: WHERE payment_schedule_id = p_applied_ps_id;
7987: EXCEPTION when others then
7988: --raise error message
7989: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');