How to get relevant FA cost balances between accounts after a category change?

Summary:

For the below asset, there has been a category change. This resulted in 2 different cost accounts, old and new. Is there a way to get the Cost balances for it along with the associated accounts, without referring to XLA AE subledger tables?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):