APPS.INV_LABEL_PVT5 dependencies on WSH_NEW_DELIVERIES

Line 562: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda

558: AND wdd.lpn_id = wlpn.lpn_id;
559:
560: CURSOR c_wnd_lpn IS
561: SELECT DISTINCT wdd2.lpn_id, wdd1.organization_id /*8736862-added distinct*/
562: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda
563: , wsh_delivery_details wdd1, wsh_delivery_details wdd2
564: WHERE wnd.delivery_id = p_transaction_id
565: AND wnd.delivery_id = wda.delivery_id
566: AND wdd1.delivery_detail_id = wda.delivery_detail_id