Where the hell activity reason is stored?

Of course you have the guid of the activity (crmd_activity_h) right?
Great, now through CRMD_LINK and CRMD_SRV_OSSET reach table CRMD_SRV_SUBJECT, yes here it is.
And if you want to read the text, just read table QPCT too.