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_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 1282: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_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
1286: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

Line 1283: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =

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

Line 1351: wsh_delivery_assignments wda,

1347: wsh_trips wt,
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

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 1432: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_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
1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

Line 1433: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =

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