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_CUST_SITE_USES

Line 354: hz_cust_site_uses su,

350: , -91)))
351: into l_default_term
352: from ra_cust_trx_types tt,
353: hz_customer_profiles ap,
354: hz_cust_site_uses su,
355: ra_terms_b apt,
356: ra_terms_b spt,
357: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
358: su2.site_use_id profile_bill_to_site_use_id

Line 360: hz_cust_site_uses su1,

356: ra_terms_b spt,
357: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
358: su2.site_use_id profile_bill_to_site_use_id
359: from hz_customer_profiles cp,
360: hz_cust_site_uses su1,
361: hz_cust_site_uses su2
362: where cp.site_use_id = su1.site_use_id
363: and cp.status ='A'
364: and su1.cust_acct_site_id =su2.cust_acct_site_id

Line 361: hz_cust_site_uses su2

357: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
358: su2.site_use_id profile_bill_to_site_use_id
359: from hz_customer_profiles cp,
360: hz_cust_site_uses su1,
361: hz_cust_site_uses su2
362: where cp.site_use_id = su1.site_use_id
363: and cp.status ='A'
364: and su1.cust_acct_site_id =su2.cust_acct_site_id
365: --bug11698651 start--

Line 429: hz_cust_site_uses su,

425: , -91)))) new_term_id, trx.customer_trx_id
426: from ra_customer_trx trx,
427: ra_cust_trx_types tt,
428: hz_customer_profiles ap,
429: hz_cust_site_uses su,
430: ra_terms_b sut,
431: ra_terms_b apt,
432: ra_terms_b spt,
433: ra_terms_b ttt,

Line 438: hz_cust_site_uses su1,

434: ra_terms_b invt,
435: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
436: su2.site_use_id profile_bill_to_site_use_id
437: from hz_customer_profiles cp,
438: hz_cust_site_uses su1,
439: hz_cust_site_uses su2
440: where cp.site_use_id = su1.site_use_id
441: and cp.status ='A'
442: and su1.cust_acct_site_id =su2.cust_acct_site_id

Line 439: hz_cust_site_uses su2

435: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
436: su2.site_use_id profile_bill_to_site_use_id
437: from hz_customer_profiles cp,
438: hz_cust_site_uses su1,
439: hz_cust_site_uses su2
440: where cp.site_use_id = su1.site_use_id
441: and cp.status ='A'
442: and su1.cust_acct_site_id =su2.cust_acct_site_id
443: and su2.site_use_code = 'BILL_TO'