APPS.WSH_TMS_RELEASE dependencies on WSH_DELIVERY_LEGS

Line 936: FROM wsh_delivery_legs wdl,

932: -- 3rd select is for deliveries having dropoff as
933: -- dummy stop which is linked to this physical stop
934: CURSOR c_get_deliveries(p_stop_id IN NUMBER) IS
935: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
936: FROM wsh_delivery_legs wdl,
937: wsh_new_deliveries wnd
938: WHERE wdl.pick_up_stop_id = p_stop_id
939: AND wnd.delivery_id = wdl.delivery_id
940: UNION

Line 942: FROM wsh_delivery_legs wdl,

938: WHERE wdl.pick_up_stop_id = p_stop_id
939: AND wnd.delivery_id = wdl.delivery_id
940: UNION
941: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
942: FROM wsh_delivery_legs wdl,
943: wsh_new_deliveries wnd
944: WHERE wdl.drop_off_stop_id = p_stop_id
945: AND wnd.delivery_id = wdl.delivery_id
946: UNION

Line 948: FROM wsh_delivery_legs wdl,

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

Line 959: FROM wsh_delivery_legs

955:
956: -- Find Delivery Legs for the delivery id
957: CURSOR c_get_dleg_id (p_delivery_id IN NUMBER) IS
958: SELECT delivery_leg_id
959: FROM wsh_delivery_legs
960: WHERE delivery_id = p_delivery_id;
961:
962: -- Freight Cost Interface Data
963: CURSOR c_freight_int_cur (p_delivery_id IN NUMBER) IS

Line 1529: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(

1525: -- Need to lock delivery legs even if the delivery was assigned to a different trip
1526: IF l_dleg_local_tab(m).trip_interface_id = l_trip_info_tab(i).trip_interface_id THEN--{
1527: BEGIN
1528: -- lock legs in this delivery
1529: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
1530: p_delivery_id => l_dleg_local_tab(m).delivery_id);
1531:
1532: EXCEPTION
1533: WHEN OTHERS THEN

Line 3572: wsh_delivery_legs wdl,

3568:
3569: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3570: SELECT wnd.delivery_id, wdd.delivery_detail_id
3571: FROM wsh_new_deliveries wnd,
3572: wsh_delivery_legs wdl,
3573: wsh_delivery_assignments wda, wsh_delivery_details wdd
3574: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3575: AND wdl.delivery_id = wnd.delivery_id
3576: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'

Line 4687: FROM wsh_delivery_legs wdl,

4683: wnd.tms_version_number,
4684: wnd.organization_id,
4685: wnd.name,
4686: wnd.status_code
4687: FROM wsh_delivery_legs wdl,
4688: wsh_trip_stops wts,
4689: wsh_new_deliveries wnd
4690: WHERE wdl.pick_up_stop_id = wts.stop_id
4691: AND wts.trip_id = p_trip_id

Line 4701: FROM wsh_delivery_legs wdl,

4697: wnd.tms_version_number,
4698: wnd.organization_id,
4699: wnd.name,
4700: wnd.status_code
4701: FROM wsh_delivery_legs wdl,
4702: wsh_trip_stops wts,
4703: wsh_trips wt,
4704: wsh_new_deliveries wnd
4705: WHERE wdl.pick_up_stop_id = wts.stop_id

Line 4809: FROM wsh_delivery_legs wdl,

4805: wts_pu.stop_sequence_number pickup_stop_sequence,
4806: wts_do.stop_location_id dropoff_stop_location_id,
4807: wts_do.stop_sequence_number dropoff_stop_sequence,
4808: wts_pu.trip_id trip_id
4809: FROM wsh_delivery_legs wdl,
4810: wsh_trip_stops wts_pu,
4811: wsh_trip_stops wts_do
4812: WHERE wdl.delivery_id = p_delivery_id
4813: AND wdl.pick_up_stop_id = wts_pu.stop_id