Wednesday, September 29, 2021

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.

at 2 comments:
Labels: ,

Saturday, September 18, 2021

FA Module Interface Tables and Base Tables

 


at 3 comments:
Labels:

AP Module Interface Tables and Base Tables




at 2 comments:
Labels:

INV Module Interface Tables and Base Tables




at 2 comments:
Labels:

OM Module Interface Tables and Base Tables




at 1 comment:
Labels:

AR Module Interface Tables and Base Tables


at 1 comment:
Labels:

GL Module Interface tables and Base Tables.

 

at No comments:
Labels:
Subscribe to: Posts (Atom)

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...