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_TRIP_STOPS

Line 774: FROM MST_TRIP_STOPS TS,

770: AND T.MODE_OF_TRANSPORT = g_tload
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

Line 801: MST_TRIP_STOPS TS

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
805: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 838: FROM MST_TRIP_STOPS TS,

834: AND T.MODE_OF_TRANSPORT = g_tload
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

Line 867: MST_TRIP_STOPS TS

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
871: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 897: MST_TRIP_STOPS TS

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
901: AND DL.PLAN_ID = TS.PLAN_ID

Line 918: MST_TRIP_STOPS TS

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
922: AND DL.PLAN_ID = TS.PLAN_ID

Line 947: MST_TRIP_STOPS TS

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
951: AND DL.PLAN_ID = TS.PLAN_ID

Line 968: MST_TRIP_STOPS TS

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
972: AND DL.PLAN_ID = TS.PLAN_ID

Line 998: MST_TRIP_STOPS TS

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
1002: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 1019: MST_TRIP_STOPS TS

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
1023: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 1142: FROM MST_TRIP_STOPS TS,

1138: AND T.MODE_OF_TRANSPORT = g_tload
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

Line 1169: MST_TRIP_STOPS TS

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
1173: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 1205: FROM MST_TRIP_STOPS TS,

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

Line 1234: MST_TRIP_STOPS TS

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
1238: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 1265: MST_TRIP_STOPS TS

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
1269: AND DL.PLAN_iD = TS.PLAN_ID

Line 1286: MST_TRIP_STOPS TS

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
1290: AND DL.PLAN_iD = TS.PLAN_ID

Line 1316: MST_TRIP_STOPS TS

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
1320: AND DL.PLAN_iD = TS.PLAN_ID

Line 1337: MST_TRIP_STOPS TS

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
1341: AND DL.PLAN_iD = TS.PLAN_ID

Line 1367: MST_TRIP_STOPS TS

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
1371: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID

Line 1388: MST_TRIP_STOPS TS

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
1392: AND ( DL.PICK_UP_STOP_ID = TS.STOP_ID