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 HZ_CUST_ACCT_SITES_ALL

Line 15: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas

11: g_nl_chr VARCHAR2(10) :=fnd_global.local_chr(10);
12:
13: CURSOR c_get_hr_loc_id(b_user_id NUMBER,b_ps_id NUMBER) IS
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 ));

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 231: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas

227: into l_user_id ,l_resp_id ,l_app_id
228: from asg_user where user_name=p_user_name;
229:
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 ));

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:

Line 1151: FROM hz_cust_acct_sites_all a, hz_party_sites b,jtf_tasks_b t,cs_incidents_all_b i

1147: CSM_UTIL_PKG.LOG('Creating new loc as No HR Location found for party site id:'||p_party_site_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1148:
1149: SELECT a.cust_account_id ,b.party_id,b.location_id,a.org_id
1150: INTO l_account_id,l_party_id,x_loc_id,l_org_id
1151: FROM hz_cust_acct_sites_all a, hz_party_sites b,jtf_tasks_b t,cs_incidents_all_b i
1152: WHERE b.PARTY_SITE_ID=a.PARTY_SITE_ID
1153: AND t.task_id=p_task_id
1154: and t.sourcE_object_type_code='SR'
1155: and i.customer_id=b.party_id

Line 1361: from po_location_associations_all a, HZ_CUST_ACCT_SITES_ALL b ,hz_party_sites c

1357: l_hr_loc_id:=x_loc_id;
1358:
1359: select b.party_site_id,c.location_id ,a.address_id,a.org_id
1360: into l_hz_psite_id,l_hz_loc_id,l_cust_acct_site_id,l_org_id
1361: from po_location_associations_all a, HZ_CUST_ACCT_SITES_ALL b ,hz_party_sites c
1362: where a.location_id=x_loc_id
1363: and b.cust_account_id=x_cust_id
1364: and a.address_id=b.cust_acct_site_id
1365: and b.party_site_id=c.party_site_id;