[Home] [Help]
1529: CURSOR get_delivery_info(p_del_id_c1 NUMBER) IS
1530: SELECT t.trip_id
1531: FROM wsh_new_deliveries dl,
1532: wsh_delivery_legs dg,
1533: wsh_trip_stops st,
1534: wsh_trips t
1535: WHERE dl.delivery_id = p_del_id_c1 AND
1536: dl.delivery_id = dg.delivery_id AND
1537: dg.drop_off_stop_id = st.stop_id AND
4674: select wda.delivery_id,
4675: wt.trip_id
4676: FROM wsh_delivery_assignments_v wda,
4677: wsh_delivery_legs wdl,
4678: wsh_trip_stops wts,
4679: wsh_trips wt
4680: WHERE wda.delivery_detail_id = p_del_detail_id
4681: AND wda.delivery_id = wdl.delivery_id
4682: AND wdl.pick_up_stop_id = wts.stop_id
4687: is
4688: select wt.trip_id
4689: FROM wsh_delivery_assignments_v wda,
4690: wsh_delivery_legs wdl,
4691: wsh_trip_stops wts,
4692: wsh_trips wt
4693: WHERE wda.delivery_id = p_delivery_id
4694: AND wda.delivery_id = wdl.delivery_id
4695: AND wdl.pick_up_stop_id = wts.stop_id
5210: IS
5211: SELECT
5212: stop_id
5213: FROM
5214: WSH_TRIP_STOPS WTS
5215: WHERE WTS.trip_id = l_cur_trip_id;
5216:
5217: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
5218:
7390: CURSOR get_delivery_info(p_delivery_id NUMBER) IS
7391: SELECT dg.delivery_leg_id
7392: FROM wsh_new_deliveries dl,
7393: wsh_delivery_legs dg,
7394: wsh_trip_stops st,
7395: wsh_trips t
7396: WHERE dl.delivery_id = p_delivery_id AND
7397: dl.delivery_id = dg.delivery_id AND
7398: dg.pick_up_stop_id = st.stop_id AND
7402: CURSOR c_get_last_leg(p_delivery_id NUMBER) IS
7403: SELECT wdl.delivery_leg_id
7404: FROM wsh_new_deliveries wnd,
7405: wsh_delivery_legs wdl,
7406: wsh_trip_stops wts,
7407: wsh_trips wt
7408: WHERE wnd.delivery_id = p_delivery_id AND
7409: wnd.delivery_id = wdl.delivery_id AND
7410: wdl.drop_off_stop_id = wts.stop_id AND
7774: dl.organization_id,
7775: t.name
7776: FROM wsh_new_deliveries dl,
7777: wsh_delivery_legs dg,
7778: wsh_trip_stops st,
7779: wsh_trips t
7780: WHERE dl.delivery_id = p_delivery_id AND
7781: dl.delivery_id = dg.delivery_id AND
7782: dg.drop_off_stop_id = st.stop_id AND