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.WMS_CONTAINER_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 3451: from wsh_delivery_details wdd, wsh_delivery_assignments wda

3447:
3448: BEGIN
3449:
3450: select nvl(wda.delivery_id,999) into l_delivery_id
3451: from wsh_delivery_details wdd, wsh_delivery_assignments wda
3452: WHERE wda.delivery_detail_id(+) = wdd.delivery_detail_id AND ROWNUM < 2
3453: AND wdd.lpn_id IN
3454: ( select wlpn.lpn_id
3455: from wms_license_plate_numbers wlpn

Line 9397: wsh_delivery_assignments wda

9393:
9394: SELECT wda.delivery_id
9395: INTO l_delivery_id
9396: FROM wsh_delivery_details_ob_grp_v wdd,
9397: wsh_delivery_assignments wda
9398: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
9399: WHERE outermost_lpn_id = (SELECT outermost_lpn_id
9400: FROM wms_license_plate_numbers
9401: WHERE lpn_id = p_lpn_id)