APPS.INV_LABEL_PVT8 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 481: wsh_delivery_assignments_v wda,

477: mtl_transaction_lots_temp mtlt1
478: WHERE mmtt1.transaction_temp_id = mtlt1.transaction_temp_id(+)
479: ) mmtt, -- mmtt with lot number information
480: wsh_delivery_details wdd,
481: wsh_delivery_assignments_v wda,
482: mtl_item_locations_kfv milk,
483: mtl_item_locations_kfv milk2,
484: oe_order_lines_all oeol
485: WHERE ((mmtt.transaction_temp_id = p_transaction_temp_id AND

Line 645: , wsh_delivery_assignments_v wda

641: ,wdd_item.intmed_ship_to_contact_id
642: ,wdd_item.delivery_detail_id --Bug9261874
643: FROM wsh_delivery_details wdd_item -- records with item info
644: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
645: , wsh_delivery_assignments_v wda
646: , oe_order_lines_all oeol
647: , wms_license_plate_numbers wlpn
648: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
649: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id

Line 759: , wsh_delivery_assignments_v wda

755: ,wdd_item.delivery_detail_id --Bug9261874
756: FROM wsh_delivery_details wdd_item -- records with item info
757: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
758: , wms_license_plate_numbers wlpn
759: , wsh_delivery_assignments_v wda
760: , oe_order_lines_all oeol
761: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
762: AND (wdd_item.inventory_item_id IS NOT NULL AND
763: wdd_item.lpn_id IS NULL)

Line 866: , wsh_delivery_assignments_v wda

862: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
863: ,wdd_item.intmed_ship_to_contact_id
864: ,wdd_item.delivery_detail_id --Bug9261874
865: FROM wsh_delivery_details wdd_item -- records with item info
866: , wsh_delivery_assignments_v wda
867: , mtl_item_locations_kfv milk
868: , oe_order_lines_all oeol
869: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
870: AND (wdd_item.inventory_item_id IS NOT NULL AND