APPS.INV_LABEL_PVT8 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 463: wsh_delivery_assignments_v wda,

459: mtl_transaction_lots_temp mtlt1
460: WHERE mmtt1.transaction_temp_id = mtlt1.transaction_temp_id(+)
461: ) mmtt, -- mmtt with lot number information
462: wsh_delivery_details wdd,
463: wsh_delivery_assignments_v wda,
464: mtl_item_locations_kfv milk,
465: mtl_item_locations_kfv milk2,
466: oe_order_lines_all oeol
467: WHERE ((mmtt.transaction_temp_id = p_transaction_temp_id AND

Line 569: , wsh_delivery_assignments_v wda

565: ,wdd_item.intmed_ship_to_contact_id
566:
567: FROM wsh_delivery_details wdd_item -- records with item info
568: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
569: , wsh_delivery_assignments_v wda
570: , oe_order_lines_all oeol
571: , wms_license_plate_numbers wlpn
572: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
573: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id

Line 672: , wsh_delivery_assignments_v wda

668: ,wdd_item.intmed_ship_to_contact_id
669: FROM wsh_delivery_details wdd_item -- records with item info
670: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
671: , wms_license_plate_numbers wlpn
672: , wsh_delivery_assignments_v wda
673: , oe_order_lines_all oeol
674: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
675: AND (wdd_item.inventory_item_id IS NOT NULL AND
676: wdd_item.lpn_id IS NULL)

Line 769: , wsh_delivery_assignments_v wda

765: ,NULL wnd_ship_method_code -- Place holder, get later with c_delivery
766: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
767: ,wdd_item.intmed_ship_to_contact_id
768: FROM wsh_delivery_details wdd_item -- records with item info
769: , wsh_delivery_assignments_v wda
770: , mtl_item_locations_kfv milk
771: , oe_order_lines_all oeol
772: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
773: AND (wdd_item.inventory_item_id IS NOT NULL AND