To find delivery leg and pickup stop info

SELECT wt.trip_id,

wt.name,

wt.STATUS_CODE,

wt.VEHICLE_ITEM_ID,

wt.VEHICLE_NUMBER,

wt.CARRIER_ID,

wt.SHIP_METHOD_CODE,

wts.STOP_ID,

wts.STOP_LOCATION_ID,

wts.STATUS_CODE,

wts.STOP_SEQUENCE_NUMBER,

wts.PLANNED_ARRIVAL_DATE,

wts.PLANNED_DEPARTURE_DATE,

wts.ACTUAL_ARRIVAL_DATE,

wts.ACTUAL_DEPARTURE_DATE,

wts.DEPARTURE_NET_WEIGHT,

wts.WEIGHT_UOM_CODE,

wdl.DELIVERY_LEG_ID,

wdl.DELIVERY_ID,

wdl.PICK_UP_STOP_ID,

wdl.DROP_OFF_STOP_ID,

wdl.SEQUENCE_NUMBER,

wdl.LOADING_ORDER_FLAG,

wdl.SHIPPER_TITLE,

wdl.SHIPPER_PHONE

FROM wsh_trips wt

,wsh_trip_stops wts

,wsh_delivery_legs wdl

WHERE wdl.delivery_id =12814

AND wts.stop_id = wdl.pick_up_stop_id

AND wts.trip_id = wt.trip_id;