Oracle - Relationship between material transactions - orders, attachments - ap_invoices

select mmt.source_code           
         , mmt.transaction_id
         , oh.order_number           
  from mtl_material_transactions mmt                       
         , oe_order_headers_all oh         
where 1 = 1                                      
    and mmt.transaction_reference = oh.header_id (+)
    and mmt.transaction_id = <transaction_id>; 

 select aia.invoice_num
         , fad.*
  from fnd_attached_docs_form_vl fad
         , ap_invoices_all aia
where 1 = 1
    and aia.invoice_id = fad.pk1_value
    and aia.invoice_num = '<invoice_number>';