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_DELIVERY_LEGS

Line 98: from wsh_delivery_legs

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 );
100:
101:
102: CURSOR c_dlvy_leg_cur(p_delivery_id NUMBER) IS

Line 111: FROM wsh_bols_db_v b, wsh_delivery_legs l

107: b.carrier_id,
108: b.trip_id,
109: b.trip_name,
110: l.parent_delivery_leg_id
111: FROM wsh_bols_db_v b, wsh_delivery_legs l
112: WHERE b.delivery_id = p_delivery_id
113: AND l.delivery_leg_id = b.delivery_leg_id;
114:
115: CURSOR c_child_deliveries(p_delivery_id IN NUMBER) IS

Line 117: from wsh_delivery_legs parent,

113: AND l.delivery_leg_id = b.delivery_leg_id;
114:
115: CURSOR c_child_deliveries(p_delivery_id IN NUMBER) IS
116: select child.delivery_id
117: from wsh_delivery_legs parent,
118: wsh_delivery_legs child
119: where parent.delivery_id = p_delivery_id
120: and parent.delivery_leg_id = child.parent_delivery_leg_id;
121:

Line 118: wsh_delivery_legs child

114:
115: CURSOR c_child_deliveries(p_delivery_id IN NUMBER) IS
116: select child.delivery_id
117: from wsh_delivery_legs parent,
118: wsh_delivery_legs child
119: where parent.delivery_id = p_delivery_id
120: and parent.delivery_leg_id = child.parent_delivery_leg_id;
121:
122:

Line 131: wsh_delivery_legs dg,

127:
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

Line 145: wsh_delivery_legs dl1,

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
149: WHERE d1.delivery_id <> c_delivery_id

Line 148: wsh_delivery_legs dl2

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
152: AND d1.status_code = 'OP'

Line 166: FROM wsh_delivery_legs wdl,

162: --selecting deliveries that has 'AR' status on a trip
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

Line 283: l_dleg_prms WSH_DELIVERY_LEGS_GRP.action_parameters_rectype;

279: l_doc_set_id NUMBER;
280: l_doc_delivery_id_tab wsh_util_core.id_tab_type;
281: l_doc_valid_ids_tab wsh_util_core.id_tab_type;
282:
283: l_dleg_prms WSH_DELIVERY_LEGS_GRP.action_parameters_rectype;
284: l_dleg_action_out_rec WSH_DELIVERY_LEGS_GRP.action_out_rec_type;
285: l_dleg_tab WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type;
286:
287: l_action_prms action_parameters_rectype;

Line 284: l_dleg_action_out_rec WSH_DELIVERY_LEGS_GRP.action_out_rec_type;

280: l_doc_delivery_id_tab wsh_util_core.id_tab_type;
281: l_doc_valid_ids_tab wsh_util_core.id_tab_type;
282:
283: l_dleg_prms WSH_DELIVERY_LEGS_GRP.action_parameters_rectype;
284: l_dleg_action_out_rec WSH_DELIVERY_LEGS_GRP.action_out_rec_type;
285: l_dleg_tab WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type;
286:
287: l_action_prms action_parameters_rectype;
288: l_delivery_out_rec Delivery_Action_Out_Rec_Type;

Line 285: l_dleg_tab WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type;

281: l_doc_valid_ids_tab wsh_util_core.id_tab_type;
282:
283: l_dleg_prms WSH_DELIVERY_LEGS_GRP.action_parameters_rectype;
284: l_dleg_action_out_rec WSH_DELIVERY_LEGS_GRP.action_out_rec_type;
285: l_dleg_tab WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type;
286:
287: l_action_prms action_parameters_rectype;
288: l_delivery_out_rec Delivery_Action_Out_Rec_Type;
289: l_defaults_rec default_parameters_rectype;

Line 2886: wsh_delivery_legs_pvt.populate_record(

2882: wsh_debug_sv.log(l_module_name, 'Processing delivery leg', dlvy_leg_rec.delivery_leg_id);
2883: END IF;
2884:
2885: l_dleg_tab.delete;
2886: wsh_delivery_legs_pvt.populate_record(
2887: p_delivery_leg_id => NVL(dlvy_leg_rec.parent_delivery_leg_id, dlvy_leg_rec.delivery_leg_id),
2888: x_delivery_leg_info => l_dleg_tab(1),
2889: x_return_status => l_return_status);
2890:

Line 2920: wsh_delivery_legs_grp.Delivery_Leg_Action(

2916: l_dleg_action_out_rec.x_trip_name := dlvy_leg_rec.trip_name;
2917: l_dleg_action_out_rec.x_delivery_id := l_child_deliveries_tab(child);
2918: l_dleg_action_out_rec.result_id_tab.delete;
2919:
2920: wsh_delivery_legs_grp.Delivery_Leg_Action(
2921: p_api_version_number => 1.0,
2922: p_init_msg_list => FND_API.G_FALSE,
2923: p_commit => FND_API.G_FALSE,
2924: p_rec_attr_tab => l_dleg_tab,

Line 6766: FROM wsh_delivery_legs dg,

6762: SELECT dg.pick_up_stop_id,
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