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 240: from ar_payment_schedules prev_trx_ps,

236: prev_trx_ps.amount_applied,
237: prev_trx_ps.class,
238: prev_trx_ps.amount_credited,
239: prev_trx_ps.due_date
240: from ar_payment_schedules prev_trx_ps,
241: ra_customer_trx ctx
242: where ctx.customer_trx_id = p_ctx_id
243: and ctx.previous_customer_trx_id = prev_trx_ps.customer_trx_id
244: ;

Line 401: from ar_payment_schedules prev_trx_ps,

397: prev_trx_ps.class,
398: prev_trx_ps.amount_credited,
399: prev_trx_ps.due_date,
400: ctx.previous_customer_trx_id
401: from ar_payment_schedules prev_trx_ps,
402: ra_customer_trx ctx
403: where ctx.customer_trx_id = p_ctx_id
404: and ctx.previous_customer_trx_id = prev_trx_ps.customer_trx_id
405: ;

Line 641: l_cust_account_id ar_payment_schedules.customer_id%type;

637: l_key VARCHAR2(240);
638: l_exist VARCHAR2(1);
639: l_event_name VARCHAR2(50) := 'oracle.apps.ar.receipts.CashReceipt.create';
640:
641: l_cust_account_id ar_payment_schedules.customer_id%type;
642: -- bug 3979914.
643: CURSOR getCustomerC IS
644: SELECT nvl(customer_id, -99) cust_account_id
645: FROM ar_payment_schedules

Line 645: FROM ar_payment_schedules

641: l_cust_account_id ar_payment_schedules.customer_id%type;
642: -- bug 3979914.
643: CURSOR getCustomerC IS
644: SELECT nvl(customer_id, -99) cust_account_id
645: FROM ar_payment_schedules
646: WHERE payment_schedule_id = p_payment_schedule_id;
647:
648: BEGIN
649: IF PG_DEBUG in ('Y', 'C') THEN

Line 944: ar_payment_schedules inv_ps,

940: rcpt_ps.status rcpt_ps_status,
941: to_char(inv_ps.due_date , 'J') due_date,
942: inv_ps.amount_applied
943: from ar_receivable_applications ra,
944: ar_payment_schedules inv_ps,
945: ar_payment_schedules rcpt_ps
946: where ra.receivable_application_id = ra_id
947: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
948: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;

Line 945: ar_payment_schedules rcpt_ps

941: to_char(inv_ps.due_date , 'J') due_date,
942: inv_ps.amount_applied
943: from ar_receivable_applications ra,
944: ar_payment_schedules inv_ps,
945: ar_payment_schedules rcpt_ps
946: where ra.receivable_application_id = ra_id
947: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
948: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;
949: l_trx_ps_status VARCHAR2(10);

Line 1037: ar_payment_schedules inv_ps,

1033: inv_ps.amount_due_remaining,
1034: ra.earned_discount_taken,
1035: ra.unearned_discount_taken
1036: from ar_receivable_applications ra,
1037: ar_payment_schedules inv_ps,
1038: ar_payment_schedules rcpt_ps
1039: where ra.receivable_application_id = ra_id
1040: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1041: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;

Line 1038: ar_payment_schedules rcpt_ps

1034: ra.earned_discount_taken,
1035: ra.unearned_discount_taken
1036: from ar_receivable_applications ra,
1037: ar_payment_schedules inv_ps,
1038: ar_payment_schedules rcpt_ps
1039: where ra.receivable_application_id = ra_id
1040: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1041: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id;
1042: l_old_trx_ps_status VARCHAR2(10);

Line 1197: ar_payment_schedules inv_ps,

1193: cm_ps.status cm_ps_status,
1194: to_char(inv_ps.due_date , 'J') due_date,
1195: inv_ps.amount_applied
1196: from ar_receivable_applications ra,
1197: ar_payment_schedules inv_ps,
1198: ar_payment_schedules cm_ps
1199: where ra.receivable_application_id = ra_id
1200: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1201: and ra.payment_schedule_id = cm_ps.payment_schedule_id;

Line 1198: ar_payment_schedules cm_ps

1194: to_char(inv_ps.due_date , 'J') due_date,
1195: inv_ps.amount_applied
1196: from ar_receivable_applications ra,
1197: ar_payment_schedules inv_ps,
1198: ar_payment_schedules cm_ps
1199: where ra.receivable_application_id = ra_id
1200: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1201: and ra.payment_schedule_id = cm_ps.payment_schedule_id;
1202:

Line 1287: ar_payment_schedules inv_ps,

1283: cm_ps.status cm_ps_status,
1284: to_char(inv_ps.due_date , 'J') due_date,
1285: inv_ps.amount_applied
1286: from ar_receivable_applications ra,
1287: ar_payment_schedules inv_ps,
1288: ar_payment_schedules cm_ps
1289: where ra.receivable_application_id = ra_id
1290: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1291: and ra.payment_schedule_id = cm_ps.payment_schedule_id;

Line 1288: ar_payment_schedules cm_ps

1284: to_char(inv_ps.due_date , 'J') due_date,
1285: inv_ps.amount_applied
1286: from ar_receivable_applications ra,
1287: ar_payment_schedules inv_ps,
1288: ar_payment_schedules cm_ps
1289: where ra.receivable_application_id = ra_id
1290: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1291: and ra.payment_schedule_id = cm_ps.payment_schedule_id;
1292: