In Oracle Fusion Payable Approval Process, the approver can add the comments. The blog provides the SQL Query to retrieve the Oracle Fusion Payables Clod Approver Comments table details
SELECT NOTE_ID, NOTE_TXT, SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID,CREATOR_PARTY_ID,CREATED_BY, CREATION_DATE, NOTE_TYPE_CODE, NOTE_NUMBER FROM ZMM_NOTES WHERE NOTE_TYPE_CODE LIKE 'AP_APPROVAL' AND SOURCE_OBJECT_UID IN (SELECT APPROVAL_HISTORY_ID FROM AP_INV_APRVL_HIST_ALL WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL WHERE INVOICE_NUM = :PayableInvoiceNum)) ORDER BY LAST_UPDATE_DATE DESC;