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 FV_FINANCE_CHARGE_CONTROLS

Line 26: charge_id fv_finance_charge_controls.charge_id%type;

22: rate_amount number;
23: accrual_type varchar2(1);
24: frequency varchar2(1);
25: rate_flag varchar2(1);
26: charge_id fv_finance_charge_controls.charge_id%type;
27: description fv_finance_charge_controls.description%type;
28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;

Line 27: description fv_finance_charge_controls.description%type;

23: accrual_type varchar2(1);
24: frequency varchar2(1);
25: rate_flag varchar2(1);
26: charge_id fv_finance_charge_controls.charge_id%type;
27: description fv_finance_charge_controls.description%type;
28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;

Line 28: charge_type fv_finance_charge_controls.charge_type%type;

24: frequency varchar2(1);
25: rate_flag varchar2(1);
26: charge_id fv_finance_charge_controls.charge_id%type;
27: description fv_finance_charge_controls.description%type;
28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;

Line 29: trx_type_id fv_finance_charge_controls.trx_type_id%type;

25: rate_flag varchar2(1);
26: charge_id fv_finance_charge_controls.charge_id%type;
27: description fv_finance_charge_controls.description%type;
28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;
33: suffix fv_finance_charge_controls.invoice_suffix%type;

Line 30: first fv_finance_charge_controls.first_accrual%type;

26: charge_id fv_finance_charge_controls.charge_id%type;
27: description fv_finance_charge_controls.description%type;
28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;
33: suffix fv_finance_charge_controls.invoice_suffix%type;
34: -- TC Obsoletion

Line 31: interval fv_finance_charge_controls.accrual_interval%type;

27: description fv_finance_charge_controls.description%type;
28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;
33: suffix fv_finance_charge_controls.invoice_suffix%type;
34: -- TC Obsoletion
35: -- ussgl_transaction_code fv_finance_charge_controls.ussgl_transaction_code%type;

Line 32: grace fv_finance_charge_controls.grace_period%type;

28: charge_type fv_finance_charge_controls.charge_type%type;
29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;
33: suffix fv_finance_charge_controls.invoice_suffix%type;
34: -- TC Obsoletion
35: -- ussgl_transaction_code fv_finance_charge_controls.ussgl_transaction_code%type;
36: fin_chrg number;

Line 33: suffix fv_finance_charge_controls.invoice_suffix%type;

29: trx_type_id fv_finance_charge_controls.trx_type_id%type;
30: first fv_finance_charge_controls.first_accrual%type;
31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;
33: suffix fv_finance_charge_controls.invoice_suffix%type;
34: -- TC Obsoletion
35: -- ussgl_transaction_code fv_finance_charge_controls.ussgl_transaction_code%type;
36: fin_chrg number;
37: dm_flag boolean;

Line 35: -- ussgl_transaction_code fv_finance_charge_controls.ussgl_transaction_code%type;

31: interval fv_finance_charge_controls.accrual_interval%type;
32: grace fv_finance_charge_controls.grace_period%type;
33: suffix fv_finance_charge_controls.invoice_suffix%type;
34: -- TC Obsoletion
35: -- ussgl_transaction_code fv_finance_charge_controls.ussgl_transaction_code%type;
36: fin_chrg number;
37: dm_flag boolean;
38: first_late_day date;
39: found boolean;

Line 173: fv_finance_charge_controls fcc,

169: -- rct.trx_date
170: -- bug 992498 commented out rct.trx_date
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)

Line 183: (select charge_type from fv_finance_charge_controls)

179: and aps.amount_due_remaining > 0
180: and aps.status <> 'CL'
181: and aps.customer_trx_id = rct.customer_trx_id
182: and nvl(rct.interface_header_attribute3,'XX') not in
183: (select charge_type from fv_finance_charge_controls)
184: and rct.set_of_books_id = cv_sob_id
185: and aps.customer_trx_id = fifc.customer_trx_id
186: and fifc.charge_id = fcc.charge_id
187: and fcc.charge_id = fch.charge_id

Line 2062: from hz_cust_accounts hzca, fv_finance_charge_controls fcc

2058: v_req_id number;
2059:
2060: cursor c1 is
2061: (select distinct hzca.cust_Account_id customer_id
2062: from hz_cust_accounts hzca, fv_finance_charge_controls fcc
2063: where fcc.enabled_flag = 'Y'
2064: and fcc.set_of_books_id = sob_id
2065: and hzca.status = 'A'
2066: and exists (select 'x' from fv_cust_finance_chrgs

Line 2125: from hz_cust_accounts hzca, fv_finance_charge_controls fcc

2121: created_by, creation_date, last_updated_by, last_update_date,
2122: set_of_books_id,org_id)
2123: select hzca.cust_Account_id, fcc.charge_id, 'N', 0, assign_date, 0, sysdate, sob_id,
2124: fcc.org_id
2125: from hz_cust_accounts hzca, fv_finance_charge_controls fcc
2126: where fcc.enabled_flag = 'Y'
2127: and fcc.set_of_books_id = sob_id
2128: and hzca.status = 'A'
2129: and not exists (select 'x' from fv_cust_finance_chrgs

Line 2148: fv_finance_charge_controls fcc,

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
2151: and fcfc.set_of_books_id = sob_id
2152: and ract.cust_trx_type_id = rctt.cust_trx_type_id

Line 2158: from fv_finance_charge_controls

2154: and fcc.enabled_flag = 'Y'
2155: and fcc.charge_id = fcfc.charge_id
2156: and rctt.type in ('DM','INV')
2157: and nvl(ract.interface_header_attribute3,'XX') not in (select charge_type
2158: from fv_finance_charge_controls
2159: where set_of_books_id = sob_id)
2160: and not exists (select 'x'
2161: from fv_invoice_finance_chrgs
2162: where ract.customer_trx_id = customer_trx_id