APPS.WSH_SHIPPING_INFO dependencies on WSH_DOCUMENT_INSTANCES

Line 180: -- Bug 3146273 : Removed the wsh_document_instances table from the Cursor

176:
177: -- 1924574 Changes: Removed the joins with hr_locations join and passing ts1,ts2.stop_location_id
178: -- to WSH_UTIL_CORE.get_location_description
179:
180: -- Bug 3146273 : Removed the wsh_document_instances table from the Cursor
181: -- "get_shipped_delivery_info"
182: -- and added new cursor "get_bill_of_lading" to get the sequence_number from the
183: -- wsh_document_instances table
184:

Line 183: -- wsh_document_instances table

179:
180: -- Bug 3146273 : Removed the wsh_document_instances table from the Cursor
181: -- "get_shipped_delivery_info"
182: -- and added new cursor "get_bill_of_lading" to get the sequence_number from the
183: -- wsh_document_instances table
184:
185: CURSOR get_bill_of_lading(v_delivery_leg_id VARCHAR2) IS
186: SELECT sequence_number bill_of_lading
187: FROM wsh_document_instances

Line 187: FROM wsh_document_instances

183: -- wsh_document_instances table
184:
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:

Line 208: -- wsh_document_instances di, -- Bug 3146273

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
212: WHERE dl.name = v_delivery_name

Line 230: l_bill_of_lading wsh_document_instances.sequence_number%TYPE:= null;

226:
227: l_trip_del get_trip_delivery_info%ROWTYPE;
228:
229: l_tmpTrackLine Tracking_Info_Rec_Typ;
230: l_bill_of_lading wsh_document_instances.sequence_number%TYPE:= null;
231:
232: i NUMBER;
233:
234: --