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 RA_CUSTOMER_TRX

Line 18: set_of_books_id ra_customer_trx.set_of_books_id%type;

14: start_time date;
15: run_today date;
16: sob_run_today date;
17: last_accrual_date date;
18: set_of_books_id ra_customer_trx.set_of_books_id%type;
19: customer_trx_id ra_customer_trx.customer_trx_id%type;
20: trx_number ra_customer_trx.trx_number%type;
21: due_date date;
22: rate_amount number;

Line 19: customer_trx_id ra_customer_trx.customer_trx_id%type;

15: run_today date;
16: sob_run_today date;
17: last_accrual_date date;
18: set_of_books_id ra_customer_trx.set_of_books_id%type;
19: customer_trx_id ra_customer_trx.customer_trx_id%type;
20: trx_number ra_customer_trx.trx_number%type;
21: due_date date;
22: rate_amount number;
23: accrual_type varchar2(1);

Line 20: trx_number ra_customer_trx.trx_number%type;

16: sob_run_today date;
17: last_accrual_date date;
18: set_of_books_id ra_customer_trx.set_of_books_id%type;
19: customer_trx_id ra_customer_trx.customer_trx_id%type;
20: trx_number ra_customer_trx.trx_number%type;
21: due_date date;
22: rate_amount number;
23: accrual_type varchar2(1);
24: frequency varchar2(1);

Line 87: v_old_ctrx_id ra_customer_trx.customer_trx_id%type;

83: v_conc_req_id number; -- to store req id for Bug# 2157100
84: v_old_sch_id NUMBER;
85: v_invoice_level varchar2(1);
86: v_insert_flag varchar2(1):='N';
87: v_old_ctrx_id ra_customer_trx.customer_trx_id%type;
88: v_int_zero NUMBER;
89:
90:
91: v_inv_date_type VARCHAR2(10);

Line 108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;

104:
105: fc_dm_rec RA_INTERFACE_LINES_ALL%ROWTYPE;
106: fc_dm_dist_rec RA_INTERFACE_DISTRIBUTIONS%ROWTYPE;
107: fin_charge_batch_source_id number;
108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;
109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;
110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;
111: v_exchange_rate RA_CUSTOMER_TRX.EXCHANGE_RATE%TYPE;
112: v_exchange_rate_type RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE%TYPE;

Line 109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;

105: fc_dm_rec RA_INTERFACE_LINES_ALL%ROWTYPE;
106: fc_dm_dist_rec RA_INTERFACE_DISTRIBUTIONS%ROWTYPE;
107: fin_charge_batch_source_id number;
108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;
109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;
110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;
111: v_exchange_rate RA_CUSTOMER_TRX.EXCHANGE_RATE%TYPE;
112: v_exchange_rate_type RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE%TYPE;
113: v_interface_record varchar2(1);

Line 110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;

106: fc_dm_dist_rec RA_INTERFACE_DISTRIBUTIONS%ROWTYPE;
107: fin_charge_batch_source_id number;
108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;
109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;
110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;
111: v_exchange_rate RA_CUSTOMER_TRX.EXCHANGE_RATE%TYPE;
112: v_exchange_rate_type RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE%TYPE;
113: v_interface_record varchar2(1);
114: v_user_id number;

Line 111: v_exchange_rate RA_CUSTOMER_TRX.EXCHANGE_RATE%TYPE;

107: fin_charge_batch_source_id number;
108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;
109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;
110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;
111: v_exchange_rate RA_CUSTOMER_TRX.EXCHANGE_RATE%TYPE;
112: v_exchange_rate_type RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE%TYPE;
113: v_interface_record varchar2(1);
114: v_user_id number;
115: v_login_id number;

Line 112: v_exchange_rate_type RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE%TYPE;

108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;
109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;
110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;
111: v_exchange_rate RA_CUSTOMER_TRX.EXCHANGE_RATE%TYPE;
112: v_exchange_rate_type RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE%TYPE;
113: v_interface_record varchar2(1);
114: v_user_id number;
115: v_login_id number;
116: v_conc_program_id number;

Line 124: cursor main_select(cv_sob_id ra_customer_trx.set_of_books_id%TYPE) is

120: process_status boolean;
121: v_split_term boolean;
122: v_line_count number;
123:
124: cursor main_select(cv_sob_id ra_customer_trx.set_of_books_id%TYPE) is
125: select aps.customer_trx_id,
126: aps.amount_due_original,
127: aps.amount_due_remaining,
128: aps.payment_schedule_id,

Line 175: ra_customer_trx rct,

171: from ar_payment_schedules aps,
172: fv_invoice_finance_chrgs fifc,
173: fv_finance_charge_controls fcc,
174: fv_finance_charge_history fch,
175: ra_customer_trx rct,
176: hz_cust_accounts hzca
177: where trunc(sysdate) > (due_date + first_accrual + grace_period + 1)
178: and waive_flag = 'N'
179: and aps.amount_due_remaining > 0

Line 209: ra_customer_trx rct

205: cursor c_last_run_sob(cv_sob_id fv_ar_controls.payment_schedule_id%TYPE) is
206: select fac.last_accrual_date
207: from ar_payment_schedules aps,
208: fv_ar_controls fac,
209: ra_customer_trx rct
210: where aps.payment_schedule_id = fac.payment_schedule_id
211: and rct.customer_trx_id = aps.customer_trx_id
212: and rct.set_of_books_id = cv_sob_id
213: and fac.last_accrual_date = trunc(sysdate);

Line 339: from ra_customer_trx

335: invoice_id := customer_trx_id;
336:
337: select customer_trx_id
338: into existing_trx_id
339: from ra_customer_trx
340: where related_customer_trx_id = invoice_id
341: -- and created_from = charge_type; CHANGED
342: and interface_header_attribute3 = charge_type;
343:

Line 627: from ra_customer_trx

623: ELSE
624:
625: select term_id
626: into fc_dm_rec.term_id
627: from ra_customer_trx
628: where customer_trx_id = v_customer_trx_id;
629: END IF;
630:
631: ELSE

Line 2146: from ra_customer_trx ract,

2142: (customer_id, customer_trx_id, charge_id,waive_flag, created_by,
2143: creation_date,last_updated_by, last_update_date, set_of_books_id,org_id)
2144: select ract.bill_to_customer_id, ract.customer_trx_id, fcfc.charge_id,
2145: fcfc.waive_flag, 0 , assign_date, 0 , sysdate, sob_id, v_org_id
2146: from ra_customer_trx ract,
2147: fv_cust_finance_chrgs fcfc,
2148: fv_finance_charge_controls fcc,
2149: ra_cust_trx_types rctt
2150: where ract.bill_to_customer_id = fcfc.customer_id