I think the issue is on "SUBSTRING(bd.buft_string_1, 35, 70) = mdmpa.message_text"
Did you prove this by removing the join and getting rows returned?
If it is the substring then the most likely cause is either bd.buft_string_1 contains non space chars (hidden or otherwise) after "ALL MET ITEMS FOR VIN PROCESSED SUCCESSFULLY" or the text does not start at column 35.
What is the size of bd.buft_string_1?
Far away is close at hand in the images of elsewhere.
Anon.