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.MST_CMP_KPIS dependencies on MST_TRIPS

Line 86: FROM MST_TRIPS T1

82: NVL(T1.TOTAL_STOP_COST, 0) +
83: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
84: NVL(T1.TOTAL_LAYOVER_COST, 0) +
85: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
86: FROM MST_TRIPS T1
87: WHERE T1.PLAN_ID = p_plan_Id
88: GROUP BY T1.PLAN_ID) T,
89: MST_PLANS P
90: WHERE T.PLAN_ID = P.PLAN_ID;*/

Line 132: FROM MST_TRIPS T1

128: NVL(T1.TOTAL_STOP_COST, 0) +
129: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
130: NVL(T1.TOTAL_LAYOVER_COST, 0) +
131: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
132: FROM MST_TRIPS T1
133: WHERE T1.PLAN_ID = p_plan_id
134: AND T1.MODE_OF_TRANSPORT = g_tload -- 'TRUCK'
135: GROUP BY T1.PLAN_ID ) T,
136: MST_PLANS P

Line 147: FROM MST_TRIPS T1

143: FROM (SELECT T1.PLAN_ID,
144: SUM(NVL(T1.TOTAL_BASIC_TRANSPORT_COST, 0) +
145: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) +
146: NVL(T1.TOTAL_HANDLING_COST ,0 ) ) TotalCost
147: FROM MST_TRIPS T1
148: WHERE T1.PLAN_ID = p_plan_id
149: AND T1.MODE_OF_TRANSPORT = g_ltl
150: GROUP BY T1.PLAN_ID ) T,
151: MST_PLANS P

Line 162: FROM MST_TRIPS T1

158: FROM (SELECT T1.PLAN_ID,
159: SUM(NVL(T1.TOTAL_BASIC_TRANSPORT_COST, 0) +
160: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) +
161: NVL(T1.TOTAL_HANDLING_COST, 0) ) TotalCost
162: FROM MST_TRIPS T1
163: WHERE T1.PLAN_ID = p_plan_id
164: AND T1.MODE_OF_TRANSPORT = g_parcel
165: GROUP BY T1.PLAN_ID ) T,
166: MST_PLANS P

Line 185: FROM MST_TRIPS T1

181: NVL(T1.TOTAL_STOP_COST, 0) +
182: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
183: NVL(T1.TOTAL_LAYOVER_COST, 0) +
184: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
185: FROM MST_TRIPS T1
186: WHERE T1.PLAN_ID = p_plan_Id
187: AND T1.CARRIER_ID = p_carrier_id
188: ) T11,
189: (SELECT SUM(D.GROSS_WEIGHT) TotalWeight

Line 195: MST_TRIPS T2

191: WHERE D.PLAN_ID = p_plan_id
192: AND D.DELIVERY_ID IN
193: ( SELECT DL.DELIVERY_ID
194: FROM MST_DELIVERY_LEGS DL,
195: MST_TRIPS T2
196: WHERE dl.plan_id = d.plan_id
197: AND T2.PLAN_ID = dl.PLAN_ID
198: AND T2.TRIP_ID = dl.TRIP_ID
199: AND T2.CARRIER_ID = p_carrier_id

Line 395: FROM MST_TRIPS T1

391: NVL(T1.TOTAL_STOP_COST, 0) +
392: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
393: NVL(T1.TOTAL_LAYOVER_COST, 0) +
394: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
395: FROM MST_TRIPS T1
396: WHERE t1.PLAN_ID = p_plan_id
397: GROUP BY T1.PLAN_ID
398: ) T,
399: MST_PLANS P

Line 438: FROM MST_TRIPS T1

434: NVL(T1.TOTAL_STOP_COST, 0) +
435: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
436: NVL(T1.TOTAL_LAYOVER_COST, 0) +
437: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
438: FROM MST_TRIPS T1
439: WHERE T1.PLAN_ID = p_plan_id
440: AND T1.MODE_OF_TRANSPORT = g_tload
441: GROUP BY T1.PLAN_ID) T,
442: MST_PLANS P

Line 453: FROM MST_TRIPS T1

449: FROM ( SELECT T1.PLAN_ID,
450: SUM(NVL(T1.TOTAL_BASIC_TRANSPORT_COST, 0)+
451: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) +
452: NVL(T1.TOTAL_HANDLING_COST, 0) ) TotalCost
453: FROM MST_TRIPS T1
454: WHERE T1.PLAN_ID = p_plan_id
455: AND T1.MODE_OF_TRANSPORT = g_ltl
456: GROUP BY T1.PLAN_ID) T,
457: MST_PLANS P

Line 468: FROM MST_TRIPS T1

464: FROM ( SELECT T1.PLAN_ID,
465: SUM(NVL(T1.TOTAL_BASIC_TRANSPORT_COST, 0)+
466: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) +
467: NVL(T1.TOTAL_HANDLING_COST, 0) ) TotalCost
468: FROM MST_TRIPS T1
469: WHERE T1.PLAN_ID = p_plan_id
470: AND T1.MODE_OF_TRANSPORT = g_parcel
471: GROUP BY T1.PLAN_ID) T,
472: MST_PLANS P

Line 491: FROM MST_TRIPS T1

487: NVL(T1.TOTAL_STOP_COST, 0) +
488: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
489: NVL(T1.TOTAL_LAYOVER_COST, 0) +
490: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
491: FROM MST_TRIPS T1
492: WHERE T1.PLAN_ID = p_plan_id
493: AND T1.CARRIER_ID = p_carrier_id
494: ) T11,
495: (SELECT SUM(d.VOLUME) TotalVolume

Line 501: MST_TRIPS T2

497: WHERE D.PLAN_ID = p_plan_id
498: AND D.DELIVERY_ID IN
499: ( SELECT DL.DELIVERY_ID
500: FROM MST_DELIVERY_LEGS DL,
501: MST_TRIPS T2
502: WHERE DL.PLAN_ID = d.PLAN_ID
503: AND T2.PLAN_ID = dl.PLAN_ID
504: AND T2.TRIP_ID = dl.TRIP_ID
505: AND T2.PLAN_ID = p_plan_id

Line 680: FROM MST_TRIPS T

676: NVL(T.TOTAL_LOAD_UNLOAD_COST, 0) +
677: NVL(T.TOTAL_LAYOVER_COST, 0) +
678: NVL(T.TOTAL_ACCESSORIAL_COST, 0) ) /
679: SUM(T.TOTAL_TRIP_DISTANCE) )TLCostPerUnitDist
680: FROM MST_TRIPS T
681: WHERE T.PLAN_ID = p_plan_id
682: AND T.MODE_OF_TRANSPORT = g_tload;
683:
684:

Line 702: FROM MST_TRIPS T

698: NVL(T.TOTAL_LOAD_UNLOAD_COST, 0) +
699: NVL(T.TOTAL_LAYOVER_COST, 0) +
700: NVL(T.TOTAL_ACCESSORIAL_COST, 0) ) /
701: SUM(T.TOTAL_TRIP_DISTANCE) )TLCostPerUnitDist
702: FROM MST_TRIPS T
703: WHERE T.PLAN_ID = p_plan_id
704: AND T.MODE_OF_TRANSPORT = g_tload
705: AND T.CARRIER_ID = p_carrier_id;
706:

Line 768: FROM MST_TRIPS T

764: NVL(T.TOTAL_STOP_COST, 0) +
765: NVL(T.TOTAL_LAYOVER_COST, 0) +
766: NVL(T.TOTAL_LOAD_UNLOAD_COST, 0) +
767: NVL(T.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
768: FROM MST_TRIPS T
769: WHERE T.PLAN_ID = p_plan_id
770: AND T.MODE_OF_TRANSPORT = g_tload
771: ) T11,
772: ( SELECT SUM(NVL(TS.DISTANCE_TO_NEXT_STOP, 0) *

Line 775: MST_TRIPS T1

771: ) T11,
772: ( SELECT SUM(NVL(TS.DISTANCE_TO_NEXT_STOP, 0) *
773: NVL(TS.DEPARTURE_VOLUME, 0) ) TotalTLCubeDist
774: FROM MST_TRIP_STOPS TS,
775: MST_TRIPS T1
776: WHERE TS.PLAN_ID = T1.PLAN_ID
777: AND TS.TRIP_ID = T1.TRIP_ID
778: AND T1.PLAN_ID = p_plan_id
779: AND T1.MODE_OF_TRANSPORT = g_tload

Line 792: FROM MST_TRIPS T1

788: NVL(T1.TOTAL_STOP_COST, 0) +
789: NVL(T1.TOTAL_LAYOVER_COST, 0) +
790: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
791: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
792: FROM MST_TRIPS T1
793: WHERE T1.PLAN_ID = p_plan_id
794: AND T1.MODE_OF_TRANSPORT = g_tload
795: ) T11,
796: ( SELECT SUM(NVL(DL.DIRECT_DISTANCE, 0) *

Line 800: MST_TRIPS T2,

796: ( SELECT SUM(NVL(DL.DIRECT_DISTANCE, 0) *
797: NVL(D.VOLUME, 0)) TotalTLCubeDist
798: FROM MST_DELIVERY_LEGS DL,
799: MST_DELIVERIES D,
800: MST_TRIPS T2,
801: MST_TRIP_STOPS TS
802: WHERE DL.PLAN_ID = D.PLAN_ID
803: AND DL.DELIVERY_ID = D.DELIVERY_ID
804: AND DL.PLAN_ID = TS.PLAN_ID

Line 831: FROM MST_TRIPS T

827: NVL(T.TOTAL_STOP_COST, 0) +
828: NVL(T.TOTAL_LAYOVER_COST, 0) +
829: NVL(T.TOTAL_LOAD_UNLOAD_COST, 0) +
830: NVL(T.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
831: FROM MST_TRIPS T
832: WHERE T.PLAN_ID = p_plan_id
833: AND T.CARRIER_ID = p_carrier_id
834: AND T.MODE_OF_TRANSPORT = g_tload
835: ) T11,

Line 839: MST_TRIPS T1

835: ) T11,
836: ( SELECT SUM(NVL(TS.DISTANCE_TO_NEXT_STOP, 0) *
837: NVL(TS.DEPARTURE_VOLUME, 0) ) TotalTLCubeDist
838: FROM MST_TRIP_STOPS TS,
839: MST_TRIPS T1
840: WHERE TS.PLAN_ID = T1.PLAN_ID
841: AND TS.TRIP_ID = T1.TRIP_ID
842: AND T1.PLAN_ID = p_plan_id
843: AND T1.MODE_OF_TRANSPORT = g_tload

Line 857: FROM MST_TRIPS T1

853: NVL(T1.TOTAL_STOP_COST, 0) +
854: NVL(T1.TOTAL_LAYOVER_COST, 0) +
855: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
856: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
857: FROM MST_TRIPS T1
858: WHERE T1.PLAN_ID = p_plan_id
859: AND T1.CARRIER_ID = p_carrier_id
860: AND T1.MODE_OF_TRANSPORT = g_tload
861: ) T11,

Line 866: MST_TRIPS T2,

862: ( SELECT SUM(NVL(DL.DIRECT_DISTANCE, 0) *
863: NVL(D.VOLUME, 0) ) TotalTLCubeDist
864: FROM MST_DELIVERY_LEGS DL,
865: MST_DELIVERIES D,
866: MST_TRIPS T2,
867: MST_TRIP_STOPS TS
868: WHERE DL.PLAN_ID = D.PLAN_ID
869: AND DL.DELIVERY_ID = D.DELIVERY_ID
870: AND DL.PLAN_ID = TS.PLAN_ID

Line 896: MST_TRIPS T,

892: SUM(NVL(DL.TRAVELED_DISTANCE, 0) *
893: NVL(D.VOLUME, 0) ) ) TLCostPerUnitCubeDist
894: FROM MST_DELIVERY_LEGS DL,
895: MST_DELIVERIES D,
896: MST_TRIPS T,
897: MST_TRIP_STOPS TS
898: WHERE DL.PLAN_ID = D.PLAN_ID
899: AND DL.DELIVERY_ID = D.DELIVERY_ID
900: AND D.CUSTOMER_ID = p_customer_Id

Line 917: MST_TRIPS T,

913: SUM(NVL(DL.DIRECT_DISTANCE, 0) *
914: NVL(D.VOLUME, 0) ) ) AS TLCostPerUnitCubeDist
915: FROM MST_DELIVERY_LEGS DL,
916: MST_DELIVERIES D,
917: MST_TRIPS T,
918: MST_TRIP_STOPS TS
919: WHERE DL.PLAN_ID = D.PLAN_ID
920: AND DL.DELIVERY_ID = D.DELIVERY_ID
921: AND D.CUSTOMER_ID = p_customer_id

Line 946: MST_TRIPS T,

942: SUM(NVL(DL.TRAVELED_DISTANCE, 0) *
943: NVL(D.VOLUME, 0) ) ) TLCostPerUnitCubeDist
944: FROM MST_DELIVERY_LEGS DL,
945: MST_DELIVERIES D,
946: MST_TRIPS T,
947: MST_TRIP_STOPS TS
948: WHERE DL.PLAN_ID = D.PLAN_ID
949: AND DL.DELIVERY_ID = D.DELIVERY_ID
950: AND D.SUPPLIER_ID = p_supplier_id

Line 967: MST_TRIPS T,

963: SUM(NVL(DL.DIRECT_DISTANCE, 0) *
964: NVL(D.VOLUME, 0) ) ) TLCostPerUnitCubeDist
965: FROM MST_DELIVERY_LEGS DL,
966: MST_DELIVERIES D,
967: MST_TRIPS T,
968: MST_TRIP_STOPS TS
969: WHERE DL.PLAN_ID = D.PLAN_ID
970: AND DL.DELIVERY_ID = D.DELIVERY_ID
971: AND D.SUPPLIER_ID = p_supplier_id

Line 997: MST_TRIPS T,

993: SUM(NVL(DL.TRAVELED_DISTANCE, 0) *
994: NVL(D.VOLUME, 0) ) ) AS TLCostPerUnitCubeDist
995: FROM MST_DELIVERY_LEGS DL,
996: MST_DELIVERIES D,
997: MST_TRIPS T,
998: MST_TRIP_STOPS TS
999: WHERE DL.PLAN_ID = D.PLAN_ID
1000: AND DL.DELIVERY_ID = D.DELIVERY_ID
1001: AND DL.PLAN_ID = TS.PLAN_ID

Line 1018: MST_TRIPS T,

1014: SUM(NVL(DL.DIRECT_DISTANCE, 0) *
1015: NVL(D.VOLUME, 0) ) ) TLCostPerUnitCubeDist
1016: FROM MST_DELIVERY_LEGS DL,
1017: MST_DELIVERIES D,
1018: MST_TRIPS T,
1019: MST_TRIP_STOPS TS
1020: WHERE DL.PLAN_ID = D.PLAN_ID
1021: AND DL.DELIVERY_ID = D.DELIVERY_ID
1022: AND DL.PLAN_ID = TS.PLAN_ID

Line 1136: FROM MST_TRIPS T

1132: NVL(T.TOTAL_STOP_COST, 0) +
1133: NVL(T.TOTAL_LAYOVER_COST, 0) +
1134: NVL(T.TOTAL_LOAD_UNLOAD_COST, 0) +
1135: NVL(T.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
1136: FROM MST_TRIPS T
1137: WHERE T.PLAN_ID = p_plan_id
1138: AND T.MODE_OF_TRANSPORT = g_tload
1139: ) T11,
1140: ( SELECT SUM(NVL(TS.DISTANCE_TO_NEXT_STOP, 0) *

Line 1143: MST_TRIPS T1

1139: ) T11,
1140: ( SELECT SUM(NVL(TS.DISTANCE_TO_NEXT_STOP, 0) *
1141: NVL(TS.DEPARTURE_GROSS_WEIGHT, 0) ) TotalTLWeightDist
1142: FROM MST_TRIP_STOPS TS,
1143: MST_TRIPS T1
1144: WHERE TS.PLAN_ID = T1.PLAN_ID
1145: AND TS.TRIP_ID = T1.TRIP_ID
1146: AND T1.PLAN_ID = p_plan_id
1147: AND T1.MODE_OF_TRANSPORT = g_tload

Line 1160: FROM MST_TRIPS T1

1156: NVL(T1.TOTAL_STOP_COST, 0) +
1157: NVL(T1.TOTAL_LAYOVER_COST, 0) +
1158: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
1159: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
1160: FROM MST_TRIPS T1
1161: WHERE T1.PLAN_ID = p_plan_id
1162: AND T1.MODE_OF_TRANSPORT = g_tload
1163: ) T11,
1164: ( SELECT SUM(NVL(DL.DIRECT_DISTANCE, 0) *

Line 1168: MST_TRIPS T2,

1164: ( SELECT SUM(NVL(DL.DIRECT_DISTANCE, 0) *
1165: NVL(D.GROSS_WEIGHT, 0) ) TotalTLWeightDist
1166: FROM MST_DELIVERY_LEGS DL,
1167: MST_DELIVERIES D,
1168: MST_TRIPS T2,
1169: MST_TRIP_STOPS TS
1170: WHERE DL.PLAN_ID = D.PLAN_ID
1171: AND DL.DELIVERY_ID = D.DELIVERY_ID
1172: AND DL.PLAN_ID = TS.PLAN_ID

Line 1198: FROM MST_TRIPS T1

1194: NVL(T1.TOTAL_STOP_COST, 0) +
1195: NVL(T1.TOTAL_LAYOVER_COST, 0) +
1196: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
1197: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
1198: FROM MST_TRIPS T1
1199: WHERE T1.PLAN_ID = p_plan_id
1200: AND T1.MODE_OF_TRANSPORT = g_tload
1201: AND T1.CARRIER_ID = p_carrier_id
1202: ) T11,

Line 1206: MST_TRIPS T2

1202: ) T11,
1203: ( SELECT SUM(NVL(TS.DISTANCE_TO_NEXT_STOP, 0) *
1204: NVL(TS.DEPARTURE_GROSS_WEIGHT, 0) ) TotalTLWeightDist
1205: FROM MST_TRIP_STOPS TS,
1206: MST_TRIPS T2
1207: WHERE TS.PLAN_ID = T2.PLAN_ID
1208: AND TS.TRIP_ID = T2.TRIP_ID
1209: AND T2.PLAN_ID = p_plan_id
1210: AND T2.MODE_OF_TRANSPORT = g_tload

Line 1224: FROM MST_TRIPS T1

1220: NVL(T1.TOTAL_STOP_COST, 0) +
1221: NVL(T1.TOTAL_LAYOVER_COST, 0) +
1222: NVL(T1.TOTAL_LOAD_UNLOAD_COST, 0) +
1223: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalTLCost
1224: FROM MST_TRIPS T1
1225: WHERE T1.PLAN_ID = p_plan_id
1226: AND T1.MODE_OF_TRANSPORT = g_tload
1227: AND T1.CARRIER_ID = p_carrier_id
1228: ) T11,

Line 1233: MST_TRIPS T2,

1229: ( SELECT SUM(NVL(DL.DIRECT_DISTANCE, 0) *
1230: NVL(D.GROSS_WEIGHT, 0) ) TotalTLWeightDist
1231: FROM MST_DELIVERY_LEGS DL,
1232: MST_DELIVERIES D,
1233: MST_TRIPS T2,
1234: MST_TRIP_STOPS TS
1235: WHERE DL.PLAN_ID = D.PLAN_ID
1236: AND DL.DELIVERY_ID = D.DELIVERY_ID
1237: AND DL.PLAN_ID = TS.PLAN_ID

Line 1264: MST_TRIPS T,

1260: SUM(NVL(DL.TRAVELED_DISTANCE, 0) *
1261: NVL(D.GROSS_WEIGHT, 0) ) ) TLCostPerUnitWtDist
1262: FROM MST_DELIVERY_LEGS DL,
1263: MST_DELIVERIES D,
1264: MST_TRIPS T,
1265: MST_TRIP_STOPS TS
1266: WHERE DL.PLAN_ID = D.PLAN_ID
1267: AND DL.DELIVERY_ID = D.DELIVERY_ID
1268: AND D.CUSTOMER_ID = p_customer_id

Line 1285: MST_TRIPS T,

1281: SUM(NVL(DL.DIRECT_DISTANCE, 0) *
1282: NVL(D.GROSS_WEIGHT, 0) ) ) TLCostPerUnitWtDist
1283: FROM MST_DELIVERY_LEGS DL,
1284: MST_DELIVERIES D,
1285: MST_TRIPS T,
1286: MST_TRIP_STOPS TS
1287: WHERE DL.PLAN_ID = D.PLAN_ID
1288: AND DL.DELIVERY_ID = D.DELIVERY_ID
1289: AND D.CUSTOMER_ID = p_customer_id

Line 1315: MST_TRIPS T,

1311: SUM(NVL(DL.TRAVELED_DISTANCE, 0) *
1312: NVL(D.GROSS_WEIGHT, 0) ) ) TLCostPerUnitWtDist
1313: FROM MST_DELIVERY_LEGS DL,
1314: MST_DELIVERIES D,
1315: MST_TRIPS T,
1316: MST_TRIP_STOPS TS
1317: WHERE DL.PLAN_ID = D.PLAN_ID
1318: AND DL.DELIVERY_ID = D.DELIVERY_ID
1319: AND D.SUPPLIER_ID = p_supplier_id

Line 1336: MST_TRIPS T,

1332: SUM(NVL(DL.DIRECT_DISTANCE, 0) *
1333: NVL(D.GROSS_WEIGHT, 0) ) ) TLCostPerUnitWtDist
1334: FROM MST_DELIVERY_LEGS DL,
1335: MST_DELIVERIES D,
1336: MST_TRIPS T,
1337: MST_TRIP_STOPS TS
1338: WHERE DL.PLAN_ID = D.PLAN_ID
1339: AND DL.DELIVERY_ID = D.DELIVERY_ID
1340: AND D.SUPPLIER_ID = p_supplier_id

Line 1366: MST_TRIPS T,

1362: SUM(NVL(DL.TRAVELED_DISTANCE, 0) *
1363: NVL(D.GROSS_WEIGHT, 0) ) ) AS TLCostPerUnitWtDist
1364: FROM MST_DELIVERY_LEGS DL,
1365: MST_DELIVERIES D,
1366: MST_TRIPS T,
1367: MST_TRIP_STOPS TS
1368: WHERE DL.PLAN_ID = D.PLAN_ID
1369: AND DL.DELIVERY_ID = D.DELIVERY_ID
1370: AND DL.PLAN_ID = TS.PLAN_ID

Line 1387: MST_TRIPS T,

1383: SUM(NVL(DL.DIRECT_DISTANCE, 0) *
1384: NVL(D.GROSS_WEIGHT, 0) ) ) TLCostPerUnitWtDist
1385: FROM MST_DELIVERY_LEGS DL,
1386: MST_DELIVERIES D,
1387: MST_TRIPS T,
1388: MST_TRIP_STOPS TS
1389: WHERE DL.PLAN_ID = D.PLAN_ID
1390: AND DL.DELIVERY_ID = D.DELIVERY_ID
1391: AND DL.PLAN_ID = TS.PLAN_ID