APPS.INV_RCV_STD_RCPT_APIS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 9158: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda

9154: -- bug 3209246
9155: CURSOR c_delivery_details(v_order_header_id NUMBER, v_order_line_id NUMBER) IS
9156: SELECT wdd1.lpn_id
9157: , wdd1.organization_id
9158: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
9159: , wsh_delivery_details_ob_grp_v wdd1
9160: WHERE wdd.source_header_id = v_order_header_id
9161: AND wdd.source_line_id = v_order_line_id
9162: AND wdd.delivery_detail_id = wda.delivery_detail_id