Query/SQL for datamodel in BI Publisher of Other Addresses in Location Page

Summary:

Hi,

Do you know via datamodel/BI Publisher in what table other addresses for locations are stored?

We do not find them either in: HR_LOCATIONS_ALL_F_VL or per_location_details_f_tl or per_location_details_f or HR_LOCATIONS.

We did find we could do a join with PER_LOC_ADDRESS_USAGES_F & PER_ADDRESSES_F

But we were wondering if there was already a view that showed both main address & other type address linked to one locaiton.

Thank you for your help.

Kind regards,

Pilar

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