APPS.WSH_TMS_RELEASE dependencies on WSH_DELIVERY_LEGS

Line 943: FROM wsh_delivery_legs wdl,

939: -- 3rd select is for deliveries having dropoff as
940: -- dummy stop which is linked to this physical stop
941: CURSOR c_get_deliveries(p_stop_id IN NUMBER) IS
942: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
943: FROM wsh_delivery_legs wdl,
944: wsh_new_deliveries wnd
945: WHERE wdl.pick_up_stop_id = p_stop_id
946: AND wnd.delivery_id = wdl.delivery_id
947: UNION

Line 949: FROM wsh_delivery_legs wdl,

945: WHERE wdl.pick_up_stop_id = p_stop_id
946: AND wnd.delivery_id = wdl.delivery_id
947: UNION
948: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
949: FROM wsh_delivery_legs wdl,
950: wsh_new_deliveries wnd
951: WHERE wdl.drop_off_stop_id = p_stop_id
952: AND wnd.delivery_id = wdl.delivery_id
953: UNION

Line 955: FROM wsh_delivery_legs wdl,

951: WHERE wdl.drop_off_stop_id = p_stop_id
952: AND wnd.delivery_id = wdl.delivery_id
953: UNION
954: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
955: FROM wsh_delivery_legs wdl,
956: wsh_new_deliveries wnd,
957: wsh_trip_stops wts
958: WHERE wdl.drop_off_stop_id = wts.stop_id
959: AND wnd.delivery_id = wdl.delivery_id

Line 966: FROM wsh_delivery_legs

962:
963: -- Find Delivery Legs for the delivery id
964: CURSOR c_get_dleg_id (p_delivery_id IN NUMBER) IS
965: SELECT delivery_leg_id
966: FROM wsh_delivery_legs
967: WHERE delivery_id = p_delivery_id;
968:
969: -- Freight Cost Interface Data
970: CURSOR c_freight_int_cur (p_delivery_id IN NUMBER) IS

Line 1537: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(

1533: -- Need to lock delivery legs even if the delivery was assigned to a different trip
1534: IF l_dleg_local_tab(m).trip_interface_id = l_trip_info_tab(i).trip_interface_id THEN--{
1535: BEGIN
1536: -- lock legs in this delivery
1537: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
1538: p_delivery_id => l_dleg_local_tab(m).delivery_id);
1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN

Line 3580: wsh_delivery_legs wdl,

3576:
3577: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3578: SELECT wnd.delivery_id, wdd.delivery_detail_id
3579: FROM wsh_new_deliveries wnd,
3580: wsh_delivery_legs wdl,
3581: wsh_delivery_assignments wda, wsh_delivery_details wdd
3582: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3583: AND wdl.delivery_id = wnd.delivery_id
3584: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'

Line 4695: FROM wsh_delivery_legs wdl,

4691: wnd.tms_version_number,
4692: wnd.organization_id,
4693: wnd.name,
4694: wnd.status_code
4695: FROM wsh_delivery_legs wdl,
4696: wsh_trip_stops wts,
4697: wsh_new_deliveries wnd
4698: WHERE wdl.pick_up_stop_id = wts.stop_id
4699: AND wts.trip_id = p_trip_id

Line 4709: FROM wsh_delivery_legs wdl,

4705: wnd.tms_version_number,
4706: wnd.organization_id,
4707: wnd.name,
4708: wnd.status_code
4709: FROM wsh_delivery_legs wdl,
4710: wsh_trip_stops wts,
4711: wsh_trips wt,
4712: wsh_new_deliveries wnd
4713: WHERE wdl.pick_up_stop_id = wts.stop_id

Line 4817: FROM wsh_delivery_legs wdl,

4813: wts_pu.stop_sequence_number pickup_stop_sequence,
4814: wts_do.stop_location_id dropoff_stop_location_id,
4815: wts_do.stop_sequence_number dropoff_stop_sequence,
4816: wts_pu.trip_id trip_id
4817: FROM wsh_delivery_legs wdl,
4818: wsh_trip_stops wts_pu,
4819: wsh_trip_stops wts_do
4820: WHERE wdl.delivery_id = p_delivery_id
4821: AND wdl.pick_up_stop_id = wts_pu.stop_id