Useful query for checking sourcing status table

I had an issue I opened with tech support. The overall sourcing status was showing No AML but I did in fact have AML/AVL data for a particular part. It turns out the OEMPARTAXLCONTEXTLINK table had no entry. Still investigating as to how this occurred but this query showed the extent of the issue. I will close this thread with a summary of how we think it was caused.

SELECT m.wtpartnumber, A.IDA2A2, a.amlpreferencedata, a.avlpreferencedata, o.oempreferencedata
FROM WTPART P, WTPARTMASTER M, oempartaxlcontextlink O, AXLEntry A
WHERE
p.ida3masterreference = M.IDA2A2 AND
o.ida3a5 (+) = p.ida2a2 AND
a.IDA3C4 = p.ida2a2 AND
p.latestiterationinfo = 1

Where you have null entries for the OEMPREFERENCEDATA is where you have problems.