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_GNR_PVT dependencies on HZ_GEOGRAPHIES

Line 36: country_code hz_geographies.geography_code%TYPE,

32:
33: TYPE geo_suggest_rec IS RECORD
34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,

Line 37: country_geo_id hz_geographies.geography_id%TYPE,

33: TYPE geo_suggest_rec IS RECORD
34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,

Line 38: country_geo_type hz_geographies.geography_type%TYPE,

34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,

Line 40: state_code hz_geographies.geography_code%TYPE,

36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,

Line 41: state_geo_id hz_geographies.geography_id%TYPE,

37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,

Line 42: state_geo_type hz_geographies.geography_type%TYPE,

38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,

Line 44: province_code hz_geographies.geography_code%TYPE,

40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,

Line 45: province_geo_id hz_geographies.geography_id%TYPE,

41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,

Line 46: province_geo_type hz_geographies.geography_type%TYPE,

42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,

Line 48: county_geo_id hz_geographies.geography_id%TYPE,

44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,

Line 49: county_geo_type hz_geographies.geography_type%TYPE,

45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,

Line 51: city_geo_id hz_geographies.geography_id%TYPE,

47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,

Line 52: city_geo_type hz_geographies.geography_type%TYPE,

48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,

Line 54: postal_code_geo_id hz_geographies.geography_id%TYPE,

50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,

Line 55: postal_code_geo_type hz_geographies.geography_type%TYPE,

51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,

Line 57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,

53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,

Line 58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,

54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,

Line 60: attribute1_geo_id hz_geographies.geography_id%TYPE,

56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,

Line 61: attribute1_geo_type hz_geographies.geography_type%TYPE,

57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,

Line 63: attribute2_geo_id hz_geographies.geography_id%TYPE,

59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,

Line 64: attribute2_geo_type hz_geographies.geography_type%TYPE,

60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,

Line 66: attribute3_geo_id hz_geographies.geography_id%TYPE,

62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,

Line 67: attribute3_geo_type hz_geographies.geography_type%TYPE,

63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,

Line 69: attribute4_geo_id hz_geographies.geography_id%TYPE,

65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,

Line 70: attribute4_geo_type hz_geographies.geography_type%TYPE,

66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,

Line 72: attribute5_geo_id hz_geographies.geography_id%TYPE,

68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,

Line 73: attribute5_geo_type hz_geographies.geography_type%TYPE,

69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,

Line 75: attribute6_geo_id hz_geographies.geography_id%TYPE,

71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,

Line 76: attribute6_geo_type hz_geographies.geography_type%TYPE,

72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,

Line 78: attribute7_geo_id hz_geographies.geography_id%TYPE,

74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,

Line 79: attribute7_geo_type hz_geographies.geography_type%TYPE,

75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,

Line 81: attribute8_geo_id hz_geographies.geography_id%TYPE,

77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,

Line 82: attribute8_geo_type hz_geographies.geography_type%TYPE,

78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,

Line 84: attribute9_geo_id hz_geographies.geography_id%TYPE,

80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,

Line 85: attribute9_geo_type hz_geographies.geography_type%TYPE,

81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)

Line 87: attribute10_geo_id hz_geographies.geography_id%TYPE,

83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)
90: );
91:

Line 88: attribute10_geo_type hz_geographies.geography_type%TYPE,

84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)
90: );
91:
92: TYPE geo_suggest_tbl_type IS TABLE OF geo_suggest_rec INDEX BY BINARY_INTEGER;