APPS.WSH_UTIL_CORE dependencies on WSH_DELIVERY_LEGS

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

2846: --
2847: wsh_new_deliveries_pvt.delete_delivery(null, p_rows(i), cur_return_status);
2848: elsif (p_type = 'DLEG') then
2849:
2850: -- wsh_delivery_legs_pvt.delete_delivery_leg(null, p_rows(i), cur_return_status);
2851:
2852: fnd_message.set_name('WSH','DEL_DLEG_NOT_IMPLEMENTED_YET');
2853: cur_return_status := wsh_util_core.g_ret_sts_error;
2854: wsh_util_core.add_message(cur_return_status);

Line 3451: wsh_delivery_legs dg,

3447: st.trip_id,
3448: dl.organization_id,
3449: mp.wms_enabled_flag
3450: FROM wsh_new_deliveries dl,
3451: wsh_delivery_legs dg,
3452: wsh_trip_stops st,
3453: mtl_parameters mp
3454: WHERE dg.delivery_id = dl.delivery_id AND
3455: nvl(dl.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND -- J Inbound Logistics jckwok

Line 3750: FROM WSH_DELIVERY_LEGS DLG,

3746: x_return_status OUT NOCOPY VARCHAR2) IS
3747:
3748: CURSOR c_get_trip_name IS
3749: SELECT TP.Name, DLG.reprice_required
3750: FROM WSH_DELIVERY_LEGS DLG,
3751: WSH_TRIP_STOPS TS,
3752: WSH_TRIPS TP
3753: WHERE DLG.delivery_leg_id = p_delivery_leg_id AND
3754: DLG.pick_up_stop_id = TS.stop_id AND

Line 8162: WSH_DELIVERY_LEGS leg,

8158: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8159: SELECT dlvy.ORGANIZATION_ID
8160: INTO l_organization_id
8161: FROM WSH_TRIP_STOPS stops,
8162: WSH_DELIVERY_LEGS leg,
8163: WSH_NEW_DELIVERIES dlvy
8164: WHERE stops.stop_id = leg.pick_up_stop_id
8165: AND leg.delivery_id = dlvy.delivery_id
8166: AND stops.stop_id = l_first_stop_id

Line 8183: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,

8179: THEN
8180: -- Bug 6633529: Adding Rownum = 1 for Trips having more than 1 delivery for the same organization
8181: SELECT dlvy.ORGANIZATION_ID
8182: INTO l_organization_id
8183: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
8184: WSH_NEW_DELIVERIES dlvy
8185: WHERE stops.stop_id = leg.pick_up_stop_id
8186: AND leg.delivery_id = dlvy.delivery_id
8187: AND stops.stop_id = l_first_stop_id

Line 8257: wsh_delivery_legs wdg

8253: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8254: stops.stop_id,stops.tms_interface_flag
8255: FROM wsh_trip_stops stops,
8256: wsh_trips trips,
8257: wsh_delivery_legs wdg
8258: WHERE trips.trip_id = p_trip_id
8259: and trips.trip_id = stops.trip_id
8260: and wdg.pick_up_stop_id = stops.stop_id
8261: ORDER BY STOP_SEQUENCE_NUMBER;

Line 8270: wsh_delivery_legs wdg

8266: SELECT stop_location_id, planned_arrival_date, planned_departure_date,
8267: stops.stop_id,stops.tms_interface_flag
8268: FROM wsh_trip_stops stops,
8269: wsh_trips trips,
8270: wsh_delivery_legs wdg
8271: WHERE trips.trip_id = p_trip_id
8272: and trips.trip_id = stops.trip_id
8273: and wdg.drop_off_stop_id = stops.stop_id
8274: ORDER BY STOP_SEQUENCE_NUMBER DESC;