Tuesday, 15 November 2016

AP Invoice rejection query in oracle apps

/* Formatted on 11/15/2016 11:48:52 AM (QP5 v5.114.809.3010) */
SELECT   air.*
  FROM   ap_interface_rejections air,
         ap_invoice_lines_interface aili,
         ap_invoices_interface aii
 WHERE       aii.invoice_id = aili.invoice_id
         AND aili.invoice_line_id = air.parent_id
         AND INVOICE_NUM LIKE '%111424%'

No comments:

Post a Comment