DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 527: , wsh_delivery_assignments_v wda

523: /*CURSOR c_wdd_lpn IS
524: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
525: , wdd1.subinventory
526: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
527: , wsh_delivery_assignments_v wda
528: WHERE wdd2.delivery_detail_id = p_transaction_id
529: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
530: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
531: */

Line 552: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda,

548:
549:
550: CURSOR c_wnd_lpn IS
551: SELECT DISTINCT wdd2.lpn_id
552: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda,
553: wsh_delivery_details wdd1, wsh_delivery_details wdd2
554: WHERE wnd.delivery_id = p_transaction_id
555: AND wnd.delivery_id = wda.delivery_id
556: AND wdd1.delivery_detail_id = wda.delivery_detail_id