DBA Data[Home] [Help]

APPS.WSH_SHIPPING_INFO dependencies on WSH_DELIVERY_LEGS

Line 189: AND entity_name = 'WSH_DELIVERY_LEGS'

185: CURSOR get_bill_of_lading(v_delivery_leg_id VARCHAR2) IS
186: SELECT sequence_number bill_of_lading
187: FROM wsh_document_instances
188: WHERE entity_id = v_delivery_leg_id
189: AND entity_name = 'WSH_DELIVERY_LEGS'
190: AND status <> 'CANCELLED' --Bug 8597679 :Added the condition to filter out cancelld BOl
191: AND document_type= 'BOL';
192:
193: CURSOR get_trip_delivery_info (v_delivery_name VARCHAR2) IS

Line 210: wsh_delivery_legs dg,

206: wsh_trips t,
207: wsh_trip_stops ts1,
208: wsh_trip_stops ts2,
209: -- wsh_document_instances di, -- Bug 3146273
210: wsh_delivery_legs dg,
211: wsh_new_deliveries dl,
212: hz_parties hp, hz_party_usg_assignments hpu -- Bug 5697730
213: WHERE dl.name = v_delivery_name
214: AND hp.party_id(+) = t.carrier_id -- Bug 5697730