query to retrieve lease details

Summary:

need to extract some Lease Details like the Location

Content (please ensure you mask any confidential information):

from the existing Leases, I need to know the Location value for each of them, can you please help with query or report containing that information for all leases?

this is the screenshot inquiring a Lease, showing the Location value :

I even tried these 2 tables, none success, cannot find the location_id there

--select * from fla_lease_asset_serials

--select * from fla_leases_all

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

24c

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