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 292: --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

288: l_ret varchar2(240);
289: BEGIN
290: if p_loc_id is null then return 'Other'; end if;
291:
292: --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
293: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
294: into l_ret
295: from HZ_CUST_SITE_USES_ALL csu,
296: HZ_CUST_ACCOUNTS ca,

Line 295: from HZ_CUST_SITE_USES_ALL csu,

291:
292: --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
293: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
294: into l_ret
295: from HZ_CUST_SITE_USES_ALL csu,
296: HZ_CUST_ACCOUNTS ca,
297: HZ_PARTIES hp,
298: HZ_CUST_ACCT_SITES_ALL cas
299: where csu.site_use_id = p_loc_id