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.

[Home] [Help]

APPS.WMS_SHIPPING_PUB dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 45: FROM wsh_delivery_assignments_v wda ,

41: /*13442511 modified cursor to fetch all details at once*/
42: CURSOR get_delivery_detail_id (l_delivery_id NUMBER)
43: IS
44: SELECT wlpn.outermost_lpn_id,wlpn.organization_id,wda.delivery_detail_id
45: FROM wsh_delivery_assignments_v wda ,
46: wsh_delivery_details lpn_wdd ,
47: wms_license_plate_numbers wlpn
48: WHERE wda.delivery_id = l_delivery_id
49: AND wda.parent_delivery_detail_id=lpn_wdd.delivery_detail_id