Query to get Item Class Change History

Hi,

Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I attempted to use the history tables for Item Class, specifically EGP_ITEM_CLASSES_B_ and EGP_ITEM_CLASSES_TL_, but they do not reflect the recent item class changes.

Additionally, I need to determine:

• The username responsible for modifying the item class name in PIM
• The timestamp of when the change occurred

I will share my current query below, but it is not returning the expected results. Could you help me identify the correct approach?