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

Line 17: v_amount ar_payment_schedules.amount_due_remaining%TYPE;

13: v_org_id ar_batches.org_id%TYPE;
14: v_invoice_id ra_customer_trx.customer_trx_id%TYPE;
15: v_temp_id fv_lockbox_ipa_temp.temp_id%TYPE;
16: v_debit_memo_id ra_customer_trx.customer_trx_id%TYPE;
17: v_amount ar_payment_schedules.amount_due_remaining%TYPE;
18: v_priority fv_finance_charge_controls.priority%TYPE;
19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
20: v_appl_inv_id ra_customer_trx.customer_trx_id%TYPE;
21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

Line 19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

15: v_temp_id fv_lockbox_ipa_temp.temp_id%TYPE;
16: v_debit_memo_id ra_customer_trx.customer_trx_id%TYPE;
17: v_amount ar_payment_schedules.amount_due_remaining%TYPE;
18: v_priority fv_finance_charge_controls.priority%TYPE;
19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
20: v_appl_inv_id ra_customer_trx.customer_trx_id%TYPE;
21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
22: v_sold_to_customer ar_interim_cash_rcpt_lines_all.sold_to_customer%TYPE;
23: v_transaction_code ar_interim_cash_receipts.ussgl_transaction_code%TYPE;

Line 21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

17: v_amount ar_payment_schedules.amount_due_remaining%TYPE;
18: v_priority fv_finance_charge_controls.priority%TYPE;
19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
20: v_appl_inv_id ra_customer_trx.customer_trx_id%TYPE;
21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
22: v_sold_to_customer ar_interim_cash_rcpt_lines_all.sold_to_customer%TYPE;
23: v_transaction_code ar_interim_cash_receipts.ussgl_transaction_code%TYPE;
24: v_appl_inv_amt number;
25: v_appl_amt_remain number;

Line 81: ar_payment_schedules aps,

77: aps.amount_due_remaining,
78: fcc.priority,
79: aps.payment_schedule_id
80: from ra_customer_trx rct,
81: ar_payment_schedules aps,
82: fv_finance_charge_controls fcc
83: where rct.related_customer_trx_id = cv_invoice_id
84: and aps.customer_trx_id = rct.customer_trx_id
85: and rct.interface_header_attribute3 = fcc.charge_type