Need a query to retrieve the classroom location and the legal entity associated with that location.

Summary:

Dear All,

I am creating a BI report in the Learning module, and there is a requirement to retrieve the Classroom Location and the Legal Entity associated with that location. I have shared the BI report template and highlighted the columns I need: Classroom Legal Entity and Classroom Division.

Navigation to classroom name of a course – : My client group > Learning > Course > Select a course > Offerings > Activities

Navigation to classroom location -:
My client group > Learning > Classroom > Search classroom

I noticed that there is a location_id column in the wlf_resources_tl table, which is used to retrieve classroom details. However, most location_id values in the hr_all_organization_units_f_vl table are null.