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_DELIVERIES_GRP dependencies on WSH_TRIP_STOPS

Line 95: select distinct trip_id from wsh_trip_stops

91: WHERE Wrsl.Report_Set_Id = Wrs.Report_Set_Id
92: AND Wrs.Name = 'Packing Slip Report';
93:
94: CURSOR c_delv_trip_id_cursor( t_delivery_id NUMBER ) IS
95: select distinct trip_id from wsh_trip_stops
96: where stop_id in
97: ( select distinct pick_up_stop_id
98: from wsh_delivery_legs
99: where delivery_id = t_delivery_id );

Line 132: wsh_trip_stops st,

128: Cursor c_del_assign_to_trip(c_delivery_id number) is
129: SELECT distinct t.trip_id, t.ship_method_code, t.lane_id
130: FROM wsh_new_deliveries dl,
131: wsh_delivery_legs dg,
132: wsh_trip_stops st,
133: wsh_trips t
134: WHERE dl.delivery_id = c_delivery_id AND
135: dl.delivery_id = dg.delivery_id AND
136: (dg.pick_up_stop_id = st.stop_id

Line 144: FROM wsh_trip_stops s1,

140:
141: --Bug 7418439 : The cursor selects the trip_id if the delivery is not the last unconfirmed delivery in the trip.
142: Cursor c_unconfirmed_del_exist(c_delivery_id number) is
143: SELECT s1.trip_id
144: FROM wsh_trip_stops s1,
145: wsh_delivery_legs dl1,
146: wsh_new_deliveries d1,
147: wsh_trip_stops s2,
148: wsh_delivery_legs dl2

Line 147: wsh_trip_stops s2,

143: SELECT s1.trip_id
144: FROM wsh_trip_stops s1,
145: wsh_delivery_legs dl1,
146: wsh_new_deliveries d1,
147: wsh_trip_stops s2,
148: wsh_delivery_legs dl2
149: WHERE d1.delivery_id <> c_delivery_id
150: AND s1.stop_id = dl1.pick_up_stop_id
151: AND d1.delivery_id = dl1.delivery_id

Line 167: wsh_trip_stops wts,

163: CURSOR c_get_delivery_id(p_trip_id IN NUMBER) IS
164: SELECT wdl.delivery_id,
165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
166: FROM wsh_delivery_legs wdl,
167: wsh_trip_stops wts,
168: wsh_new_deliveries wnd,
169: wsh_trips wt
170: WHERE wt.trip_id = p_trip_id
171: AND wts.trip_id = wt.trip_id

Line 253: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

249: --dummy tables for calling validate_constraint_mainper
250: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
251: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
252: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
253: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
254: l_cc_in_ids wsh_util_core.id_tab_type;
255: l_cc_fail_ids wsh_util_core.id_tab_type;
256: --
257:

Line 305: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

301: l_in_param_rec WSH_FTE_INTEGRATION.rate_del_in_param_rec;
302: l_out_param_rec WSH_FTE_INTEGRATION.rate_del_out_param_rec;
303:
304: -- J-Stop Sequence Change-CSUN
305: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
306:
307: -- Bug 3311273
308: l_dleg_found VARCHAR2(1) := 'N';
309: --

Line 1702: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (

1698: -- in context of creating new stops, their status is
1699: -- assumed to be NULL, so we need to pass 'OP'
1700: -- to avoid getting error about invalid stop status.
1701: --
1702: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (
1703: p_stop_id => p_action_prms.pickup_stop_id,
1704: p_stop_sequence_number => p_action_prms.pickup_stop_seq,
1705: p_trip_id => l_trip_id,
1706: p_status_code => NVL(p_action_prms.pickup_stop_status, 'OP'),

Line 1718: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (

1714: p_return_status => l_return_status,
1715: x_num_warnings => l_num_warnings,
1716: x_num_errors => l_num_errors);
1717: --
1718: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (
1719: p_stop_id => p_action_prms.dropoff_stop_id,
1720: p_stop_sequence_number => p_action_prms.dropoff_stop_seq,
1721: p_trip_id => l_trip_id,
1722: p_status_code => NVL(p_action_prms.dropoff_stop_status, 'OP'),

Line 4620: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

4616: --dummy tables for calling validate_constraint_mainper
4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4618: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4619: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4620: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4621: l_cc_in_ids wsh_util_core.id_tab_type;
4622: l_cc_fail_ids wsh_util_core.id_tab_type;
4623: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
4624: l_log_itm_exc VARCHAR2(1);

Line 6767: wsh_trip_stops pu_stop,

6763: pu_stop.status_code pu_status,
6764: dg.drop_off_stop_id,
6765: do_stop.status_code do_status
6766: FROM wsh_delivery_legs dg,
6767: wsh_trip_stops pu_stop,
6768: wsh_trip_stops do_stop
6769: WHERE dg.delivery_id = p_delivery_id
6770: AND pu_stop.stop_id = dg.pick_up_stop_id
6771: AND do_stop.stop_id = dg.drop_off_stop_id;

Line 6768: wsh_trip_stops do_stop

6764: dg.drop_off_stop_id,
6765: do_stop.status_code do_status
6766: FROM wsh_delivery_legs dg,
6767: wsh_trip_stops pu_stop,
6768: wsh_trip_stops do_stop
6769: WHERE dg.delivery_id = p_delivery_id
6770: AND pu_stop.stop_id = dg.pick_up_stop_id
6771: AND do_stop.stop_id = dg.drop_off_stop_id;
6772:

Line 6775: FROM wsh_trip_stops

6771: AND do_stop.stop_id = dg.drop_off_stop_id;
6772:
6773: CURSOR c_stop_info(p_stop_id NUMBER) IS
6774: SELECT stop_sequence_number, trip_id
6775: FROM wsh_trip_stops
6776: WHERE stop_id = p_stop_id;
6777: --
6778: CURSOR c_min_max_seq(p_trip_id NUMBER) IS
6779: SELECT min(stop_sequence_number), max(stop_sequence_number)

Line 6780: FROM wsh_trip_stops

6776: WHERE stop_id = p_stop_id;
6777: --
6778: CURSOR c_min_max_seq(p_trip_id NUMBER) IS
6779: SELECT min(stop_sequence_number), max(stop_sequence_number)
6780: FROM wsh_trip_stops
6781: WHERE trip_id = p_trip_id;
6782:
6783: l_debug_on BOOLEAN;
6784: --

Line 6842: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

6838: IF l_debug_on THEN
6839: wsh_debug_sv.log(l_module_name, 'call lock for stop', l_stop_rows(l_stop_index));
6840: END IF;
6841: -- First lock the stop
6842: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
6843: p_stop_id => l_stop_rows(l_stop_index)
6844: );
6845:
6846: OPEN c_stop_info(l_stop_rows(l_stop_index));