DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 536: , wsh_delivery_assignments_v wda

532: /*CURSOR c_wdd_lpn IS
533: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
534: , wdd1.subinventory
535: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
536: , wsh_delivery_assignments_v wda
537: WHERE wdd2.delivery_detail_id = p_transaction_id
538: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
539: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
540: */

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