DBA Data[Home] [Help]

APPS.INV_MO_LOVS dependencies on WSH_NEW_DELIVERIES_OB_GRP_V

Line 333: FROM wsh_new_deliveries_ob_grp_v wnd

329: IF (p_so_number IS NULL AND p_mo_req_num IS NULL AND p_pickslip_number IS NULL) THEN
330: OPEN x_delivery FOR
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

Line 351: FROM wsh_new_deliveries_ob_grp_v wnd

347: ELSIF (p_pickslip_number IS NULL) THEN
348: OPEN x_delivery FOR
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

Line 373: FROM wsh_new_deliveries_ob_grp_v wnd

369: ELSE
370: OPEN x_delivery FOR
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