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 814: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,

810:
811: --Cursor to get the Trip stop id associated with the PickUp Stop of delivery detail line.
812: CURSOR get_dd_pup_trip_stop(v_org_id IN NUMBER, v_dd_id NUMBER) IS
813: SELECT wts.STOP_ID
814: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,
815: wsh_delivery_legs wdl, wsh_delivery_details wdd
816: WHERE wdd.delivery_detail_id = v_dd_id
817: AND wdd.organization_id = v_org_id
818: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1803: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

1799: --dummy tables for calling validate_constraint_main
1800: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1801: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1802: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1803: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1804: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1805: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1806: -- deliveryMerge
1807: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

Line 3552: WSH_TRIP_STOPS WTS

3548: ) IS
3549: SELECT DISTINCT WND.ORGANIZATION_ID
3550: FROM WSH_NEW_DELIVERIES WND,
3551: WSH_DELIVERY_LEGS WLG,
3552: WSH_TRIP_STOPS WTS
3553: WHERE WTS.TRIP_ID = v_trip_id
3554: AND WTS.STOP_ID = WLG.PICK_UP_STOP_ID
3555: AND WLG.DELIVERY_ID = WND.DELIVERY_ID
3556: AND nvl(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics

Line 3573: WSH_TRIP_STOPS WTS

3569: UNION ALL
3570: SELECT DISTINCT WND.ORGANIZATION_ID
3571: FROM WSH_NEW_DELIVERIES WND,
3572: WSH_DELIVERY_LEGS WLG,
3573: WSH_TRIP_STOPS WTS
3574: WHERE WTS.STOP_ID = WLG.PICK_UP_STOP_ID
3575: AND WLG.DELIVERY_ID = WND.DELIVERY_ID
3576: AND WTS.STOP_ID = v_trip_stop_id
3577: AND nvl(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics

Line 3719: wsh_trip_stops wst,

3715: SELECT DISTINCT wtp.trip_id, wst.stop_sequence_number,
3716: wst.stop_id, wst.stop_location_id
3717: FROM wsh_new_deliveries wnd,
3718: wsh_delivery_legs wlg,
3719: wsh_trip_stops wst,
3720: wsh_trips wtp
3721: WHERE wnd.delivery_id = wlg.delivery_id AND
3722: wlg.pick_up_stop_id = wst.stop_id AND
3723: wnd.status_code = 'CO' AND

Line 3741: wsh_trip_stops wst,

3737: SELECT wtp.trip_id, wst.stop_sequence_number, wst.stop_id ,
3738: wst.stop_location_id
3739: FROM wsh_new_deliveries wnd,
3740: wsh_delivery_legs wlg,
3741: wsh_trip_stops wst,
3742: wsh_trips wtp
3743: WHERE wnd.delivery_id = wlg.delivery_id and
3744: wlg.pick_up_stop_id = wst.stop_id and
3745: wnd.status_code = 'CO' and

Line 3760: wsh_trip_stops wst2,

3756: SELECT wtp2.trip_id, wst2.stop_sequence_number,
3757: wst2.stop_id, wst2.stop_location_id
3758: FROM wsh_new_deliveries wnd2,
3759: wsh_delivery_legs wlg2,
3760: wsh_trip_stops wst2,
3761: wsh_trips wtp2
3762: WHERE wnd2.delivery_id = wlg2.delivery_id and
3763: wlg2.drop_off_stop_id = wst2.stop_id and
3764: wnd2.status_code = 'CO' and

Line 3779: FROM wsh_trip_stops wts,

3775:
3776:
3777: CURSOR c_batch_stop(l_batch_id NUMBER) IS
3778: SELECT wts.stop_id
3779: FROM wsh_trip_stops wts,
3780: wsh_delivery_legs wdl,
3781: wsh_new_deliveries wnd,
3782: wsh_picking_batches wpb
3783: WHERE p_batch_id IS NOT NULL

Line 6984: select status_code from wsh_trip_stops

6980: where trip_id = c_trip_id;
6981:
6982: --Cursor to get stop status.
6983: CURSOR check_stop(c_stop_id IN NUMBER) IS
6984: select status_code from wsh_trip_stops
6985: where stop_id = c_stop_id;
6986:
6987: --Cursor to get delivery attributes.
6988: CURSOR check_delivery(c_delivery_id IN NUMBER) IS

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

7248: ELSIF (p_stop_ids.COUNT > 0) THEN
7249: l_index := p_stop_ids.FIRST;
7250: l_stop_id := p_stop_ids(l_index);
7251: --
7252: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);
7253: l_type := 'Stop';
7254: ELSIF (p_delivery_ids.COUNT > 0) THEN
7255: l_index := p_delivery_ids.FIRST;
7256: l_delivery_id := p_delivery_ids(l_index);

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

7733: l_index := p_stop_ids.NEXT(l_index);
7734: l_stop_id := p_stop_ids(l_index);
7735: --
7736: IF l_debug_on THEN
7737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7738: END IF;
7739: --
7740: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);
7741: ELSIF l_delivery_id IS NOT NULL THEN

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

7736: IF l_debug_on THEN
7737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7738: END IF;
7739: --
7740: l_name := WSH_TRIP_STOPS_PVT.Get_Name(l_stop_id);
7741: ELSIF l_delivery_id IS NOT NULL THEN
7742: EXIT WHEN l_index = p_delivery_ids.LAST;
7743: l_index := p_delivery_ids.NEXT(l_index);
7744: l_delivery_id := p_delivery_ids(l_index);