Data visibility / editioning question

I queried AP invoice distributions on the Oracle EBS form, and used Examine to get invoice id = 3336239

I then went to SQL and queried ap_invoice_distributions_all where invoice_id = 3336239   --- and it returns no rows

I queried from ap_invoice_distributions_V (the view used by the form) where invoice_id = 3336239 -- and it returns no rows

I ran   select max(invoice_id) form ap_invoice_distributions_all and it returns 3335237, which is much lower than the invoice id shown in the application.

This is repeatable on many invoices created over the last several days.

I am absolutely certain I am querying the same database in the app and in SQL.