DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on WSH_NEW_DELIVERIES

Line 549: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda

545: AND wdd.lpn_id = wlpn.lpn_id;
546:
547: CURSOR c_wnd_lpn IS
548: SELECT wdd2.lpn_id, wdd1.organization_id
549: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda
550: , wsh_delivery_details wdd1, wsh_delivery_details wdd2
551: WHERE wnd.delivery_id = p_transaction_id
552: AND wnd.delivery_id = wda.delivery_id
553: AND wdd1.delivery_detail_id = wda.delivery_detail_id