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/que....rying-for-employee-i
Like
Comment
Share
