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_GEO_GET_PUB dependencies on HZ_GEOGRAPHY_RANGES

Line 260: FROM hz_geography_ranges

256:
257: -- Bug 6842648 Perf fix to query
258: -- Bug 7837051 Commented Master_ref_geography_id Join
259: SELECT count(1) INTO l_count
260: FROM hz_geography_ranges
261: WHERE -- master_ref_geography_id = l_geography_id AND
262: geography_id = l_zone_id
263: AND geography_type = p_zone_type
264: AND geography_use = 'TAX'

Line 305: FROM hz_geography_ranges

301: -- Bug 6842648 Perf fix to query
302: -- Bug 7837051 Commented Master_ref_geography_id Join
303: SELECT count(1)
304: INTO l_count
305: FROM hz_geography_ranges
306: WHERE geography_id = l_zone_id
307: --AND master_ref_geography_id = l_geography_id
308: AND l_postal_code between geography_from and geography_to
309: AND p_date between start_date and end_date