APPS.MST_AUDIT_REP_EXCP dependencies on FTE_LOCATION_MILEAGES

Line 155: --FTE_LOCATION_MILEAGES is distance table

151: AND da.parent_delivery_detail_id is null
152: AND origReg.location_id = det.ship_from_location_id
153: AND destReg.location_id = det.ship_to_location_id
154:
155: --FTE_LOCATION_MILEAGES is distance table
156: --key is . Origin and destination are FK to WSH_REGIONS.
157: --IDENTIFIER_TYPE can be city or state (Anuj)
158: AND NOT EXISTS (SELECT DISTANCE
159: FROM FTE_LOCATION_MILEAGES

Line 159: FROM FTE_LOCATION_MILEAGES

155: --FTE_LOCATION_MILEAGES is distance table
156: --key is . Origin and destination are FK to WSH_REGIONS.
157: --IDENTIFIER_TYPE can be city or state (Anuj)
158: AND NOT EXISTS (SELECT DISTANCE
159: FROM FTE_LOCATION_MILEAGES
160: WHERE origReg.region_id = origin_id
161: AND destReg.region_id = destination_id));
162:
163:

Line 1065: --FTE_LOCATION_MILEAGES is distance table

1061: -- ****************** check for ocurrence of the exception ***********************
1062: IF ((availTimeInDays*24 + thresholdInHrs) < (requiredTransitTimeInHrs)) THEN
1063: --determine distance for this O-D pair
1064: BEGIN
1065: --FTE_LOCATION_MILEAGES is distance table
1066: --key is . Origin and destination are FK to WSH_REGIONS.
1067: --IDENTIFIER_TYPE can be city or state (Anuj)
1068: --select MIN distance because we might have more than one entry in distance table. Take the one with minimum distance for now.
1069: --Should we use distance_level profile to choose which one?

Line 1072: FROM FTE_LOCATION_MILEAGES lm,

1068: --select MIN distance because we might have more than one entry in distance table. Take the one with minimum distance for now.
1069: --Should we use distance_level profile to choose which one?
1070: SELECT MIN(lm.distance)
1071: INTO distance
1072: FROM FTE_LOCATION_MILEAGES lm,
1073: WSH_REGION_LOCATIONS origReg,
1074: WSH_REGION_LOCATIONS destReg
1075: WHERE origReg.location_id = delivLine.ship_from_location_id
1076: AND destReg.location_id = delivLine.ship_to_location_id

Line 1265: --FTE_LOCATION_MILEAGES is distance table

1261:
1262: -- debug_output('minPCL_LTL_TransitTime=' || minimumTransitTime);
1263:
1264: --Check TL
1265: --FTE_LOCATION_MILEAGES is distance table
1266: --key is . Origin and destination are FK to WSH_REGIONS.
1267: --IDENTIFIER_TYPE can be city or state (Anuj)
1268: --TRANSIT_TIME, TRANSIT_TIME_UOM are columns of interest here.
1269: BEGIN

Line 1272: FROM FTE_LOCATION_MILEAGES distTable,

1268: --TRANSIT_TIME, TRANSIT_TIME_UOM are columns of interest here.
1269: BEGIN
1270: SELECT MIN(CONV_TO_UOM(distTable.transit_time,distTable.transit_time_uom,tp_time_uom,0))
1271: INTO tl_minimumTransitTime
1272: FROM FTE_LOCATION_MILEAGES distTable,
1273: WSH_REGION_LOCATIONS origReg,
1274: WSH_REGION_LOCATIONS destReg
1275: WHERE origReg.location_id = ship_from
1276: AND destReg.location_id = ship_to

Line 1282: debug_output('no TL transit time in FTE_LOCATION_MILEAGES');

1278: AND destReg.region_id = distTable.destination_id;
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: tl_minimumTransitTime := -23453;
1282: debug_output('no TL transit time in FTE_LOCATION_MILEAGES');
1283: END;
1284: IF tl_minimumTransitTime IS NULL THEN
1285: tl_minimumTransitTime := -23453;
1286: debug_output('TL transit time in FTE_LOCATION_MILEAGES is null after conversion');

Line 1286: debug_output('TL transit time in FTE_LOCATION_MILEAGES is null after conversion');

1282: debug_output('no TL transit time in FTE_LOCATION_MILEAGES');
1283: END;
1284: IF tl_minimumTransitTime IS NULL THEN
1285: tl_minimumTransitTime := -23453;
1286: debug_output('TL transit time in FTE_LOCATION_MILEAGES is null after conversion');
1287: END IF;
1288:
1289:
1290: -- debug_output('origin=' || ship_from || ', destination=' || ship_to || ', tl_minimumTransitTime=' || tl_minimumTransitTime);