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 document_type= 'BOL';
191:
192: CURSOR get_trip_delivery_info (v_delivery_name VARCHAR2) IS
193: SELECT wl.meaning status,

Line 209: wsh_delivery_legs dg,

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