SQL gives me wrong purchase order number for invoice

Content

Hi,

When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753

When I do the following code, it gives me a PO of 90883 and 909615 which is wrong

SELECT DISTINCT pha.segment1

FROM 

ap_invoices_all aia, -- AP_INVOICES_ALL contains records for invoices you enter

po_headers_all pha,  -- PO_HEADERS_ALL contains header information for your purchasing documents. You need one row for each document you create.

XLA_TRANSACTION_ENTITIES xte -- This table contains a row for each transaction for which events have been raised in Subledger Accounting.