Last transaction per order

Hi All,

I've got the following dataset 

I'm trying to figure out a way of getting a list of order numbers where the last actcod (based on trndte) was 'CANPCK'.

Any help would be much appreciated.

Thank you