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_BUS_EVENT_COVER dependencies on AR_PAYMENT_SCHEDULES

Line 235: FROM AR_PAYMENT_SCHEDULES_ALL

231: THEN
232:
233: SELECT org_id
234: INTO l_org_id
235: FROM AR_PAYMENT_SCHEDULES_ALL
236: WHERE payment_schedule_id = p_unique_id;
237:
238: ELSIF p_column_name = 'CUSTOMER_TRX_ID'
239: THEN

Line 338: from ar_payment_schedules prev_trx_ps,

334: prev_trx_ps.amount_applied,
335: prev_trx_ps.class,
336: prev_trx_ps.amount_credited,
337: prev_trx_ps.due_date
338: from ar_payment_schedules prev_trx_ps,
339: ra_customer_trx ctx
340: where ctx.customer_trx_id = p_ctx_id
341: and ctx.previous_customer_trx_id = prev_trx_ps.customer_trx_id
342: ;

Line 506: from ar_payment_schedules prev_trx_ps,

502: prev_trx_ps.class,
503: prev_trx_ps.amount_credited,
504: prev_trx_ps.due_date,
505: ctx.previous_customer_trx_id
506: from ar_payment_schedules prev_trx_ps,
507: ra_customer_trx ctx
508: where ctx.customer_trx_id = p_ctx_id
509: and ctx.previous_customer_trx_id = prev_trx_ps.customer_trx_id
510: ;

Line 757: l_cust_account_id ar_payment_schedules.customer_id%type;

753: l_key VARCHAR2(240);
754: l_exist VARCHAR2(1);
755: l_event_name VARCHAR2(50) := 'oracle.apps.ar.receipts.CashReceipt.create';
756:
757: l_cust_account_id ar_payment_schedules.customer_id%type;
758: l_org_id NUMBER;
759:
760: -- bug 3979914.
761: CURSOR getCustomerC IS

Line 763: FROM ar_payment_schedules

759:
760: -- bug 3979914.
761: CURSOR getCustomerC IS
762: SELECT nvl(customer_id, -99) cust_account_id
763: FROM ar_payment_schedules
764: WHERE payment_schedule_id = p_payment_schedule_id;
765:
766: BEGIN
767: IF PG_DEBUG in ('Y', 'C') THEN

Line 1088: ar_payment_schedules inv_ps,

1084: rcpt_ps.status rcpt_ps_status,
1085: to_char(inv_ps.due_date , 'J') due_date,
1086: inv_ps.amount_applied
1087: from ar_receivable_applications ra,
1088: ar_payment_schedules inv_ps,
1089: ar_payment_schedules rcpt_ps
1090: where ra.receivable_application_id = ra_id
1091: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1092: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;

Line 1089: ar_payment_schedules rcpt_ps

1085: to_char(inv_ps.due_date , 'J') due_date,
1086: inv_ps.amount_applied
1087: from ar_receivable_applications ra,
1088: ar_payment_schedules inv_ps,
1089: ar_payment_schedules rcpt_ps
1090: where ra.receivable_application_id = ra_id
1091: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1092: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;
1093: l_trx_ps_status VARCHAR2(10);

Line 1188: ar_payment_schedules inv_ps,

1184: inv_ps.amount_due_remaining,
1185: ra.earned_discount_taken,
1186: ra.unearned_discount_taken
1187: from ar_receivable_applications ra,
1188: ar_payment_schedules inv_ps,
1189: ar_payment_schedules rcpt_ps
1190: where ra.receivable_application_id = ra_id
1191: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1192: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;

Line 1189: ar_payment_schedules rcpt_ps

1185: ra.earned_discount_taken,
1186: ra.unearned_discount_taken
1187: from ar_receivable_applications ra,
1188: ar_payment_schedules inv_ps,
1189: ar_payment_schedules rcpt_ps
1190: where ra.receivable_application_id = ra_id
1191: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1192: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;
1193: l_old_trx_ps_status VARCHAR2(10);

Line 1354: ar_payment_schedules inv_ps,

1350: cm_ps.status cm_ps_status,
1351: to_char(inv_ps.due_date , 'J') due_date,
1352: inv_ps.amount_applied
1353: from ar_receivable_applications ra,
1354: ar_payment_schedules inv_ps,
1355: ar_payment_schedules cm_ps
1356: where ra.receivable_application_id = ra_id
1357: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1358: and ra.payment_schedule_id = cm_ps.payment_schedule_id;

Line 1355: ar_payment_schedules cm_ps

1351: to_char(inv_ps.due_date , 'J') due_date,
1352: inv_ps.amount_applied
1353: from ar_receivable_applications ra,
1354: ar_payment_schedules inv_ps,
1355: ar_payment_schedules cm_ps
1356: where ra.receivable_application_id = ra_id
1357: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1358: and ra.payment_schedule_id = cm_ps.payment_schedule_id;
1359:

Line 1449: ar_payment_schedules inv_ps,

1445: cm_ps.status cm_ps_status,
1446: to_char(inv_ps.due_date , 'J') due_date,
1447: inv_ps.amount_applied
1448: from ar_receivable_applications ra,
1449: ar_payment_schedules inv_ps,
1450: ar_payment_schedules cm_ps
1451: where ra.receivable_application_id = ra_id
1452: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1453: and ra.payment_schedule_id = cm_ps.payment_schedule_id;

Line 1450: ar_payment_schedules cm_ps

1446: to_char(inv_ps.due_date , 'J') due_date,
1447: inv_ps.amount_applied
1448: from ar_receivable_applications ra,
1449: ar_payment_schedules inv_ps,
1450: ar_payment_schedules cm_ps
1451: where ra.receivable_application_id = ra_id
1452: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1453: and ra.payment_schedule_id = cm_ps.payment_schedule_id;
1454: