APPS.RRS_SITE_UTILS dependencies on RRS_TRADE_AREA_GROUPS_B

Line 141: rrs_trade_area_groups_b rtag,

137: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
138: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
139: rgta.trade_area_number_code
140: from
141: rrs_trade_area_groups_b rtag,
142: rrs_group_trade_areas rgta,
143: rrs_loc_trade_area_grps rltag,
144: hz_locations l,
145: rrs_sites_b rs

Line 161: rrs_trade_area_groups_b rtag,

157: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
158: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
159: rgta.trade_area_number_code
160: from
161: rrs_trade_area_groups_b rtag,
162: rrs_group_trade_areas rgta,
163: rrs_loc_trade_area_grps rltag,
164: hz_locations l,
165: rrs_sites_b rs

Line 182: rrs_trade_area_groups_b rtag,

178: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
179: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
180: rgta.trade_area_number_code
181: from
182: rrs_trade_area_groups_b rtag,
183: rrs_group_trade_areas rgta,
184: rrs_loc_trade_area_grps rltag,
185: hz_locations l,
186: rrs_sites_b rs,

Line 205: rrs_trade_area_groups_b rtag,

201: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
202: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
203: rgta.trade_area_number_code
204: from
205: rrs_trade_area_groups_b rtag,
206: rrs_group_trade_areas rgta,
207: rrs_loc_trade_area_grps rltag,
208: hz_locations l,
209: rrs_sites_b rs,