/* 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%'
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