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_NEW_DELIVERIES

Line 286: FROM WSH_NEW_DELIVERIES

282:
283: CURSOR c_current_dels(x_ship_method_code IN VARCHAR2,
284: x_carrier_id IN NUMBER) IS
285: SELECT delivery_id
286: FROM WSH_NEW_DELIVERIES
287: WHERE status_code IN ('OP', 'CO', 'SA', 'SR', 'SC')
288: AND ship_method_code = x_ship_method_code
289: AND carrier_id = x_carrier_id
290: AND mode_of_transport IS NULL

Line 311: FROM WSH_NEW_DELIVERIES

307: FOR UPDATE NOWAIT;
308:
309: CURSOR c_lock_del(x_id IN NUMBER) IS
310: SELECT delivery_id
311: FROM WSH_NEW_DELIVERIES
312: WHERE delivery_id = x_id
313: FOR UPDATE NOWAIT;
314:
315: CURSOR c_lock_detail(x_id IN NUMBER) IS

Line 446: UPDATE WSH_NEW_DELIVERIES

442: AND ship_method_code = p_ship_method_code
443: AND carrier_id = p_carrier_id;
444: ELSIF p_entity = G_ENTITY_DEL THEN
445: FORALL i IN 1 .. l_update_index
446: UPDATE WSH_NEW_DELIVERIES
447: SET service_level = p_service_level,
448: mode_of_transport = p_mode_of_transport,
449: last_updated_by = l_user_id,
450: last_update_date = sysdate,