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.

[Home] [Help]

APPS.JL_BR_SPED_PUB dependencies on HZ_GEO_NAME_REFERENCES

Line 436: hz_geo_name_references geo_ref,

432: SELECT
433: identifier_value state
434: FROM
435: hz_geography_identifiers geo_ident,
436: hz_geo_name_references geo_ref,
437: hz_locations loc
438: WHERE
439: loc.location_id = P_LOCATION_ID
440: and loc.location_id = geo_ref.location_id

Line 452: hz_geo_name_references geo_ref,

448: SELECT
449: identifier_value city
450: FROM
451: hz_geography_identifiers geo_ident,
452: hz_geo_name_references geo_ref,
453: hz_locations loc
454: WHERE
455: loc.location_id = P_LOCATION_ID
456: and loc.location_id = geo_ref.location_id