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.JL_BR_SPED_PUB dependencies on HZ_GEO_NAME_REFERENCES

Line 442: hz_geo_name_references geo_ref,

438: SELECT
439: identifier_value state
440: FROM
441: hz_geography_identifiers geo_ident,
442: hz_geo_name_references geo_ref,
443: hz_locations loc
444: WHERE
445: loc.location_id = P_LOCATION_ID
446: and loc.location_id = geo_ref.location_id

Line 458: hz_geo_name_references geo_ref,

454: SELECT
455: identifier_value city
456: FROM
457: hz_geography_identifiers geo_ident,
458: hz_geo_name_references geo_ref,
459: hz_locations loc
460: WHERE
461: loc.location_id = P_LOCATION_ID
462: and loc.location_id = geo_ref.location_id