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_ADDRESS_USAGES_PUB dependencies on HZ_GEO_STRUCT_MAP_DTL

Line 149: FROM hz_geo_struct_map_dtl

145: ELSE
146: BEGIN
147: SELECT 'X'
148: INTO l_map_dtl_extsts
149: FROM hz_geo_struct_map_dtl
150: WHERE map_id = p_address_usages_rec.map_id
151: AND geography_type = p_address_usage_dtls_tbl(i).geography_type;
152:
153: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 604: FROM hz_geo_struct_map_dtl

600: ELSE
601: BEGIN
602: SELECT 'X'
603: INTO l_map_dtl_extsts
604: FROM hz_geo_struct_map_dtl
605: WHERE map_id = l_map_id
606: AND geography_type = p_address_usage_dtls_tbl(i).geography_type;
607:
608: EXCEPTION WHEN NO_DATA_FOUND THEN