APPS.WSH_PICK_LIST dependencies on WSH_TRIPS

Line 829: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,

825:
826: --Cursor to get the Trip stop id associated with the PickUp Stop of delivery detail line.
827: CURSOR get_dd_pup_trip_stop(v_org_id IN NUMBER, v_dd_id NUMBER) IS
828: SELECT wts.STOP_ID
829: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,
830: wsh_delivery_legs wdl, wsh_delivery_details wdd
831: WHERE wdd.delivery_detail_id = v_dd_id
832: AND wdd.organization_id = v_org_id
833: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1863: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1859: l_cc_count_grouping_rows NUMBER;
1860: --dummy tables for calling validate_constraint_main
1861: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1862: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1863: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1864: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1865: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1866: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1867: -- deliveryMerge

Line 3808: wsh_trips wtp

3804: wst.stop_id, wst.stop_location_id
3805: FROM wsh_new_deliveries wnd,
3806: wsh_delivery_legs wlg,
3807: wsh_trip_stops wst,
3808: wsh_trips wtp
3809: WHERE wnd.delivery_id = wlg.delivery_id AND
3810: wlg.pick_up_stop_id = wst.stop_id AND
3811: wnd.status_code = 'CO' AND
3812: wnd.batch_id = c_sc_batch_id AND

Line 3830: wsh_trips wtp

3826: wst.stop_location_id
3827: FROM wsh_new_deliveries wnd,
3828: wsh_delivery_legs wlg,
3829: wsh_trip_stops wst,
3830: wsh_trips wtp
3831: WHERE wnd.delivery_id = wlg.delivery_id and
3832: wlg.pick_up_stop_id = wst.stop_id and
3833: wnd.status_code = 'CO' and
3834: wnd.batch_id = c_sc_batch_id and

Line 3849: wsh_trips wtp2

3845: wst2.stop_id, wst2.stop_location_id
3846: FROM wsh_new_deliveries wnd2,
3847: wsh_delivery_legs wlg2,
3848: wsh_trip_stops wst2,
3849: wsh_trips wtp2
3850: WHERE wnd2.delivery_id = wlg2.delivery_id and
3851: wlg2.drop_off_stop_id = wst2.stop_id and
3852: wnd2.status_code = 'CO' and
3853: wnd2.batch_id = c_sc_batch_id and

Line 7121: select status_code from wsh_trips

7117: WHERE delivery_detail_id = l_del_detail_id;
7118:
7119: --Cursor to get trip status.
7120: CURSOR check_trip(c_trip_id IN NUMBER) IS
7121: select status_code from wsh_trips
7122: where trip_id = c_trip_id;
7123:
7124: --Cursor to get stop status.
7125: CURSOR check_stop(c_stop_id IN NUMBER) IS

Line 7390: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);

7386: l_index := p_trip_ids.FIRST;
7387: l_trip_id := p_trip_ids(l_index);
7388: l_type := 'Trip';
7389: --
7390: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7391: ELSIF (p_stop_ids.COUNT > 0) THEN
7392: l_index := p_stop_ids.FIRST;
7393: l_stop_id := p_stop_ids(l_index);
7394: --

Line 7873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

7869: l_index := p_trip_ids.NEXT(l_index);
7870: l_trip_id := p_trip_ids(l_index);
7871: --
7872: IF l_debug_on THEN
7873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7874: END IF;
7875: --
7876: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7877: ELSIF l_stop_id IS NOT NULL THEN

Line 7876: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);

7872: IF l_debug_on THEN
7873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7874: END IF;
7875: --
7876: l_name := WSH_TRIPS_PVT.Get_Name(l_trip_id);
7877: ELSIF l_stop_id IS NOT NULL THEN
7878: EXIT WHEN l_index = p_stop_ids.LAST;
7879: l_index := p_stop_ids.NEXT(l_index);
7880: l_stop_id := p_stop_ids(l_index);