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.MSD_SR_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 291: --Bug 4585376 RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL replaced by HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES and HZ_CUST_ACCT_SITES_ALL

287: l_ret varchar2(240);
288: BEGIN
289: if p_loc_id is null then return 'Other'; end if;
290:
291: --Bug 4585376 RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL replaced by HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES and HZ_CUST_ACCT_SITES_ALL
292: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
293: into l_ret
294: from HZ_CUST_SITE_USES_ALL csu,
295: HZ_CUST_ACCOUNTS ca,

Line 294: from HZ_CUST_SITE_USES_ALL csu,

290:
291: --Bug 4585376 RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL replaced by HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES and HZ_CUST_ACCT_SITES_ALL
292: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
293: into l_ret
294: from HZ_CUST_SITE_USES_ALL csu,
295: HZ_CUST_ACCOUNTS ca,
296: HZ_PARTIES hp,
297: HZ_CUST_ACCT_SITES_ALL cas
298: where csu.site_use_id = p_loc_id