Skip to main content

Posts

Showing posts with the label Payment

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'         );          AP_TERMS_LINES   SELECT   * FROM    AP_TERMS_LINES WHERE   term_id  IN         (   SELECT   DISTINCT  terms_id      ...