APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_LEGS

Line 563: wsh_delivery_legs_ob_grp_v wdl,

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
567: and pickup_stop.stop_id = wdl.pick_up_stop_id

Line 2311: wsh_delivery_legs dl1,

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
2315: WHERE d1.delivery_id <> l_delivery_id

Line 2314: wsh_delivery_legs dl2

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
2318: AND d1.status_code = 'OP'

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 2399: FROM wsh_delivery_legs

2395: -- Fix for Bug 14696492
2396: -- Check if delivery is assigned to trip which has additional deliveries
2397: BEGIN
2398: SELECT count(*) INTO l_del_leg_count
2399: FROM wsh_delivery_legs
2400: WHERE delivery_id = p_delivery_id;
2401: IF l_del_leg_count > 1 THEN
2402: x_return_Status := 'N';
2403: x_error_code := 8;

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 3144: wsh_delivery_legs dlg,

3140: wt.trip_id
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