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.AR_BFB_UTILS_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 197: from hz_customer_profiles cp

193:
194: -- the cons_bill_level is driven by the value at the account level profile
195: select decode(cp.cons_bill_level,'ACCOUNT','A','SITE','S','N')
196: into bfb_level
197: from hz_customer_profiles cp
198: where cp.cust_account_id = p_cust_account_id
199: and cp.site_use_id IS NULL;
200:
201: return bfb_level;

Line 285: hz_customer_profiles ap,

281: -- if bill level is not set
282: , -91)))
283: into l_default_term
284: from ra_cust_trx_types tt,
285: hz_customer_profiles ap,
286: hz_customer_profiles sp,
287: hz_cust_site_uses su,
288: ra_terms_b apt,
289: ra_terms_b spt

Line 286: hz_customer_profiles sp,

282: , -91)))
283: into l_default_term
284: from ra_cust_trx_types tt,
285: hz_customer_profiles ap,
286: hz_customer_profiles sp,
287: hz_cust_site_uses su,
288: ra_terms_b apt,
289: ra_terms_b spt
290: where p_trx_type_id = tt.cust_trx_type_id

Line 345: hz_customer_profiles ap,

341: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
342: , -91)))) new_term_id, trx.customer_trx_id
343: from ra_customer_trx trx,
344: ra_cust_trx_types tt,
345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,

Line 346: hz_customer_profiles sp,

342: , -91)))) new_term_id, trx.customer_trx_id
343: from ra_customer_trx trx,
344: ra_cust_trx_types tt,
345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,
348: ra_terms_b sut,
349: ra_terms_b apt,
350: ra_terms_b spt,