As before this problem in not to do with collation as Latin characters sort the same whether the collation is Latin or Chinese. The problem is your part numbers where...

The only solution is to amend you part numbering to something that will sort the way you expect

drop table #s_stkmst

create table #s_stkmst(part_code...

This has go nothing to do with the collation it is just that when you order the parts list using standard alphanumeric ordering you get a different order to the...