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 2135: FROM hz_locations loc, hz_party_sites ps, hz_parties p

2131: CURSOR c_location (
2132: p_location_id NUMBER
2133: ) IS
2134: SELECT p.party_id, p.party_type
2135: FROM hz_locations loc, hz_party_sites ps, hz_parties p
2136: WHERE loc.location_id = p_location_id
2137: AND loc.location_id = ps.location_id
2138: AND ps.party_id = p.party_id;
2139:

Line 2200: ELSIF p_db_object_name = 'HZ_LOCATIONS' THEN

2196: OPEN c_party_site(TO_NUMBER(p_object_pk1));
2197: FETCH c_party_site BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2198: CLOSE c_party_site;
2199:
2200: ELSIF p_db_object_name = 'HZ_LOCATIONS' THEN
2201: OPEN c_location(TO_NUMBER(p_object_pk1));
2202: FETCH c_location BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2203: CLOSE c_location;
2204: