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

Line 2275: FROM hz_locations loc, hz_party_sites ps, hz_parties p

2271: CURSOR c_location (
2272: p_location_id NUMBER
2273: ) IS
2274: SELECT p.party_id, p.party_type
2275: FROM hz_locations loc, hz_party_sites ps, hz_parties p
2276: WHERE loc.location_id = p_location_id
2277: AND loc.location_id = ps.location_id
2278: AND ps.party_id = p.party_id;
2279:

Line 2340: ELSIF p_db_object_name = 'HZ_LOCATIONS' THEN

2336: OPEN c_party_site(TO_NUMBER(p_object_pk1));
2337: FETCH c_party_site BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2338: CLOSE c_party_site;
2339:
2340: ELSIF p_db_object_name = 'HZ_LOCATIONS' THEN
2341: OPEN c_location(TO_NUMBER(p_object_pk1));
2342: FETCH c_location BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2343: CLOSE c_location;
2344: