APPS.FTE_TRACKING_WRAPPER dependencies on WSH_BOLS_RD_V

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 1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id

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
1190: and wsh_trips.carrier_id = l_carrier_id

Line 1191: and wsh_bols_rd_v.bill_of_lading_number = l_tracking_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:
1195: insert into wsh_delivery_leg_activities