APPS.INV_RCV_STD_RCPT_APIS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 8762: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda

8758: -- bug 3209246
8759: CURSOR c_delivery_details(v_order_header_id NUMBER, v_order_line_id NUMBER) IS
8760: SELECT wdd1.lpn_id
8761: , wdd1.organization_id
8762: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
8763: , wsh_delivery_details_ob_grp_v wdd1
8764: WHERE wdd.source_header_id = v_order_header_id
8765: AND wdd.source_line_id = v_order_line_id
8766: AND wdd.delivery_detail_id = wda.delivery_detail_id