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 147: wsh_trip_stops wts,

143: CURSOR c_get_delivery_id(p_trip_id IN NUMBER) IS
144: SELECT wdl.delivery_id,
145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
146: FROM wsh_delivery_legs wdl,
147: wsh_trip_stops wts,
148: wsh_new_deliveries wnd,
149: wsh_trips wt
150: WHERE wt.trip_id = p_trip_id
151: AND wts.trip_id = wt.trip_id

Line 223: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

219: --dummy tables for calling validate_constraint_mainper
220: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
221: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
222: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
223: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
224: l_cc_in_ids wsh_util_core.id_tab_type;
225: l_cc_fail_ids wsh_util_core.id_tab_type;
226: --
227:

Line 275: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

271: l_in_param_rec WSH_FTE_INTEGRATION.rate_del_in_param_rec;
272: l_out_param_rec WSH_FTE_INTEGRATION.rate_del_out_param_rec;
273:
274: -- J-Stop Sequence Change-CSUN
275: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
276:
277: -- Bug 3311273
278: l_dleg_found VARCHAR2(1) := 'N';
279: --

Line 1647: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (

1643: -- in context of creating new stops, their status is
1644: -- assumed to be NULL, so we need to pass 'OP'
1645: -- to avoid getting error about invalid stop status.
1646: --
1647: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (
1648: p_stop_id => p_action_prms.pickup_stop_id,
1649: p_stop_sequence_number => p_action_prms.pickup_stop_seq,
1650: p_trip_id => l_trip_id,
1651: p_status_code => NVL(p_action_prms.pickup_stop_status, 'OP'),

Line 1663: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (

1659: p_return_status => l_return_status,
1660: x_num_warnings => l_num_warnings,
1661: x_num_errors => l_num_errors);
1662: --
1663: WSH_TRIP_STOPS_VALIDATIONS.Validate_Sequence_Number (
1664: p_stop_id => p_action_prms.dropoff_stop_id,
1665: p_stop_sequence_number => p_action_prms.dropoff_stop_seq,
1666: p_trip_id => l_trip_id,
1667: p_status_code => NVL(p_action_prms.dropoff_stop_status, 'OP'),

Line 4447: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

4443: --dummy tables for calling validate_constraint_mainper
4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4445: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4446: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4447: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4448: l_cc_in_ids wsh_util_core.id_tab_type;
4449: l_cc_fail_ids wsh_util_core.id_tab_type;
4450: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
4451: l_log_itm_exc VARCHAR2(1);

Line 6587: wsh_trip_stops pu_stop,

6583: pu_stop.status_code pu_status,
6584: dg.drop_off_stop_id,
6585: do_stop.status_code do_status
6586: FROM wsh_delivery_legs dg,
6587: wsh_trip_stops pu_stop,
6588: wsh_trip_stops do_stop
6589: WHERE dg.delivery_id = p_delivery_id
6590: AND pu_stop.stop_id = dg.pick_up_stop_id
6591: AND do_stop.stop_id = dg.drop_off_stop_id;

Line 6588: wsh_trip_stops do_stop

6584: dg.drop_off_stop_id,
6585: do_stop.status_code do_status
6586: FROM wsh_delivery_legs dg,
6587: wsh_trip_stops pu_stop,
6588: wsh_trip_stops do_stop
6589: WHERE dg.delivery_id = p_delivery_id
6590: AND pu_stop.stop_id = dg.pick_up_stop_id
6591: AND do_stop.stop_id = dg.drop_off_stop_id;
6592:

Line 6595: FROM wsh_trip_stops

6591: AND do_stop.stop_id = dg.drop_off_stop_id;
6592:
6593: CURSOR c_stop_info(p_stop_id NUMBER) IS
6594: SELECT stop_sequence_number, trip_id
6595: FROM wsh_trip_stops
6596: WHERE stop_id = p_stop_id;
6597: --
6598: CURSOR c_min_max_seq(p_trip_id NUMBER) IS
6599: SELECT min(stop_sequence_number), max(stop_sequence_number)

Line 6600: FROM wsh_trip_stops

6596: WHERE stop_id = p_stop_id;
6597: --
6598: CURSOR c_min_max_seq(p_trip_id NUMBER) IS
6599: SELECT min(stop_sequence_number), max(stop_sequence_number)
6600: FROM wsh_trip_stops
6601: WHERE trip_id = p_trip_id;
6602:
6603: l_debug_on BOOLEAN;
6604: --

Line 6662: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

6658: IF l_debug_on THEN
6659: wsh_debug_sv.log(l_module_name, 'call lock for stop', l_stop_rows(l_stop_index));
6660: END IF;
6661: -- First lock the stop
6662: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
6663: p_stop_id => l_stop_rows(l_stop_index)
6664: );
6665:
6666: OPEN c_stop_info(l_stop_rows(l_stop_index));