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 3352: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3348: END Default_disc_and_amt_applied;
3349:
3350: FUNCTION Get_trx_Line_amount(
3351: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3352: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3353: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3354: p_return_status OUT NOCOPY VARCHAR2
3355: ) RETURN NUMBER IS
3356:

Line 3369: ar_payment_schedules ps

3365: INTO l_trx_line_amount
3366: FROM ra_customer_trx_lines ctl ,
3367: ra_terms t ,
3368: ra_terms_lines tl ,
3369: ar_payment_schedules ps
3370: WHERE ps.payment_schedule_id = p_payment_schedule_id and
3371: ctl.customer_trx_id = p_customer_trx_id and
3372: ctl.line_type = 'LINE' and
3373: tl.term_id(+) = ps.term_id and

Line 3553: , ar_payment_schedules ps

3549: , ra_batch_sources bs
3550: , ar_lookups lu
3551: , hz_cust_accounts cust
3552: , ra_terms t
3553: , ar_payment_schedules ps
3554: , ar_cons_inv ci
3555: WHERE
3556: ps.class in ('CB','CM','DEP','DM','INV','BR')
3557: AND ps.selected_for_receipt_batch_id is null

Line 3650: , ar_payment_schedules ps

3646: , ra_batch_sources bs
3647: , ar_lookups lu
3648: , hz_cust_accounts cst
3649: , ra_terms t
3650: , ar_payment_schedules ps
3651: , ar_cons_inv ci
3652: WHERE
3653: ps.class in ('CB','CM','DEP','DM','INV','BR')
3654: AND ps.selected_for_receipt_batch_id is null

Line 4051: ar_payment_schedules ps,

4047: p_remittance_bank_account_id,
4048: p_receipt_method_id
4049: FROM ar_cash_receipts cr,
4050: ar_cash_receipt_history crh,
4051: ar_payment_schedules ps,
4052: ce_bank_acct_uses ba
4053: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4054: cr.cash_receipt_id = crh.cash_receipt_id and
4055: crh.first_posted_record_flag = 'Y' and /* bug 3333680 */

Line 4086: ar_payment_schedules ps,

4082: p_remittance_bank_account_id,
4083: p_receipt_method_id
4084: FROM ar_cash_receipts cr,
4085: ar_cash_receipt_history crh,
4086: ar_payment_schedules ps,
4087: ce_bank_acct_uses ba
4088: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4089: cr.cash_receipt_id = crh.cash_receipt_id and
4090: crh.first_posted_record_flag = 'N' and

Line 4482: FROM ar_payment_schedules

4478: p_group_id IN VARCHAR2, /* Bug 5284890 */
4479: p_return_status OUT NOCOPY VARCHAR2 ) IS
4480: CURSOR payment_schedule IS
4481: SELECT customer_trx_id,terms_sequence_number
4482: FROM ar_payment_schedules
4483: WHERE payment_schedule_id = p_applied_payment_schedule_id and
4484: payment_schedule_id >0 and
4485: class in ('INV','DM','DEP','CB','CM','BR');
4486: CURSOR install_number IS

Line 4488: FROM ar_payment_schedules

4484: payment_schedule_id >0 and
4485: class in ('INV','DM','DEP','CB','CM','BR');
4486: CURSOR install_number IS
4487: SELECT terms_sequence_number
4488: FROM ar_payment_schedules
4489: WHERE customer_trx_id = p_customer_trx_id;
4490: l_customer_trx_id NUMBER;
4491: l_installment NUMBER;
4492: p_return_status_lines VARCHAR2(100); /* Bug fix 3435834 */

Line 4555: FROM ar_payment_schedules

4551: IF p_installment IS NULL THEN
4552: BEGIN
4553: SELECT terms_sequence_number
4554: INTO p_installment
4555: FROM ar_payment_schedules
4556: WHERE customer_trx_id = p_customer_trx_id;
4557: EXCEPTION
4558: WHEN no_data_found THEN
4559: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');

Line 4583: from ar_payment_schedules

4579: p_llca_type is NOT NULL
4580: Then
4581: Begin
4582: select terms_sequence_number into l_installment
4583: from ar_payment_schedules
4584: where customer_trx_id = p_customer_trx_id;
4585: Exception
4586: WHEN no_data_found THEN
4587: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');

Line 5059: ar_payment_schedules ps

5055: BEGIN
5056: SELECT ps.payment_schedule_id
5057: INTO l_trx_ps_id
5058: FROM ra_customer_trx ct,
5059: ar_payment_schedules ps
5060: WHERE ct.customer_trx_id = p_customer_trx_id
5061: AND ct.customer_trx_id = ps.customer_trx_id
5062: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5063: AND ps.terms_sequence_number = p_installment

Line 5087: ar_payment_schedules ps

5083: BEGIN
5084: SELECT ps.payment_schedule_id
5085: INTO l_trx_ps_id
5086: FROM ra_customer_trx ct,
5087: ar_payment_schedules ps
5088: WHERE ct.customer_trx_id = p_customer_trx_id
5089: AND ct.customer_trx_id = ps.customer_trx_id
5090: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5091: ;

Line 5112: ar_payment_schedules ps

5108: BEGIN
5109: SELECT ps.payment_schedule_id
5110: INTO l_trx_ps_id
5111: FROM ra_customer_trx ct,
5112: ar_payment_schedules ps
5113: WHERE ct.customer_trx_id = p_customer_trx_id
5114: AND ct.customer_trx_id = ps.customer_trx_id
5115: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5116: AND ps.terms_sequence_number = p_installment

Line 5141: ar_payment_schedules ps

5137: BEGIN
5138: SELECT ps.payment_schedule_id
5139: INTO l_trx_ps_id
5140: FROM ra_customer_trx ct,
5141: ar_payment_schedules ps
5142: WHERE ct.customer_trx_id = p_customer_trx_id
5143: AND ct.customer_trx_id = ps.customer_trx_id
5144: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5145: --these two conditions are to ensure that the trx(bill) is not in remit process

Line 5228: FROM ar_payment_schedules ps

5224: p_called_from IN VARCHAR2,
5225: p_return_status OUT NOCOPY VARCHAR2 ) IS
5226: CURSOR payment_schedule IS
5227: SELECT ps.customer_trx_id, ps.terms_sequence_number
5228: FROM ar_payment_schedules ps
5229: WHERE ps.payment_schedule_id = p_ps_id
5230: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
5231: --these two conditions are to ensure that the trx(bill) is not in remit process
5232: AND ps.reserved_type is null

Line 5237: FROM ar_payment_schedules ps

5233: AND ps.reserved_value is null;
5234:
5235: CURSOR payment_schedule_br_remit IS
5236: SELECT ps.customer_trx_id, ps.terms_sequence_number
5237: FROM ar_payment_schedules ps
5238: WHERE ps.payment_schedule_id = p_ps_id
5239: AND ps.class IN ('CB','CM','DEP','DM','INV','BR');
5240:
5241: BEGIN

Line 5293: ar_payment_schedules ps

5289: CURSOR rec_apppln IS
5290: SELECT ra.cash_receipt_id, ra.applied_payment_schedule_id, ra.gl_date /* Bug fix 3451241 */
5291: , ra.applied_customer_trx_id
5292: FROM ar_receivable_applications ra,
5293: ar_payment_schedules ps
5294: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
5295: AND ra.receivable_application_id = p_ra_id
5296: AND ra.display = 'Y'
5297: AND ra.status = 'APP'

Line 6575: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,

6571: END get_doc_seq;
6572:
6573: /* modified for tca uptake */
6574: PROCEDURE Derive_cust_info_from_trx(
6575: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,

6573: /* modified for tca uptake */
6574: PROCEDURE Derive_cust_info_from_trx(
6575: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6580: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6581: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

Line 6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6574: PROCEDURE Derive_cust_info_from_trx(
6575: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6580: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6581: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6582: p_return_status OUT NOCOPY VARCHAR2

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

6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6580: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6581: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6582: p_return_status OUT NOCOPY VARCHAR2
6583: )IS
6584: /* modified for tca uptake */

Line 6600: ar_payment_schedules ps

6596: ps.customer_site_use_id
6597: FROM hz_cust_site_uses su,
6598: hz_cust_accounts cust_acct,
6599: ra_cust_trx_types ctt,
6600: ar_payment_schedules ps
6601: WHERE su.site_use_id = ps.customer_site_use_id
6602: and cust_acct.cust_account_id = ps.customer_id
6603: and ctt.cust_trx_type_id = ps.cust_trx_type_id
6604: and ps.selected_for_receipt_batch_id is null

Line 7686: FROM ar_payment_schedules

7682: IF p_applied_ps_id IS NOT NULL
7683: THEN
7684: BEGIN
7685: SELECT cash_receipt_id INTO p_open_cash_receipt_id
7686: FROM ar_payment_schedules
7687: WHERE payment_schedule_id = p_applied_ps_id;
7688: EXCEPTION when others then
7689: --raise error message
7690: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');