APPS.INV_LABEL_PVT8 dependencies on MTL_ITEM_LOCATIONS_KFV

Line 482: mtl_item_locations_kfv milk,

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
486: p_transaction_temp_id IS NOT NULL) OR

Line 483: mtl_item_locations_kfv milk2,

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
486: p_transaction_temp_id IS NOT NULL) OR
487: (mmtt.cartonization_id = p_cartonization_id AND

Line 867: , mtl_item_locations_kfv milk

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
871: wdd_item.lpn_id IS NULL)

Line 1115: , mtl_item_locations_kfv milk

1111: , wlpn.attribute15
1112: , msik.concatenated_segments lpn_container_item
1113: FROM wms_license_plate_numbers wlpn
1114: , mtl_system_items_kfv msik
1115: , mtl_item_locations_kfv milk
1116: WHERE wlpn.lpn_id = p_lpn_id
1117: AND msik.organization_id(+) = wlpn.organization_id
1118: AND msik.inventory_item_id(+) = wlpn.inventory_item_id
1119: AND milk.organization_id(+) = wlpn.organization_id