SQL: Using CROSS APPLY to replace multi-column predicate look-ups in T-SQL

A few months ago, I was asked a question by a friend of mine who is also a Data Platform MVP. He was trying to express a query like this: I'm trying to select stock items where the combinations of Size and LeadTimeDays are in the list.