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_GEOGRAPHIES_PKG dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 1329: --get geography_element_column from hz_geo_structure_levels for this geography_id

1325: CLOSE c_get_geo_details;
1326:
1327: IF (l_geography_type <> 'COUNTRY') THEN
1328: BEGIN
1329: --get geography_element_column from hz_geo_structure_levels for this geography_id
1330: SELECT geography_element_column
1331: INTO l_geo_element_col
1332: FROM HZ_GEO_STRUCTURE_LEVELS
1333: WHERE country_code = l_country_code

Line 1332: FROM HZ_GEO_STRUCTURE_LEVELS

1328: BEGIN
1329: --get geography_element_column from hz_geo_structure_levels for this geography_id
1330: SELECT geography_element_column
1331: INTO l_geo_element_col
1332: FROM HZ_GEO_STRUCTURE_LEVELS
1333: WHERE country_code = l_country_code
1334: AND geography_type = l_geography_type
1335: AND ROWNUM < 2;
1336: