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_CONC_UTIL_PKG dependencies on WSH_DELIVERY_DETAILS

Line 308: FROM WSH_DELIVERY_DETAILS

304:
305: CURSOR c_current_details(x_ship_method_code IN VARCHAR2,
306: x_carrier_id IN NUMBER) IS
307: SELECT delivery_detail_id
308: FROM WSH_DELIVERY_DETAILS
309: WHERE released_status IN ('N', 'R', 'B', 'X', 'S', 'Y')
310: AND ship_method_code = x_ship_method_code
311: AND carrier_id = x_carrier_id
312: AND mode_of_transport IS NULL

Line 329: FROM WSH_DELIVERY_DETAILS

325: FOR UPDATE NOWAIT;
326:
327: CURSOR c_lock_detail(x_id IN NUMBER) IS
328: SELECT delivery_detail_id
329: FROM WSH_DELIVERY_DETAILS
330: WHERE delivery_detail_id = x_id
331: FOR UPDATE NOWAIT;
332:
333: l_debug_on BOOLEAN;

Line 469: UPDATE WSH_DELIVERY_DETAILS

465: AND ship_method_code = p_ship_method_code
466: AND carrier_id = p_carrier_id;
467: ELSE
468: FORALL i IN 1 .. l_update_index
469: UPDATE WSH_DELIVERY_DETAILS
470: SET service_level = p_service_level,
471: mode_of_transport = p_mode_of_transport,
472: last_updated_by = l_user_id,
473: last_update_date = sysdate,