APPS.FTE_DIST_INT_PKG dependencies on FTE_LOCATION_MILEAGES

Line 8: -- and transit time information from FTE_LOCATION_MILEAGES table --

4: -- --
5: -- NAME: FTE_DISTANCE_INT_PKG --
6: -- TYPE: PACKAGE BODY --
7: -- DESCRIPTION: Contains core procedures for accessing and retrieving distance--
8: -- and transit time information from FTE_LOCATION_MILEAGES table --
9: -- --
10: -- --
11: -- CHANGE CONTROL LOG --
12: -- --

Line 97: -- pairs in FTE_LOCATION_MILEAGES are stored as region --

93: -- Location) or 'R' (for Region). This flag dictates the --
94: -- id pairs in the input table as whether they are region--
95: -- (WSH_REGIONS.REGION_ID) or locations --
96: -- (WSH_LOCATIONS.LOCATION_ID). As the origin/destination--
97: -- pairs in FTE_LOCATION_MILEAGES are stored as region --
98: -- ids, if a table of locations is passed in then the --
99: -- associated regions will need to be found for those --
100: -- locations before the search/retrieval can be conducted--
101: -- --

Line 1308: from fte_location_mileages flm

1304: flm.distance,
1305: flm.distance_uom,
1306: flm.transit_time,
1307: flm.transit_time_uom
1308: from fte_location_mileages flm
1309: where flm.origin_id = cp_origin_id
1310: and flm.destination_id = cp_destination_id
1311: and flm.identifier_type = cp_identifier_type;
1312: