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_DELIVERY_DETAILS

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 1277: wsh_delivery_details.delivery_detail_id

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,
1281: wsh_delivery_details, wsh_delivery_assignments

Line 1281: wsh_delivery_details, wsh_delivery_assignments

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
1285: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

Line 1284: wsh_delivery_details.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
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

Line 1289: and wsh_delivery_details.container_name = l_tracking_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:
1293:

Line 1352: wsh_delivery_details wdd

1348: wsh_trip_stops wts,
1349: wsh_delivery_legs wdl,
1350: wsh_new_deliveries wnd,
1351: wsh_delivery_assignments wda,
1352: wsh_delivery_details wdd
1353: where wda.DELIVERY_ID = wnd.DELIVERY_ID
1354: and wda.DELIVERY_DETAIL_ID = wdd.DELIVERY_DETAIL_ID
1355: and wdl.delivery_id = wnd.delivery_id
1356: and wdl.pick_up_stop_id = wts.stop_id

Line 1373: select container_name into l_container_name from wsh_delivery_details

1369: (WSH_DELIVERY_LEG_ACTIVITIES_S.nextval, l_delivery_leg_id, sysdate, 'TRACKING',
1370: sysdate, l_carrier_id, sysdate, l_carrier_id);
1371:
1372: begin
1373: select container_name into l_container_name from wsh_delivery_details
1374: where delivery_detail_id = l_delivery_detail_id;
1375:
1376:
1377: exception

Line 1421: -- It is only in wsh_delivery_details level,

1417:
1418:
1419: elsif (upper(l_tracking_id_type) = 'CARRIER REFERENCE NUMBER')
1420: then -- tracking number is only used for container.
1421: -- It is only in wsh_delivery_details level,
1422: -- not in wsh_new_deliveries level
1423:
1424:
1425: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,

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 1427: wsh_delivery_details.delivery_detail_id

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,
1431: wsh_trip_stops, wsh_delivery_details, wsh_delivery_assignments

Line 1431: wsh_trip_stops, wsh_delivery_details, wsh_delivery_assignments

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
1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

Line 1434: wsh_delivery_details.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
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

Line 1439: and wsh_delivery_details.tracking_number = l_tracking_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:
1443:

Line 1452: select container_name into l_container_name from wsh_delivery_details

1448: (WSH_DELIVERY_LEG_ACTIVITIES_S.nextval, l_delivery_leg_id, sysdate, 'TRACKING',
1449: sysdate, l_carrier_id, sysdate, l_carrier_id);
1450:
1451: begin
1452: select container_name into l_container_name from wsh_delivery_details
1453: where delivery_detail_id = l_delivery_detail_id;
1454: exception
1455: WHEN NO_DATA_FOUND THEN
1456: raise no_license_plate;