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.CSF_TASKS_PUB dependencies on HZ_LOCATIONS

Line 4673: FROM hz_locations l

4669: , l.city
4670: , l.state
4671: , l.province
4672: , l.country
4673: FROM hz_locations l
4674: WHERE l.location_id = p_location_id;
4675:
4676: CURSOR c_ps_location_info IS
4677: SELECT l.address1

Line 4687: , hz_locations l

4683: , l.state
4684: , l.province
4685: , l.country
4686: FROM hz_party_sites ps
4687: , hz_locations l
4688: WHERE ps.party_site_id = p_party_site_id
4689: AND l.location_id = ps.location_id;
4690:
4691: CURSOR c_task_location_info IS

Line 4703: , hz_locations l

4699: , l.province
4700: , l.country
4701: FROM jtf_tasks_b t
4702: , hz_party_sites ps
4703: , hz_locations l
4704: WHERE t.task_id = p_task_id
4705: AND ps.party_site_id(+) = t.address_id
4706: AND l.location_id = NVL(t.location_id, ps.location_id);
4707:

Line 5667: FROM hz_locations l,

5663: SELECT s.party_site_number,
5664: s.party_site_name,
5665: s.addressee,
5666: csf_tasks_pub.return_primary_phone(s.party_site_id) phone_no
5667: FROM hz_locations l,
5668: hz_party_sites s,
5669: hz_parties p
5670: WHERE s.location_id = p_location_id
5671: AND l.location_id = s.location_id