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.FV_DC_ASSIGN_FINANCE_CHRG dependencies on AR_PAYMENT_SCHEDULES

Line 26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,

22:
23: TYPE out_rec IS RECORD
24: (
25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,

Line 29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,

25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,
31: due_date ar_payment_schedules.due_date%TYPE,
32: amount_based VARCHAR2(1),
33: amount_or_rate NUMBER,

Line 30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,

26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,
31: due_date ar_payment_schedules.due_date%TYPE,
32: amount_based VARCHAR2(1),
33: amount_or_rate NUMBER,
34: first_accrual NUMBER,

Line 31: due_date ar_payment_schedules.due_date%TYPE,

27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,
31: due_date ar_payment_schedules.due_date%TYPE,
32: amount_based VARCHAR2(1),
33: amount_or_rate NUMBER,
34: first_accrual NUMBER,
35: accrual_interval NUMBER,

Line 281: p_amount_due_remaining IN OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,

277: (
278: p_accrue_as_of_date IN DATE,
279: p_last_date IN DATE,
280: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
281: p_amount_due_remaining IN OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
282: p_rate_amount IN NUMBER,
283: p_interval IN fv_finance_charge_controls.accrual_interval%TYPE,
284: p_charges OUT NOCOPY NUMBER,
285: p_errbuf OUT NOCOPY VARCHAR2,

Line 327: FROM ar_payment_schedules

323: END IF;
324:
325: SELECT SUM(amount_due_remaining)
326: INTO l_amt_due
327: FROM ar_payment_schedules
328: WHERE customer_trx_id = l_ct_id
329: AND class = 'INV';
330:
331: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN

Line 339: l_location := l_module_name||'.select_ar_payment_schedules';

335: EXCEPTION
336: WHEN OTHERS THEN
337: p_retcode := g_FAILURE;
338: p_errbuf := SQLERRM;
339: l_location := l_module_name||'.select_ar_payment_schedules';
340: log(l_location,l_location) ;
341: log(l_location,p_errbuf) ;
342: END;
343:

Line 1689: FROM ar_payment_schedules aps,

1685: fifc.finance_charge_group_hdr_id,
1686: fifc.finance_charge_group_dtl_id,
1687: NVL(fcc.prorate_charge, 'N') prorate_charge,
1688: fcc.invoice_suffix
1689: FROM ar_payment_schedules aps,
1690: fv_invoice_finance_chrgs fifc,
1691: fv_finance_charge_controls fcc,
1692: fv_finance_charge_history fch,
1693: ra_customer_trx rct,

Line 1862: FROM ar_payment_schedules aps

1858: SELECT SUM(aps.amount_due_original),
1859: SUM(aps.amount_due_remaining)
1860: INTO l_inv_amount_due_original,
1861: l_inv_amount_due_remaining
1862: FROM ar_payment_schedules aps
1863: WHERE aps.customer_trx_id = main_rec.invoice_id;
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: p_retcode := g_FAILURE;

Line 1868: l_location := l_module_name||'.select_ar_payment_schedules';

1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: p_retcode := g_FAILURE;
1867: p_errbuf := SQLERRM;
1868: l_location := l_module_name||'.select_ar_payment_schedules';
1869: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1870: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
1871: END;
1872: END IF;