eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 status <> 'CANCELLED' --Bug 8597679 :Added the condition to filter out cancelld BOl
191: AND document_type= 'BOL';

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

205: FROM wsh_lookups wl,
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

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

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