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.INV_PICK_RELEASE_PVT dependencies on WSH_DELIVERY_LEGS

Line 2148: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts

2144: wdd.released_status,
2145: wdd.delivery_detail_id
2146: INTO l_demand_info
2147: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
2148: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts
2149: WHERE wnd.delivery_id(+) = wda.delivery_id
2150: AND wlg.delivery_id(+) = wnd.delivery_id
2151: AND wts.stop_id(+) = wlg.pick_up_stop_id
2152: AND NVL(wlg.sequence_number,-1) =

Line 2154: FROM wsh_delivery_legs g

2150: AND wlg.delivery_id(+) = wnd.delivery_id
2151: AND wts.stop_id(+) = wlg.pick_up_stop_id
2152: AND NVL(wlg.sequence_number,-1) =
2153: (SELECT NVL(min(g.sequence_number),-1)
2154: FROM wsh_delivery_legs g
2155: WHERE g.delivery_id(+) = wnd.delivery_id )
2156: AND wdd.delivery_detail_id = wda.delivery_detail_id
2157: AND wdd.move_order_line_id = p_mo_line_rec.line_id
2158: AND wdd.move_order_line_Id IS NOT NULL