DBA Data[Home] [Help]

APPS.WSH_SHIPPING_INFO dependencies on WSH_LOOKUPS

Line 163: FROM wsh_lookups wl,

159: to_date(NULL) do_departure_date,
160: dl.ship_method_code,
161: hp.party_name carrier_name, -- Bug 5697730
162: to_char(NULL) bill_of_lading
163: FROM wsh_lookups wl,
164: wsh_new_deliveries dl,
165: hz_parties hp, hz_party_usg_assignments hpu
166: WHERE dl.name = v_delivery_name
167: AND hp.party_id(+) = dl.carrier_id -- Bug 5697730

Line 204: FROM wsh_lookups wl,

200: ts2.actual_departure_date do_departure_date,
201: t.ship_method_code,
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