APPS.INV_MO_LOVS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 319: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda, mtl_txn_request_lines ml

315: BEGIN
316: --bug 4951734, rewriting query with better performance.
317: /*
318: SELECT wnd.NAME, wnd.delivery_id
319: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda, mtl_txn_request_lines ml
320: WHERE wda.delivery_id = wnd.delivery_id
321: AND wda.delivery_detail_id = wdd.delivery_detail_id
322: AND wdd.move_order_line_id = ml.line_id
323: AND wdd.organization_id = p_organization_id

Line 335: , wsh_delivery_assignments wda

331: SELECT UNIQUE wnd.NAME
332: , wnd.delivery_id
333: FROM wsh_new_deliveries_ob_grp_v wnd
334: , wsh_delivery_details_ob_grp_v wdd
335: , wsh_delivery_assignments wda
336: , mtl_txn_request_lines ml
337: WHERE wda.delivery_id = wnd.delivery_id
338: AND wda.delivery_detail_id = wdd.delivery_detail_id
339: AND wdd.released_status = 'S'

Line 353: , wsh_delivery_assignments wda

349: SELECT UNIQUE wnd.NAME
350: , wnd.delivery_id
351: FROM wsh_new_deliveries_ob_grp_v wnd
352: , wsh_delivery_details_ob_grp_v wdd
353: , wsh_delivery_assignments wda
354: , mtl_txn_request_lines ml
355: , mtl_txn_request_headers mh
356: WHERE wda.delivery_id = wnd.delivery_id
357: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 375: , wsh_delivery_assignments wda

371: SELECT UNIQUE wnd.NAME
372: , wnd.delivery_id
373: FROM wsh_new_deliveries_ob_grp_v wnd
374: , wsh_delivery_details_ob_grp_v wdd
375: , wsh_delivery_assignments wda
376: , mtl_txn_request_lines ml
377: , mtl_txn_request_headers mh
378: , mtl_material_transactions_temp mmtt
379: WHERE wda.delivery_id = wnd.delivery_id