Apex Users Login’s details

select WORKSPACE,APEX_USER,PAGE_NAME, trunc(VIEW_DATE) “Date”, VIEW_DATE
 from APEX_040100.APEX_WORKSPACE_ACTIVITY_LOG
Where workspace in (‘DOYEN’)
AND trunc(view_date) = trunc(sysdate-1)
–and TRUNC(view_date) BETWEEN :From_date AND :TO_DATE
and page_name not in (‘Page 1′,’zero’,’Oracle Application Express’,’Login’,’Application Builder’)
and apex_user is not null
–and APEX_USER NOT LIKE ‘%ADMIN’
AND APEX_USER NOT IN (‘DOYEN_DEV’,’nobody’,’DOYEN_ADMIN’)
–AND APEX_USER like ‘RAMYA’
order by view_date desc;