DBA Data[Home] [Help]

APPS.WSH_SHIPPING_INFO dependencies on WSH_NEW_DELIVERIES

Line 164: wsh_new_deliveries dl,

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
168: AND hp.party_id = hpu.party_id(+) -- Bug 5697730

Line 210: wsh_new_deliveries dl,

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
212: WHERE dl.name = v_delivery_name
213: AND hp.party_id(+) = t.carrier_id -- Bug 5697730
214: AND hp.party_id = hpu.party_id(+) -- Bug 5697730