Session login history from ash - oracle database script

SELECT c.username,
       a.SAMPLE_TIME,
       a.SQL_OPNAME,
       a.SQL_EXEC_START,
       a.program,
       a.module,
       a.machine,
       b.SQL_TEXT
FROM DBA_HIST_ACTIVE_SESS_HISTORY a,
     dba_hist_sqltext b,
     dba_users c
WHERE a.SQL_ID = b.SQL_ID(+)
  AND a.user_id=c.user_id
  AND c.username='&username'
ORDER BY a.SQL_EXEC_START ASC;