Querying for Employee Invoices in Oracle Cloud

It is common to need to query invoices generated by employees. However, the relationship between the AP_INVOICES_ALL and PER_ALL_PEOPLE_F tables is not straightforward. These tables are connected through the HZ_PARTIES table. The relationship is shown below:

https://www.datafusing.com...