Query to calculate distribution wise Asset depreciation before and after asset transfer

We need to calculate asset depriciation based upon asset distribution accounts.

we 've scenario where

assets addition done & transferred in with distribution account  and after couple of months assets transfer to another distribution.

when calculating depreciation we're getting entire depriciation for the year in newly transferred dusribution account.

which is not tallying with gl trial balance report.

so need to get asset depreciation for before transferred distribution account

and

asset depriciation for newly transferred account.

I've attached query for reference, please suggest the changes.

Thanks,

Kirti