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_UI_UTIL_PUB dependencies on HZ_ADDRESS_USAGE_DTLS

Line 72: Hz_address_usage_dtls dtl

68: l_geo_tax in varchar2)
69: is
70: select dtl.usage_dtl_id
71: from Hz_address_usages usg,
72: Hz_address_usage_dtls dtl
73: where usg.map_id = l_map_id
74: and usg.usage_code = l_geo_tax
75: and usg.status_flag = 'A'
76: and dtl.usage_id = usg.usage_id

Line 139: from hz_address_usage_dtls usg

135: l_geo_type in varchar2)
136: is
137: select usg.usage_dtl_id,
138: usg.geography_type
139: from hz_address_usage_dtls usg
140: where usg.usage_id = l_usage_id
141: and usg.geography_type = l_geo_type;
142:
143: r_get_dtls c_get_dtls%rowtype;