eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PICK_LIST dependencies on WSH_TRIP_STOPS

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 1864: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

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
1868: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

Line 3636: WSH_TRIP_STOPS WTS

3632: ) IS
3633: SELECT DISTINCT WND.ORGANIZATION_ID
3634: FROM WSH_NEW_DELIVERIES WND,
3635: WSH_DELIVERY_LEGS WLG,
3636: WSH_TRIP_STOPS WTS
3637: WHERE WTS.TRIP_ID = v_trip_id
3638: AND WTS.STOP_ID = WLG.PICK_UP_STOP_ID
3639: AND WLG.DELIVERY_ID = WND.DELIVERY_ID
3640: AND nvl(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics

Line 3658: WSH_TRIP_STOPS WTS

3654: UNION ALL
3655: SELECT DISTINCT WND.ORGANIZATION_ID
3656: FROM WSH_NEW_DELIVERIES WND,
3657: WSH_DELIVERY_LEGS WLG,
3658: WSH_TRIP_STOPS WTS
3659: WHERE WTS.STOP_ID = WLG.PICK_UP_STOP_ID
3660: AND WLG.DELIVERY_ID = WND.DELIVERY_ID
3661: AND WTS.STOP_ID = v_trip_stop_id
3662: AND nvl(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics

Line 3807: wsh_trip_stops wst,

3803: SELECT DISTINCT wtp.trip_id, wst.stop_sequence_number,
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

Line 3829: wsh_trip_stops wst,

3825: SELECT wtp.trip_id, wst.stop_sequence_number, wst.stop_id ,
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

Line 3848: wsh_trip_stops wst2,

3844: SELECT wtp2.trip_id, wst2.stop_sequence_number,
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

Line 3867: FROM wsh_trip_stops wts,

3863:
3864:
3865: CURSOR c_batch_stop(l_batch_id NUMBER) IS
3866: SELECT wts.stop_id
3867: FROM wsh_trip_stops wts,
3868: wsh_delivery_legs wdl,
3869: wsh_new_deliveries wnd,
3870: wsh_picking_batches wpb
3871: WHERE p_batch_id IS NOT NULL

Line 7126: select status_code from wsh_trip_stops

7122: where trip_id = c_trip_id;
7123:
7124: --Cursor to get stop status.
7125: CURSOR check_stop(c_stop_id IN NUMBER) IS
7126: select status_code from wsh_trip_stops
7127: where stop_id = c_stop_id;
7128:
7129: --Cursor to get delivery attributes.
7130: CURSOR check_delivery(c_delivery_id IN NUMBER) IS

Line 7395: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_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: --
7395: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);
7396: l_type := 'Stop';
7397: ELSIF (p_delivery_ids.COUNT > 0) THEN
7398: l_index := p_delivery_ids.FIRST;
7399: l_delivery_id := p_delivery_ids(l_index);

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

7879: l_index := p_stop_ids.NEXT(l_index);
7880: l_stop_id := p_stop_ids(l_index);
7881: --
7882: IF l_debug_on THEN
7883: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7884: END IF;
7885: --
7886: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);
7887: ELSIF l_delivery_id IS NOT NULL THEN

Line 7886: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);

7882: IF l_debug_on THEN
7883: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7884: END IF;
7885: --
7886: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);
7887: ELSIF l_delivery_id IS NOT NULL THEN
7888: EXIT WHEN l_index = p_delivery_ids.LAST;
7889: l_index := p_delivery_ids.NEXT(l_index);
7890: l_delivery_id := p_delivery_ids(l_index);