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.ZX_MERGE_LOC_CHECK_PKG dependencies on HZ_GEO_STRUCT_MAP

Line 40: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage

36: x_merge_yn := 'N';
37: BEGIN
38: SELECT 'TRUE'
39: INTO l_from_tax_usage_exists
40: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage
41: WHERE map.country_code = loc.country
42: AND map.loc_tbl_name = 'HZ_LOCATIONS'
43: AND nvl(map.address_style,'1') = nvl(loc.address_style,'1')
44: AND map.map_id = usage.map_id

Line 54: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage

50:
51: BEGIN
52: SELECT 'TRUE'
53: INTO l_to_tax_usage_exists
54: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage
55: WHERE map.country_code = loc.country
56: AND map.loc_tbl_name = 'HZ_LOCATIONS'
57: AND nvl(map.address_style,'1') = nvl(loc.address_style,'1')
58: AND map.map_id = usage.map_id

Line 70: hz_geo_struct_map map,

66: SELECT gnr.geography_id, gnr.geography_type
67: BULK COLLECT INTO l_from_geography_id_tbl, l_from_geography_type_tbl
68: FROM hz_geo_name_references gnr,
69: hz_geo_name_reference_log log,
70: hz_geo_struct_map map,
71: hz_locations loc,
72: hz_address_usages usage,
73: hz_address_usage_dtls dtl
74: WHERE gnr.location_id = p_from_location_id

Line 92: hz_geo_struct_map map,

88: SELECT gnr.geography_id, gnr.geography_type
89: BULK COLLECT INTO l_to_geography_id_tbl, l_to_geography_type_tbl
90: FROM hz_geo_name_references gnr,
91: hz_geo_name_reference_log log,
92: hz_geo_struct_map map,
93: hz_locations loc,
94: hz_address_usages usage,
95: hz_address_usage_dtls dtl
96: WHERE gnr.location_id = p_to_location_id