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.