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_DELIVERIES

Line 190: FROM MST_DELIVERIES D

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
190: FROM MST_DELIVERIES D
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,

Line 218: MST_DELIVERIES D

214: NVL(DL.ALLOCATED_FAC_SHP_HAND_COST, 0) +
215: NVL(DL.ALLOCATED_FAC_REC_HAND_COST, 0) +
216: NVL(DL.ALLOCATED_TRANSPORT_COST, 0) ) TotalCost
217: FROM MST_DELIVERY_LEGS DL,
218: MST_DELIVERIES D
219: WHERE DL.PLAN_ID = p_plan_Id
220: AND DL.PLAN_ID = D.PLAN_ID
221: AND DL.DELIVERY_ID = D.DELIVERY_ID
222: AND D.CUSTOMER_ID = p_customer_id

Line 225: FROM MST_DELIVERIES D1

221: AND DL.DELIVERY_ID = D.DELIVERY_ID
222: AND D.CUSTOMER_ID = p_customer_id
223: ) T1,
224: (SELECT SUM(D1.GROSS_WEIGHT) TotalWeight
225: FROM MST_DELIVERIES D1
226: WHERE D1.PLAN_ID = p_plan_id
227: AND D1.CUSTOMER_ID = p_customer_id
228: AND EXISTS (SELECT DL1.DELIVERY_LEG_ID
229: FROM MST_DELIVERY_LEGS DL1

Line 250: MST_DELIVERIES D

246: NVL(DL.ALLOCATED_FAC_SHP_HAND_COST, 0) +
247: NVL(DL.ALLOCATED_FAC_REC_HAND_COST, 0) +
248: NVL(DL.ALLOCATED_TRANSPORT_COST, 0) ) TotalCost
249: FROM MST_DELIVERY_LEGS DL,
250: MST_DELIVERIES D
251: WHERE DL.PLAN_ID = p_plan_id
252: AND DL.PLAN_ID = D.PLAN_ID
253: AND DL.DELIVERY_ID = D.DELIVERY_ID
254: AND D.SUPPLIER_ID = p_Supplier_ID

Line 257: FROM MST_DELIVERIES D1

253: AND DL.DELIVERY_ID = D.DELIVERY_ID
254: AND D.SUPPLIER_ID = p_Supplier_ID
255: ) T1,
256: ( SELECT SUM(D1.GROSS_WEIGHT) TotalWeight
257: FROM MST_DELIVERIES D1
258: WHERE D1.PLAN_ID = p_plan_id
259: AND D1.SUPPLIER_ID = p_Supplier_ID
260: AND EXISTS (SELECT DL1.DELIVERY_LEG_ID
261: FROM MST_DELIVERY_LEGS DL1

Line 283: MST_DELIVERIES D

279: NVL(DL.ALLOCATED_FAC_SHP_HAND_COST, 0) +
280: NVL(DL.ALLOCATED_FAC_REC_HAND_COST, 0) +
281: NVL(DL.ALLOCATED_TRANSPORT_COST, 0) ) TotalCost
282: FROM MST_DELIVERY_LEGS DL,
283: MST_DELIVERIES D
284: WHERE DL.PLAN_ID = p_plan_id
285: AND DL.PLAN_ID = D.PLAN_ID
286: AND DL.DELIVERY_ID = D.DELIVERY_ID
287: AND ( D.PICKUP_LOCATION_ID = p_location_id

Line 291: FROM MST_DELIVERIES D1

287: AND ( D.PICKUP_LOCATION_ID = p_location_id
288: OR D.DROPOFF_LOCATION_ID = p_location_id )
289: ) T1,
290: ( SELECT SUM(D1.GROSS_WEIGHT) TotalWeight
291: FROM MST_DELIVERIES D1
292: WHERE D1.PLAN_ID = p_plan_Id
293: AND ( D1.DROPOFF_LOCATION_ID = p_location_id
294: OR D1.PICKUP_LOCATION_ID = p_location_id )
295: AND EXISTS (SELECT DL1.DELIVERY_LEG_ID

Line 496: FROM MST_DELIVERIES D

492: WHERE T1.PLAN_ID = p_plan_id
493: AND T1.CARRIER_ID = p_carrier_id
494: ) T11,
495: (SELECT SUM(d.VOLUME) TotalVolume
496: FROM MST_DELIVERIES D
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,

Line 525: MST_DELIVERIES D

521: NVL(DL.ALLOCATED_FAC_SHP_HAND_COST, 0) +
522: NVL(DL.ALLOCATED_FAC_REC_HAND_COST, 0) +
523: NVL(DL.ALLOCATED_TRANSPORT_COST, 0) ) TotalCost
524: FROM MST_DELIVERY_LEGS DL,
525: MST_DELIVERIES D
526: WHERE DL.PLAN_ID = p_plan_id
527: AND DL.PLAN_ID = D.PLAN_ID
528: AND DL.DELIVERY_ID = D.DELIVERY_ID
529: AND D.CUSTOMER_ID = p_customer_id

Line 532: FROM MST_DELIVERIES D1

528: AND DL.DELIVERY_ID = D.DELIVERY_ID
529: AND D.CUSTOMER_ID = p_customer_id
530: ) T1,
531: ( SELECT SUM(D1.VOLUME) TotalVolume
532: FROM MST_DELIVERIES D1
533: WHERE D1.PLAN_ID = p_plan_id
534: AND D1.CUSTOMER_ID = p_customer_id
535: AND EXISTS (SELECT DL1.DELIVERY_LEG_ID
536: FROM MST_DELIVERY_LEGS DL1

Line 557: MST_DELIVERIES D

553: NVL(DL.ALLOCATED_FAC_SHP_HAND_COST, 0) +
554: NVL(DL.ALLOCATED_FAC_REC_HAND_COST, 0) +
555: NVL(DL.ALLOCATED_TRANSPORT_COST, 0) ) TotalCost
556: FROM MST_DELIVERY_LEGS DL,
557: MST_DELIVERIES D
558: WHERE DL.PLAN_ID = p_plan_id
559: AND DL.PLAN_ID = D.PLAN_ID
560: AND DL.DELIVERY_ID = D.DELIVERY_ID
561: AND D.SUPPLIER_ID = p_supplier_id

Line 564: FROM MST_DELIVERIES D1

560: AND DL.DELIVERY_ID = D.DELIVERY_ID
561: AND D.SUPPLIER_ID = p_supplier_id
562: ) T1,
563: (SELECT SUM(D1.VOLUME) TotalVolume
564: FROM MST_DELIVERIES D1
565: WHERE D1.PLAN_ID = p_plan_id
566: AND D1.SUPPLIER_ID = p_supplier_id
567: AND EXISTS ( SELECT DL1.DELIVERY_LEG_ID
568: FROM MST_DELIVERY_LEGS DL1

Line 590: MST_DELIVERIES D

586: NVL(DL.ALLOCATED_FAC_SHP_HAND_COST, 0) +
587: NVL(DL.ALLOCATED_FAC_REC_HAND_COST, 0) +
588: NVL(DL.ALLOCATED_TRANSPORT_COST, 0) ) TotalCost
589: FROM MST_DELIVERY_LEGS DL,
590: MST_DELIVERIES D
591: WHERE DL.PLAN_ID = p_plan_id
592: AND DL.PLAN_ID = D.PLAN_ID
593: AND DL.DELIVERY_ID = D.DELIVERY_ID
594: AND ( D.PICKUP_LOCATION_ID = p_location_id

Line 598: FROM MST_DELIVERIES D1

594: AND ( D.PICKUP_LOCATION_ID = p_location_id
595: OR D.DROPOFF_LOCATION_ID = p_location_id )
596: ) T1,
597: ( SELECT SUM(D1.VOLUME) TotalVolume
598: FROM MST_DELIVERIES D1
599: WHERE D1.PLAN_ID = p_plan_id
600: AND ( D1.DROPOFF_LOCATION_ID = p_location_id
601: OR D1.PICKUP_LOCATION_ID = p_location_id )
602: AND EXISTS (SELECT DL1.DELIVERY_LEG_ID

Line 799: MST_DELIVERIES D,

795: ) T11,
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

Line 865: MST_DELIVERIES D,

861: ) T11,
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

Line 895: MST_DELIVERIES D,

891: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 916: MST_DELIVERIES D,

912: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 945: MST_DELIVERIES D,

941: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 966: MST_DELIVERIES D,

962: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 996: MST_DELIVERIES D,

992: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1017: MST_DELIVERIES D,

1013: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1167: MST_DELIVERIES D,

1163: ) T11,
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

Line 1232: MST_DELIVERIES D,

1228: ) T11,
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

Line 1263: MST_DELIVERIES D,

1259: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1284: MST_DELIVERIES D,

1280: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1314: MST_DELIVERIES D,

1310: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1335: MST_DELIVERIES D,

1331: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1365: MST_DELIVERIES D,

1361: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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

Line 1386: MST_DELIVERIES D,

1382: SELECT (SUM(DL.ALLOCATED_TRANSPORT_COST) /
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