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.FTE_TRACKING_WRAPPER dependencies on WSH_TRIPS

Line 1000: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id, wsh_new_deliveries.waybill,

996: IF (UPPER(l_tracking_id_type) = 'WAYBILL') THEN
997:
998:
999: SELECT /*+ first_rows ordered */
1000: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id, wsh_new_deliveries.waybill,
1001: wsh_delivery_legs.delivery_leg_id
1002: INTO l_delivery_id, l_carrier_id, l_waybill, l_delivery_leg_id
1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

Line 1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries

999: SELECT /*+ first_rows ordered */
1000: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id, wsh_new_deliveries.waybill,
1001: wsh_delivery_legs.delivery_leg_id
1002: INTO l_delivery_id, l_carrier_id, l_waybill, l_delivery_leg_id
1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1007: AND wsh_trips.carrier_id = l_carrier_id

Line 1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id

1002: INTO l_delivery_id, l_carrier_id, l_waybill, l_delivery_leg_id
1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1007: AND wsh_trips.carrier_id = l_carrier_id
1008: AND wsh_new_deliveries.waybill = l_tracking_id
1009: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1010:

Line 1007: AND wsh_trips.carrier_id = l_carrier_id

1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1007: AND wsh_trips.carrier_id = l_carrier_id
1008: AND wsh_new_deliveries.waybill = l_tracking_id
1009: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1010:
1011:

Line 1093: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id,

1089:
1090: ELSIF (upper(l_tracking_id_type) = 'BOOKING NUMBER')
1091: THEN
1092: SELECT /*+ first_rows ordered */
1093: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id,
1094: wsh_delivery_legs.booking_number, wsh_delivery_legs.delivery_leg_id
1095: INTO l_delivery_id, l_carrier_id, l_booking_number, l_delivery_leg_id
1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

Line 1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries

1092: SELECT /*+ first_rows ordered */
1093: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id,
1094: wsh_delivery_legs.booking_number, wsh_delivery_legs.delivery_leg_id
1095: INTO l_delivery_id, l_carrier_id, l_booking_number, l_delivery_leg_id
1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1100: AND wsh_trips.carrier_id = l_carrier_id

Line 1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id

1095: INTO l_delivery_id, l_carrier_id, l_booking_number, l_delivery_leg_id
1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1100: AND wsh_trips.carrier_id = l_carrier_id
1101: AND wsh_delivery_legs.booking_number = l_tracking_id
1102: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1103:

Line 1100: AND wsh_trips.carrier_id = l_carrier_id

1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1100: AND wsh_trips.carrier_id = l_carrier_id
1101: AND wsh_delivery_legs.booking_number = l_tracking_id
1102: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1103:
1104:

Line 1183: wsh_trips.carrier_id

1179:
1180: elsif (upper(l_tracking_id_type) = 'BILL OF LADING')
1181: then
1182: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1183: wsh_trips.carrier_id
1184: into l_delivery_id, l_delivery_leg_id, l_carrier_id
1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops
1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

Line 1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops

1181: then
1182: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1183: wsh_trips.carrier_id
1184: into l_delivery_id, l_delivery_leg_id, l_carrier_id
1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops
1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

Line 1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops
1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1190: and wsh_trips.carrier_id = l_carrier_id
1191: and wsh_bols_rd_v.bill_of_lading_number = l_tracking_id
1192: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1193:

Line 1190: and wsh_trips.carrier_id = l_carrier_id

1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1190: and wsh_trips.carrier_id = l_carrier_id
1191: and wsh_bols_rd_v.bill_of_lading_number = l_tracking_id
1192: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1193:
1194:

Line 1276: wsh_trips.carrier_id, wsh_delivery_details.container_name,

1272:
1273: elsif (upper(l_tracking_id_type) = 'LICENSE PLATE NUMBER')
1274: then -- license plate number is only used by container
1275: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1276: wsh_trips.carrier_id, wsh_delivery_details.container_name,
1277: wsh_delivery_details.delivery_detail_id
1278: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_container_name,
1279: l_delivery_detail_id
1280: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips, wsh_trip_stops,

Line 1280: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips, wsh_trip_stops,

1276: wsh_trips.carrier_id, wsh_delivery_details.container_name,
1277: wsh_delivery_details.delivery_detail_id
1278: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_container_name,
1279: l_delivery_detail_id
1280: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips, wsh_trip_stops,
1281: wsh_delivery_details, wsh_delivery_assignments
1282: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_ID
1283: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1284: wsh_delivery_details.DELIVERY_DETAIL_ID

Line 1287: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

1283: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1284: wsh_delivery_details.DELIVERY_DETAIL_ID
1285: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1286: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1287: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1288: and wsh_trips.carrier_id = l_carrier_id
1289: and wsh_delivery_details.container_name = l_tracking_id
1290: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1291:

Line 1288: and wsh_trips.carrier_id = l_carrier_id

1284: wsh_delivery_details.DELIVERY_DETAIL_ID
1285: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1286: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1287: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1288: and wsh_trips.carrier_id = l_carrier_id
1289: and wsh_delivery_details.container_name = l_tracking_id
1290: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1291:
1292:

Line 1347: wsh_trips wt,

1343: wdd.delivery_detail_id
1344: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_seal_code,
1345: l_delivery_detail_id
1346: from
1347: wsh_trips wt,
1348: wsh_trip_stops wts,
1349: wsh_delivery_legs wdl,
1350: wsh_new_deliveries wnd,
1351: wsh_delivery_assignments wda,

Line 1426: wsh_trips.carrier_id, wsh_delivery_details.tracking_number,

1422: -- not in wsh_new_deliveries level
1423:
1424:
1425: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1426: wsh_trips.carrier_id, wsh_delivery_details.tracking_number,
1427: wsh_delivery_details.delivery_detail_id
1428: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_tracking_number,
1429: l_delivery_detail_id
1430: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips,

Line 1430: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips,

1426: wsh_trips.carrier_id, wsh_delivery_details.tracking_number,
1427: wsh_delivery_details.delivery_detail_id
1428: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_tracking_number,
1429: l_delivery_detail_id
1430: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips,
1431: wsh_trip_stops, wsh_delivery_details, wsh_delivery_assignments
1432: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_ID
1433: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1434: wsh_delivery_details.DELIVERY_DETAIL_ID

Line 1437: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

1433: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1434: wsh_delivery_details.DELIVERY_DETAIL_ID
1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1437: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1438: and wsh_trips.carrier_id = l_carrier_id
1439: and wsh_delivery_details.tracking_number = l_tracking_id
1440: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1441:

Line 1438: and wsh_trips.carrier_id = l_carrier_id

1434: wsh_delivery_details.DELIVERY_DETAIL_ID
1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1437: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1438: and wsh_trips.carrier_id = l_carrier_id
1439: and wsh_delivery_details.tracking_number = l_tracking_id
1440: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1441:
1442: