Query to get AWT Invoice for given Standard Invoice in Oracle Payables.

 SELECT wht_inv.invoice_id

  FROM ap_invoices_all std_inv

      ,ap_invoice_distributions_all std_inv_dist

      ,ap_invoices_all wht_inv

WHERE std_inv.invoice_id = 123456789

  AND std_inv.invoice_id = std_inv_dist.invoice_id

  AND std_inv.org_id = std_inv_dist.org_id

  AND std_inv_dist.awt_invoice_id = wht_inv.invoice_id

  AND std_inv.org_id = wht_inv.org_id

Where 123456789 is the Standard Invoice ID.

FA Module Interface Tables and Base Tables

 

AP Module Interface Tables and Base Tables

INV Module Interface Tables and Base Tables

OM Module Interface Tables and Base Tables

AR Module Interface Tables and Base Tables

GL Module Interface tables and Base Tables.