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_HEADER_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 9672: HZ_CUST_ACCT_SITES cas,

9668: x_state,
9669: x_zip,
9670: x_country
9671: FROM HZ_CUST_SITE_USES_ALL site,
9672: HZ_CUST_ACCT_SITES cas,
9673: hz_cust_accounts cust,
9674: hz_parties party,
9675: hz_party_sites ps,
9676: hz_locations loc

Line 10152: HZ_CUST_ACCT_SITES site

10148: IF p_site_use = 'SHIP_TO' THEN
10149: SELECT site_use.SITE_USE_ID
10150: INTO p_site_use_id
10151: FROM HZ_CUST_SITE_USES_ALL site_use,
10152: HZ_CUST_ACCT_SITES site
10153: WHERE site_use.SITE_USE_CODE = p_site_use
10154: AND site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
10155: AND site.CUST_ACCOUNT_ID = p_cust_acct_id
10156: AND SITE_USE.PRIMARY_FLAG = 'Y'

Line 10165: HZ_CUST_ACCT_SITES site

10161: ELSE
10162: SELECT site_use.SITE_USE_ID
10163: INTO p_site_use_id
10164: FROM HZ_CUST_SITE_USES_ALL site_use,
10165: HZ_CUST_ACCT_SITES site
10166: WHERE site_use.SITE_USE_CODE = p_site_use
10167: AND site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
10168: AND site.CUST_ACCOUNT_ID = p_cust_acct_id
10169: AND SITE_USE.PRIMARY_FLAG = 'Y'