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_DELIVERY_LEGS

Line 194: FROM MST_DELIVERY_LEGS DL,

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,
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

Line 217: FROM MST_DELIVERY_LEGS DL,

213: NVL(DL.ALLOCATED_FAC_UNLOADING_COST, 0) +
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

Line 229: FROM MST_DELIVERY_LEGS DL1

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
230: WHERE DL1.PLAN_ID = D1.PLAN_ID
231: AND DL1.DELIVERY_ID = D1.DELIVERY_ID
232: )
233: ) T2;

Line 249: FROM MST_DELIVERY_LEGS DL,

245: NVL(DL.ALLOCATED_FAC_UNLOADING_COST, 0) +
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

Line 261: FROM MST_DELIVERY_LEGS DL1

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
262: WHERE DL1.PLAN_ID = D1.PLAN_ID
263: AND DL1.DELIVERY_ID = D1.DELIVERY_ID
264: )
265: ) T2;

Line 282: FROM MST_DELIVERY_LEGS DL,

278: NVL(DL.ALLOCATED_FAC_UNLOADING_COST, 0) +
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

Line 296: FROM MST_DELIVERY_LEGS DL1

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
296: FROM MST_DELIVERY_LEGS DL1
297: WHERE DL1.DELIVERY_ID = D1.DELIVERY_ID
298: AND DL1.PLAN_ID = D1.PLAN_ID
299: )
300: ) T2;

Line 500: FROM MST_DELIVERY_LEGS DL,

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,
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

Line 524: FROM MST_DELIVERY_LEGS DL,

520: NVL(DL.ALLOCATED_FAC_UNLOADING_COST, 0)+
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

Line 536: FROM MST_DELIVERY_LEGS DL1

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
537: WHERE DL1.PLAN_ID = D1.PLAN_ID
538: AND DL1.DELIVERY_ID = D1.DELIVERY_ID
539: )
540: ) T2;

Line 556: FROM MST_DELIVERY_LEGS DL,

552: NVL(DL.ALLOCATED_FAC_UNLOADING_COST, 0)+
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

Line 568: FROM MST_DELIVERY_LEGS DL1

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
569: WHERE DL1.PLAN_ID = D1.PLAN_ID
570: AND DL1.DELIVERY_ID = D1.DELIVERY_ID
571: )
572: ) T2;

Line 589: FROM MST_DELIVERY_LEGS DL,

585: NVL(DL.ALLOCATED_FAC_UNLOADING_COST, 0) +
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

Line 603: FROM MST_DELIVERY_LEGS DL1

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
603: FROM MST_DELIVERY_LEGS DL1
604: WHERE DL1.DELIVERY_ID = D1.DELIVERY_ID
605: AND DL1.PLAN_ID = D1.PLAN_ID
606: )
607: ) T2;

Line 798: FROM MST_DELIVERY_LEGS DL,

794: AND T1.MODE_OF_TRANSPORT = g_tload
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

Line 864: FROM MST_DELIVERY_LEGS DL,

860: AND T1.MODE_OF_TRANSPORT = g_tload
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

Line 894: FROM MST_DELIVERY_LEGS DL,

890: CURSOR cur_tl_cpucd_act_cust IS
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

Line 915: FROM MST_DELIVERY_LEGS DL,

911: CURSOR cur_tl_cpucd_direct_cust IS
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

Line 944: FROM MST_DELIVERY_LEGS DL,

940: CURSOR cur_tl_cpucd_act_supp IS
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

Line 965: FROM MST_DELIVERY_LEGS DL,

961: CURSOR cur_tl_cpucd_direct_supp IS
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

Line 995: FROM MST_DELIVERY_LEGS DL,

991: CURSOR cur_tl_cpucd_act_fac(p_location_id IN NUMBER) IS
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

Line 1016: FROM MST_DELIVERY_LEGS DL,

1012: CURSOR cur_tl_cpucd_direct_fac(p_location_id IN NUMBER) IS
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

Line 1166: FROM MST_DELIVERY_LEGS DL,

1162: AND T1.MODE_OF_TRANSPORT = g_tload
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

Line 1231: FROM MST_DELIVERY_LEGS DL,

1227: AND T1.CARRIER_ID = p_carrier_id
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

Line 1262: FROM MST_DELIVERY_LEGS DL,

1258: CURSOR cur_tl_cpuwd_act_cust IS
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

Line 1283: FROM MST_DELIVERY_LEGS DL,

1279: CURSOR cur_tl_cpuwd_direct_cust IS
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

Line 1313: FROM MST_DELIVERY_LEGS DL,

1309: CURSOR cur_tl_cpuwd_act_supp IS
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

Line 1334: FROM MST_DELIVERY_LEGS DL,

1330: CURSOR cur_tl_cpuwd_direct_supp IS
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

Line 1364: FROM MST_DELIVERY_LEGS DL,

1360: CURSOR cur_tl_cpuwd_act_fac(p_location_id IN NUMBER) IS
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

Line 1385: FROM MST_DELIVERY_LEGS DL,

1381: CURSOR cur_tl_cpuwd_direct_fac(p_location_id IN NUMBER) IS
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