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 4025: FROM hz_locations l

4021: , l.city
4022: , l.state
4023: , l.province
4024: , l.country
4025: FROM hz_locations l
4026: WHERE l.location_id = p_location_id;
4027:
4028: CURSOR c_ps_location_info IS
4029: SELECT l.address1

Line 4039: , hz_locations l

4035: , l.state
4036: , l.province
4037: , l.country
4038: FROM hz_party_sites ps
4039: , hz_locations l
4040: WHERE ps.party_site_id = p_party_site_id
4041: AND l.location_id = ps.location_id;
4042:
4043: CURSOR c_task_location_info IS

Line 4055: , hz_locations l

4051: , l.province
4052: , l.country
4053: FROM jtf_tasks_b t
4054: , hz_party_sites ps
4055: , hz_locations l
4056: WHERE t.task_id = p_task_id
4057: AND ps.party_site_id(+) = t.address_id
4058: AND l.location_id = NVL(t.location_id, ps.location_id);
4059: