DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 580: , wsh_delivery_assignments_v wda

576: /*CURSOR c_wdd_lpn IS
577: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
578: , wdd1.subinventory
579: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
580: , wsh_delivery_assignments_v wda
581: WHERE wdd2.delivery_detail_id = p_transaction_id
582: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
583: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
584: */

Line 605: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda,

601:
602:
603: CURSOR c_wnd_lpn IS
604: SELECT DISTINCT wdd2.lpn_id
605: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda,
606: wsh_delivery_details wdd1, wsh_delivery_details wdd2
607: WHERE wnd.delivery_id = p_transaction_id
608: AND wnd.delivery_id = wda.delivery_id
609: AND wdd1.delivery_detail_id = wda.delivery_detail_id