link between payable and XLA Tables

Dear All,

im trying to implement a query to know who created the transaction, invoice .. anything related to payment with GL

if i click on drilldown the view transaction -> the click on help -> record history i want to know: created by

i write this query but still there is something missing if the, can you please hekp:

if UPPER(:source) like 'PAYABLES' then 

 

 

  SELECT  distinct    xte.entity_code into vcode

  FROM                            

       gl_code_combinations gcc,

       xla.xla_transaction_entities xte,

       xla.xla_events xev,

       xla.xla_ae_headers xah,

       xla.xla_ae_lines xal,

       gl_import_references gir,