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.CSM_MULTI_MOBQRY_PKG dependencies on CSM_HZ_CUST_ACCT_SITES_ALL_ACC

Line 18: and (exists (select 1 from CSM_HZ_CUST_ACCT_SITES_ALL_ACC casa where cas.cust_acct_site_id=casa.cust_acct_site_id and casa.user_id=b_user_id)

14: SELECT max(hrl.location_id)
15: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas
16: WHERE hrl.org_id=cas.org_id and hrl.address_id=cas.cust_acct_site_id
17: and cas.party_site_id=b_ps_id
18: and (exists (select 1 from CSM_HZ_CUST_ACCT_SITES_ALL_ACC casa where cas.cust_acct_site_id=casa.cust_acct_site_id and casa.user_id=b_user_id)
19: or exists(select 1 from csm_po_loc_ass_all_acc poa where poa.location_id=hrl.location_id and poa.user_id=b_user_id ));
20:
21: TYPE l_char_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
22: TYPE l_num_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 234: and (exists (select 1 from CSM_HZ_CUST_ACCT_SITES_ALL_ACC casa where cas.cust_acct_site_id=casa.cust_acct_site_id and casa.user_id=l_user_id)

230: SELECT max(hrl.location_id) INTO l_hr_loc_id
231: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas
232: WHERE hrl.org_id=cas.org_id and hrl.address_id=cas.cust_acct_site_id
233: and cas.party_site_id=p_to_hzloc_id
234: and (exists (select 1 from CSM_HZ_CUST_ACCT_SITES_ALL_ACC casa where cas.cust_acct_site_id=casa.cust_acct_site_id and casa.user_id=l_user_id)
235: or exists(select 1 from csm_po_loc_ass_all_acc poa where poa.location_id=hrl.location_id and poa.user_id=l_user_id ));
236:
237: CSM_UTIL_PKG.LOG('HR Location_id:'||l_hr_loc_id , 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
238: