APPS.FV_1099_TRANSACTION dependencies on RA_CUSTOMER_TRX

Line 27: v_trx_number ra_customer_trx.trx_number%TYPE;

23: v_state hz_locations.state%TYPE;
24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;
29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
30: v_apply_date ar_adjustments.apply_date%TYPE;
31: v_debit_memo_sum number;

Line 28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;

24: v_postal_code hz_locations.postal_code%TYPE;
25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;
29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
30: v_apply_date ar_adjustments.apply_date%TYPE;
31: v_debit_memo_sum number;
32: v_begin_date date;

Line 29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

25: v_province hz_locations.province%TYPE;
26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;
29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
30: v_apply_date ar_adjustments.apply_date%TYPE;
31: v_debit_memo_sum number;
32: v_begin_date date;
33: v_end_date date;

Line 44: from ra_customer_trx,

40: CURSOR debit_memos_c IS
41: select nvl(sum(nvl(amount,0)),0)
42: from ar_adjustments
43: where customer_trx_id in (select customer_trx_id
44: from ra_customer_trx,
45: fv_finance_charge_controls fcc
46: where related_customer_trx_id = v_process_inv_id
47: and cust_trx_type_id in (select cust_trx_type_id
48: from ra_cust_trx_types

Line 62: ra_customer_trx rct

58: select nvl(sum(nvl(amount,0)),0) sum_adjustments,
59: nvl(related_customer_trx_id, aa.customer_trx_id) id,
60: bill_to_customer_id
61: from ar_adjustments aa,
62: ra_customer_trx rct
63: where (aa.customer_trx_id = rct.customer_trx_id
64: or aa.customer_trx_id in (select customer_trx_id
65: from ra_customer_trx
66: where related_customer_trx_id = aa.customer_trx_id))

Line 65: from ra_customer_trx

61: from ar_adjustments aa,
62: ra_customer_trx rct
63: where (aa.customer_trx_id = rct.customer_trx_id
64: or aa.customer_trx_id in (select customer_trx_id
65: from ra_customer_trx
66: where related_customer_trx_id = aa.customer_trx_id))
67: and aa.set_of_books_id = p_sob_id
68: and aa.status = 'A'
69: and aa.receivables_trx_id = v_rec_activity

Line 191: FROM ra_customer_trx

187:
188: BEGIN
189: SELECT trx_number
190: INTO v_trx_number
191: FROM ra_customer_trx
192: WHERE customer_trx_id = v_process_inv_id;
193: EXCEPTION
194: when others then
195: retcode := 2;

Line 222: from ra_customer_trx

218: SELECT max(apply_date)
219: INTO v_apply_date
220: FROM ar_adjustments
221: WHERE customer_trx_id in (select customer_trx_id
222: from ra_customer_trx
223: where related_customer_trx_id =
224: v_process_inv_id)
225: AND set_of_books_id = v_sob_id
226: AND apply_date between v_begin_date and v_end_date