Report to reflect latest asset location

Summary:

Report pulling through a line per location, even if it was updated

Content (please ensure you mask any confidential information):

We currently have an OTBI report which pulls through the location of every asset by asset number. An asset location has been recently updated and the report shows a line for the old location and a line for the new location, however the customer just wants it to reflect the latest location. Is there anyway to do this in OTBI?

If there isn't, does anyone who the SQL Table to link the location to the asset number?
I can see FA_LOCATIONS gives if the location is enabled or not and a creation/last updated date, however no effective start/end date is populated