APPS.WSH_UTIL_CORE dependencies on WSH_DELIVERY_LEGS

Line 2814: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);

2810: --
2811: wsh_new_deliveries_pvt.delete_delivery(null, p_rows(i), cur_return_status);
2812: elsif (p_type = 'DLEG') then
2813:
2814: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);
2815:
2816: fnd_message.set_name('WSH','DEL_DLEG_NOT_IMPLEMENTED_YET');
2817: cur_return_status := wsh_util_core.g_ret_sts_error;
2818: wsh_util_core.add_message(cur_return_status);

Line 3415: wsh_delivery_legs dg,

3411: st.trip_id,
3412: dl.organization_id,
3413: mp.wms_enabled_flag
3414: FROM wsh_new_deliveries dl,
3415: wsh_delivery_legs dg,
3416: wsh_trip_stops st,
3417: mtl_parameters mp
3418: WHERE dg.delivery_id = dl.delivery_id AND
3419: nvl(dl.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND -- J Inbound Logistics jckwok

Line 3714: FROM WSH_DELIVERY_LEGS DLG,

3710: x_return_status OUT NOCOPY VARCHAR2) IS
3711:
3712: CURSOR c_get_trip_name IS
3713: SELECT TP.Name, DLG.reprice_required
3714: FROM WSH_DELIVERY_LEGS DLG,
3715: WSH_TRIP_STOPS TS,
3716: WSH_TRIPS TP
3717: WHERE DLG.delivery_leg_id = p_delivery_leg_id AND
3718: DLG.pick_up_stop_id = TS.stop_id AND

Line 8126: WSH_DELIVERY_LEGS leg,

8122: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8123: SELECT dlvy.ORGANIZATION_ID
8124: INTO l_organization_id
8125: FROM WSH_TRIP_STOPS stops,
8126: WSH_DELIVERY_LEGS leg,
8127: WSH_NEW_DELIVERIES dlvy
8128: WHERE stops.stop_id = leg.pick_up_stop_id
8129: AND leg.delivery_id = dlvy.delivery_id
8130: AND stops.stop_id = l_first_stop_id

Line 8147: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,

8143: THEN
8144: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8145: SELECT dlvy.ORGANIZATION_ID
8146: INTO l_organization_id
8147: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
8148: WSH_NEW_DELIVERIES dlvy
8149: WHERE stops.stop_id = leg.pick_up_stop_id
8150: AND leg.delivery_id = dlvy.delivery_id
8151: AND stops.stop_id = l_first_stop_id

Line 8221: wsh_delivery_legs wdg

8217: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8218: stops.stop_id,stops.tms_interface_flag
8219: FROM wsh_trip_stops stops,
8220: wsh_trips trips,
8221: wsh_delivery_legs wdg
8222: WHERE trips.trip_id = p_trip_id
8223: and trips.trip_id = stops.trip_id
8224: and wdg.pick_up_stop_id = stops.stop_id
8225: ORDER BY STOP_SEQUENCE_NUMBER;

Line 8234: wsh_delivery_legs wdg

8230: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8231: stops.stop_id,stops.tms_interface_flag
8232: FROM wsh_trip_stops stops,
8233: wsh_trips trips,
8234: wsh_delivery_legs wdg
8235: WHERE trips.trip_id = p_trip_id
8236: and trips.trip_id = stops.trip_id
8237: and wdg.drop_off_stop_id = stops.stop_id
8238: ORDER BY STOP_SEQUENCE_NUMBER DESC;