Need to extract Finance Net Right-of-Use and Accrued Asset Balance

Hi,

We are in process of migrating expense & revenue leases from EBS property manager module to fusion lease accounting. While migration, we need to extract Finance Net Right-of-Use for expense leases and Accrued Asset Balance for revenue leases.

Can you please provide me the sql query which can extract above 2 information for each payment term for all the leases as on date?

Thanks in advance.