202: hp.party_name carrier_name, -- Bug 5697730
203: dg.delivery_leg_id
204: FROM wsh_lookups wl,
205: wsh_trips t,
206: wsh_trip_stops ts1,
207: wsh_trip_stops ts2,
208: -- wsh_document_instances di, -- Bug 3146273
209: wsh_delivery_legs dg,
210: wsh_new_deliveries dl,
203: dg.delivery_leg_id
204: FROM wsh_lookups wl,
205: wsh_trips t,
206: wsh_trip_stops ts1,
207: wsh_trip_stops ts2,
208: -- wsh_document_instances di, -- Bug 3146273
209: wsh_delivery_legs dg,
210: wsh_new_deliveries dl,
211: hz_parties hp, hz_party_usg_assignments hpu -- Bug 5697730