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 296: FROM WSH_DELIVERY_DETAILS

292:
293: CURSOR c_current_details(x_ship_method_code IN VARCHAR2,
294: x_carrier_id IN NUMBER) IS
295: SELECT delivery_detail_id
296: FROM WSH_DELIVERY_DETAILS
297: WHERE released_status IN ('N', 'R', 'B', 'X', 'S', 'Y')
298: AND ship_method_code = x_ship_method_code
299: AND carrier_id = x_carrier_id
300: AND mode_of_transport IS NULL

Line 317: FROM WSH_DELIVERY_DETAILS

313: FOR UPDATE NOWAIT;
314:
315: CURSOR c_lock_detail(x_id IN NUMBER) IS
316: SELECT delivery_detail_id
317: FROM WSH_DELIVERY_DETAILS
318: WHERE delivery_detail_id = x_id
319: FOR UPDATE NOWAIT;
320:
321: l_debug_on BOOLEAN;

Line 457: UPDATE WSH_DELIVERY_DETAILS

453: AND ship_method_code = p_ship_method_code
454: AND carrier_id = p_carrier_id;
455: ELSE
456: FORALL i IN 1 .. l_update_index
457: UPDATE WSH_DELIVERY_DETAILS
458: SET service_level = p_service_level,
459: mode_of_transport = p_mode_of_transport,
460: last_updated_by = l_user_id,
461: last_update_date = sysdate,