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_UTIL_CORE

Line 19: -- : Using API WSH_UTIL_CORE.get_location_desriptions instead for HR changes

15: -- HISTORY
16: --
17: -- Aug 15, 2001 Raju Varghese Bug#1924574 for hr_locations
18: -- : Removed Calls to hr_locations
19: -- : Using API WSH_UTIL_CORE.get_location_desriptions instead for HR changes
20: -- and performance Reasons.
21: --
22: */
23:

Line 150: -- to WSH_UTIL_CORE.get_location_description

146: p_mode IN VARCHAR2,
147: x_tracking_details OUT NOCOPY Tracking_Info_Tab_Typ
148: ) IS
149: -- 1924574 Changes: Removed the hr_locations join and passing dl.initial_pickup_location_id
150: -- to WSH_UTIL_CORE.get_location_description
151: CURSOR get_delivery_info (v_delivery_name VARCHAR2) IS
152: SELECT wl.meaning status,
153: to_char(NULL) name,
154: WSH_UTIL_CORE.get_location_description(dl.initial_pickup_location_id,'CSZ') pickup_loc,

Line 154: WSH_UTIL_CORE.get_location_description(dl.initial_pickup_location_id,'CSZ') pickup_loc,

150: -- to WSH_UTIL_CORE.get_location_description
151: CURSOR get_delivery_info (v_delivery_name VARCHAR2) IS
152: SELECT wl.meaning status,
153: to_char(NULL) name,
154: WSH_UTIL_CORE.get_location_description(dl.initial_pickup_location_id,'CSZ') pickup_loc,
155: to_date(NULL) pu_arrival_date,
156: to_date(NULL) pu_departure_date,
157: to_char(NULL) dropoff_loc,
158: to_date(NULL) do_arrival_date,

Line 178: -- to WSH_UTIL_CORE.get_location_description

174:
175: l_del get_delivery_info%ROWTYPE;
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

Line 196: WSH_UTIL_CORE.get_location_description(ts1.stop_location_id,'CSZ') pickup_loc,

192:
193: CURSOR get_trip_delivery_info (v_delivery_name VARCHAR2) IS
194: SELECT wl.meaning status,
195: t.name,
196: WSH_UTIL_CORE.get_location_description(ts1.stop_location_id,'CSZ') pickup_loc,
197: ts1.actual_arrival_date pu_arrival_date,
198: ts1.actual_departure_date pu_departure_date,
199: WSH_UTIL_CORE.get_location_description(ts2.stop_location_id,'CSZC') dropoff_loc,
200: ts2.actual_arrival_date do_arrival_date,

Line 199: WSH_UTIL_CORE.get_location_description(ts2.stop_location_id,'CSZC') dropoff_loc,

195: t.name,
196: WSH_UTIL_CORE.get_location_description(ts1.stop_location_id,'CSZ') pickup_loc,
197: ts1.actual_arrival_date pu_arrival_date,
198: ts1.actual_departure_date pu_departure_date,
199: WSH_UTIL_CORE.get_location_description(ts2.stop_location_id,'CSZC') dropoff_loc,
200: ts2.actual_arrival_date do_arrival_date,
201: ts2.actual_departure_date do_departure_date,
202: t.ship_method_code,
203: hp.party_name carrier_name, -- Bug 5697730