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 RA_CUSTOMER_TRX

Line 14: v_invoice_id ra_customer_trx.customer_trx_id%TYPE;

10: v_test number;
11: v_transmission_id ar_transmissions_all.transmission_id%TYPE;
12: v_batch_id ar_batches.batch_id%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;

Line 16: v_debit_memo_id ra_customer_trx.customer_trx_id%TYPE;

12: v_batch_id ar_batches.batch_id%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;

Line 20: v_appl_inv_id ra_customer_trx.customer_trx_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;
24: v_appl_inv_amt number;

Line 75: cursor c_debit_memos(cv_invoice_id ra_customer_trx.customer_trx_id%TYPE) IS

71: where batch_id = cv_batch_id
72: and org_id = cv_org_id
73: and customer_trx_id is not null;
74:
75: cursor c_debit_memos(cv_invoice_id ra_customer_trx.customer_trx_id%TYPE) IS
76: Select aps.customer_trx_id,
77: aps.amount_due_remaining,
78: fcc.priority,
79: aps.payment_schedule_id

Line 80: from ra_customer_trx rct,

76: Select aps.customer_trx_id,
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

Line 96: ra_customer_trx rct,

92: select sum(amount) amount,
93: aicr.customer_trx_id,
94: aicr.payment_schedule_id
95: from ar_interim_cash_receipts aicr,
96: ra_customer_trx rct,
97: fv_finance_charge_controls fcc
98: where aicr.batch_id = cv_batch_id
99: and aicr.customer_trx_id is not null
100: and aicr.customer_trx_id = rct.customer_trx_id

Line 109: ra_customer_trx rct,

105: select sum(payment_amount) amount,
106: aicrl.customer_trx_id,
107: aicrl.payment_schedule_id
108: from ar_interim_cash_rcpt_lines_all aicrl,
109: ra_customer_trx rct,
110: fv_finance_charge_controls fcc
111: where aicrl.batch_id = cv_batch_id
112: and aicrl.customer_trx_id is not null
113: and aicrl.customer_trx_id = rct.customer_trx_id