APPS.WSH_MBOLS_PVT dependencies on WSH_TRIP_STOPS

Line 256: wsh_trip_stops st,

252: del.initial_pickup_location_id,
253: wt.name
254: FROM wsh_new_deliveries del,
255: wsh_delivery_legs dlg,
256: wsh_trip_stops st,
257: wsh_trips wt
258: WHERE del.delivery_id = dlg.delivery_id
259: AND dlg.pick_up_stop_id = st.stop_id
260: AND dlg.parent_delivery_leg_id IS NULL

Line 1007: wsh_trip_stops

1003:
1004: cursor locations_csr is
1005: select stop_location_id into l_location_id
1006: from
1007: wsh_trip_stops
1008: where trip_id = p_trip_id
1009: order by stop_sequence_number desc;
1010:
1011: cursor organizations_csr(p_location_id NUMBER) is

Line 1069: from wsh_trip_stops wts, wsh_delivery_legs wdl

1065: If l_organization_id is null then
1066: --{
1067: select min(delivery_id)
1068: into l_first_delivery_id
1069: from wsh_trip_stops wts, wsh_delivery_legs wdl
1070: where wts.trip_id = p_trip_id
1071: and wts.stop_id = wdl.pick_up_stop_id;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.log(l_module_name,'l_first_delivery_id', l_first_delivery_id);