[Home] [Help]
4768: null,null,null,
4769: da.type,
4770: da.parent_delivery_id,
4771: dl.parent_delivery_leg_id
4772: FROM wsh_delivery_assignments da,
4773: wsh_delivery_legs dl ,
4774: wsh_delivery_details dd,
4775: wsh_trip_stops s
4776: WHERE da.delivery_id=dl.delivery_id and
5271: null,null,null,
5272: da.type,
5273: da.parent_delivery_id,
5274: dl.parent_delivery_leg_id
5275: FROM wsh_delivery_assignments da,
5276: wsh_delivery_legs dl ,
5277: wsh_delivery_details dd
5278: WHERE da.delivery_id=dl.delivery_id and
5279: dl.pick_up_stop_id=c_pick_up_stop_id and
5333: null,null,null,
5334: da.type,
5335: da.parent_delivery_id,
5336: dl.parent_delivery_leg_id
5337: FROM wsh_delivery_assignments da,
5338: wsh_delivery_legs dl ,
5339: wsh_delivery_details dd
5340: WHERE da.delivery_id=dl.delivery_id and
5341: dl.drop_off_stop_id=c_drop_off_stop_id and
6804: null,null,null,
6805: null,--MDC columns
6806: null,--MDC columns
6807: null--MDC columns
6808: FROM wsh_delivery_assignments da,
6809: wsh_delivery_details dd
6810: WHERE da.delivery_id=c_delivery_id and
6811: da.parent_delivery_detail_id is null and
6812: da.delivery_detail_id = dd.delivery_detail_id;
11733: null,null,null,
11734: da.type,
11735: da.parent_delivery_id,
11736: dl.parent_delivery_leg_id
11737: FROM wsh_delivery_assignments da,
11738: wsh_delivery_legs dl ,
11739: wsh_delivery_details dd,
11740: wsh_trip_stops s
11741: WHERE da.delivery_id=dl.delivery_id and