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_CHRG_CUST_CLASSES

Line 1710: FROM fv_finance_chrg_cust_classes fccc,

1706: AND rct.set_of_books_id = g_set_of_books_id
1707: --bug 9716140
1708: AND (rct.related_customer_trx_id IS NULL OR
1709: EXISTS(SELECT 'x'
1710: FROM fv_finance_chrg_cust_classes fccc,
1711: fv_finance_charge_grp_dtls fcgd,
1712: hz_cust_accounts hzca
1713: WHERE fccc.finance_charge_group_hdr_id = fcgd.finance_charge_group_hdr_id
1714: AND fccc.enabled_flag = 'Y'

Line 1731: FROM fv_finance_chrg_cust_classes fccc,

1727: AND rctt.cust_trx_type_id = fcc.trx_type_id
1728: AND rsua.site_use_id = rct.bill_to_site_use_id
1729: AND fai.invoice_id = fifc.customer_trx_id
1730: AND EXISTS ( SELECT 'x'
1731: FROM fv_finance_chrg_cust_classes fccc,
1732: fv_finance_charge_grp_dtls fcgd,
1733: hz_cust_accounts hzca
1734: WHERE fccc.customer_class = hzca.customer_class_code
1735: AND fccc.enabled_flag = 'Y'

Line 2097: FROM fv_finance_chrg_cust_classes fccc,

2093: WHERE hzca.cust_account_id = customer_id
2094: AND fcc.charge_id = charge_id
2095: AND set_of_books_id = c_ledger_id)
2096: AND NOT EXISTS (SELECT 'x'
2097: FROM fv_finance_chrg_cust_classes fccc,
2098: fv_finance_charge_grp_dtls fcgd
2099: WHERE fccc.customer_class = hzca.customer_class_code
2100: AND fccc.enabled_flag = 'Y'
2101: AND fccc.finance_charge_group_hdr_id = fcgd.finance_charge_group_hdr_id

Line 2155: FROM fv_finance_chrg_cust_classes,

2151: /* UPDATE fv_cust_finance_chrgs
2152: SET waive_flag = 'Y'
2153: WHERE customer_id = customer.customer_id
2154: AND charge_id NOT IN (SELECT charge_id
2155: FROM fv_finance_chrg_cust_classes,
2156: hz_cust_accounts hzca
2157: WHERE hzca.cust_account_id = customer.customer_id
2158: AND customer_class = hzca.customer_class_code
2159: AND enabled_flag = 'Y'

Line 2166: FROM fv_finance_chrg_cust_classes b

2162: /* Commented for bug 9089029
2163: UPDATE fv_cust_finance_chrgs a
2164: SET CUSTOMER_CLASS_CODE = customer.cust_class_code,
2165: finance_charge_group_hdr_id = (SELECT finance_charge_group_hdr_id
2166: FROM fv_finance_chrg_cust_classes b
2167: WHERE customer_class= customer.cust_class_code
2168: AND a.set_of_books_id = b.set_of_books_id
2169: AND rownum =1)
2170: WHERE EXISTS(SELECT 'A'

Line 2171: FROM fv_finance_chrg_cust_classes c

2167: WHERE customer_class= customer.cust_class_code
2168: AND a.set_of_books_id = b.set_of_books_id
2169: AND rownum =1)
2170: WHERE EXISTS(SELECT 'A'
2171: FROM fv_finance_chrg_cust_classes c
2172: WHERE customer_class= customer.cust_class_code
2173: AND a.set_of_books_id = c.set_of_books_id)
2174: AND customer_id = customer.customer_id;
2175: */

Line 2182: fv_finance_chrg_cust_classes fcfc,

2178: SET waive_flag = 'Y'
2179: WHERE customer_id = customer.customer_id
2180: AND charge_id NOT IN (SELECT fcf.charge_id
2181: FROM fv_cust_finance_chrgs fcf,
2182: fv_finance_chrg_cust_classes fcfc,
2183: hz_cust_accounts hzca,
2184: fv_finance_charge_grp_hdrs fcgh,
2185: fv_finance_charge_grp_dtls fcgd
2186: WHERE hzca.cust_account_id = customer.customer_id

Line 2205: fv_finance_chrg_cust_classes fcfc,

2201: SET waive_flag = 'N'
2202: WHERE customer_id = customer.customer_id
2203: AND charge_id IN (SELECT fcf.charge_id
2204: FROM fv_cust_finance_chrgs fcf,
2205: fv_finance_chrg_cust_classes fcfc,
2206: hz_cust_accounts hzca,
2207: fv_finance_charge_grp_hdrs fcgh,
2208: fv_finance_charge_grp_dtls fcgd
2209: WHERE hzca.cust_account_id = customer.customer_id

Line 2247: fv_finance_chrg_cust_classes fccc,

2243: customer_id IN
2244: (SELECT hzca.cust_account_id
2245: FROM hz_cust_accounts hzca,
2246: fv_finance_charge_controls fcc,
2247: fv_finance_chrg_cust_classes fccc,
2248: fv_finance_charge_grp_dtls fcgd,
2249: fv_finance_charge_grp_hdrs fcgh
2250: WHERE fcc.enabled_flag = 'Y'
2251: AND fcc.set_of_books_id = g_set_of_books_id

Line 2313: fv_finance_chrg_cust_classes fccc,

2309: fcgd.base_charge_id,
2310: g_request_id
2311: FROM hz_cust_accounts hzca,
2312: fv_finance_charge_controls fcc,
2313: fv_finance_chrg_cust_classes fccc,
2314: fv_finance_charge_grp_dtls fcgd,
2315: fv_finance_charge_grp_hdrs fcgh
2316: WHERE fcc.enabled_flag = 'Y'
2317: AND fcc.set_of_books_id = g_set_of_books_id