APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIP_STOPS

Line 561: wsh_trip_stops_ob_grp_v pickup_stop,

557: BEGIN
558: select trip.name, trip.trip_id
559: into l_trip_name, l_trip_id
560: from wsh_trips_ob_grp_v trip,
561: wsh_trip_stops_ob_grp_v pickup_stop,
562: wsh_trip_stops_ob_grp_v dropoff_stop,
563: wsh_delivery_legs_ob_grp_v wdl,
564: wsh_new_deliveries_ob_grp_v wnd
565: where wdl.delivery_id = wnd.delivery_id(+)

Line 562: wsh_trip_stops_ob_grp_v dropoff_stop,

558: select trip.name, trip.trip_id
559: into l_trip_name, l_trip_id
560: from wsh_trips_ob_grp_v trip,
561: wsh_trip_stops_ob_grp_v pickup_stop,
562: wsh_trip_stops_ob_grp_v dropoff_stop,
563: wsh_delivery_legs_ob_grp_v wdl,
564: wsh_new_deliveries_ob_grp_v wnd
565: where wdl.delivery_id = wnd.delivery_id(+)
566: and wdl.delivery_id = p_delivery_id

Line 592: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl

588: p_trip_id IN NUMBER) IS
589: BEGIN
590: open x_dock_door for
591: select hrl.location_code
592: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl
593: where wts.stop_location_id = hrl.location_id
594: and wts.trip_id = p_trip_id;
595: END get_dock_door;
596:

Line 2310: FROM wsh_trip_stops s1,

2306: l_is_last VARCHAR2(1) := 'N';
2307: l_trip_id NUMBER;
2308: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS
2309: SELECT s1.trip_id
2310: FROM wsh_trip_stops s1,
2311: wsh_delivery_legs dl1,
2312: wsh_new_deliveries d1,
2313: wsh_trip_stops s2,
2314: wsh_delivery_legs dl2

Line 2313: wsh_trip_stops s2,

2309: SELECT s1.trip_id
2310: FROM wsh_trip_stops s1,
2311: wsh_delivery_legs dl1,
2312: wsh_new_deliveries d1,
2313: wsh_trip_stops s2,
2314: wsh_delivery_legs dl2
2315: WHERE d1.delivery_id <> l_delivery_id
2316: AND s1.stop_id = dl1.pick_up_stop_id
2317: AND d1.delivery_id = dl1.delivery_id

Line 2369: FROM wsh_trip_stops wts, wsh_trips wt, wsh_delivery_legs wdl

2365:
2366: --Added for Bug 14696492
2367: CURSOR get_dlvy_trip(p_delivery_id NUMBER) IS
2368: SELECT wts.trip_id, wt.name
2369: FROM wsh_trip_stops wts, wsh_trips wt, wsh_delivery_legs wdl
2370: WHERE wdl.delivery_id = p_delivery_id
2371: AND wdl.pick_up_stop_id = wts.stop_id
2372: AND wts.trip_id = wt.trip_id;
2373: l_mul_del_trip VARCHAR2(1) := 'N';

Line 2413: FROM wsh_trip_stops wts, wsh_delivery_legs wdl

2409:
2410: BEGIN
2411: SELECT 'Y'
2412: INTO l_mul_del_trip
2413: FROM wsh_trip_stops wts, wsh_delivery_legs wdl
2414: WHERE wts.trip_id = l_trip_id
2415: AND wdl.pick_up_stop_id = wts.stop_id
2416: AND wdl.delivery_id <> p_delivery_id;
2417: EXCEPTION

Line 3145: wsh_trip_stops st,

3141: INTO x_trip_shipmethod_code,
3142: p_trip_id
3143: FROM wsh_new_deliveries del,
3144: wsh_delivery_legs dlg,
3145: wsh_trip_stops st,
3146: wsh_trips wt
3147: WHERE del.delivery_id = dlg.delivery_id
3148: AND dlg.pick_up_stop_id = st.stop_id
3149: AND del.initial_pickup_location_id = st.stop_location_id