DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 4371: ,mtl_item_locations_kfv milk

4367: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
4368: FROM mtl_material_transactions_temp mmtt
4369: ,wms_license_plate_numbers wlpn
4370: ,mtl_secondary_inventories msi
4371: ,mtl_item_locations_kfv milk
4372: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
4373: AND mmtt.cartonization_id = wlpn.lpn_id(+)
4374: AND NVL(mmtt.transfer_to_location,mmtt.locator_id) = milk.inventory_location_id(+)
4375: AND msi.organization_id(+) = mmtt.organization_id