Query for Business Units and Legal Entities mapping for Payables.

Summary

Need query to fetch Business Units and associated Legal Entities mapping for Payables.

Content

Hi All,

I am having requirement to fetch all the Legal Entities available for the Business Unit while creating Payable Invoices manually.

Whenever we select specific Business Unit from the list the Legal Entities are being populated accordingly,Need to get this mapping between Business Unit and Legal Entity with respect to Cloud Payables.

Attached is the screenshot for the same screen mentioned above.Please help with the query or if any standard report available then that will too work,

 

Thanks in advance. 

Version

Oracle Cloud Application 20B (11.13.20.04.0)