How Payable Invoices related Payment Data is stored in Oracle Apps R12? (Oracle Payments, Oracle Payables)
In this post, we will find the tables involved in storing the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in R12.1.1 Instance. AP_TERMS SELECT * FROM AP_TERMS WHERE term_id IN ( SELECT DISTINCT terms_id FROM AP_INVOICES_ALL WHERE invoice_id = '166014' ); ...