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.OE_OE_FORM_HEADER dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2354: HZ_CUST_ACCT_SITES_ALL cas,

2350: x_header_val_rec.deliver_to_address4,
2351: x_header_val_rec.deliver_to_address5
2352:
2353: FROM HZ_CUST_SITE_USES_ALL site,
2354: HZ_CUST_ACCT_SITES_ALL cas,
2355: hz_cust_accounts cust,
2356: hz_parties party,
2357: hz_party_sites ps,
2358: hz_locations addr

Line 2774: HZ_CUST_ACCT_SITES_ALL cas

2770:
2771: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
2772: INTO x_invoice_to_customer_id
2773: FROM HZ_CUST_SITE_USES_ALL site,
2774: HZ_CUST_ACCT_SITES_ALL cas
2775: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
2776: AND site.site_use_code=l_site_use_code
2777: AND site.site_use_id=p_site_use_id;
2778:

Line 2802: HZ_CUST_ACCT_SITES_ALL cas

2798:
2799: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
2800: INTO x_ship_to_customer_id
2801: FROM HZ_CUST_SITE_USES_ALL site,
2802: HZ_CUST_ACCT_SITES_ALL cas
2803: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
2804: AND site.site_use_code=l_site_use_code
2805: AND site.site_use_id=p_site_use_id;
2806:

Line 3398: hz_cust_acct_sites_all cas,

3394: x_customer_name,
3395: x_customer_number
3396: from
3397: hz_cust_site_uses_all site,
3398: hz_cust_acct_sites_all cas,
3399: hz_cust_accounts cust,
3400: hz_parties party
3401: where site.site_use_code = p_site_use_code
3402: and site_use_id = p_site_use_id