ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 729B2857091D7748E053AD00140A40CD select era.application_name, erv.view_name, erv.user_view_name, erv.description, dv.text, xxen_util.user_name(erv.created_by) created_by, xxen_util.user_name(erv.last_updated_by) last_updated_by, erv.creation_date, erv.view_owner from xxeis.eis_rs_views erv, xxeis.eis_rs_applications era, ( select u.name owner, o.name view_name, xxen_util.long_to_clob('SYS.VIEW$', 'TEXT', v.rowid) text from sys."_CURRENT_EDITION_OBJ" o, sys.view$ v, sys.user$ u where o.obj#=v.obj# and o.owner#=u.user# ) dv where 1=1 and erv.application_id=era.application_id(+) and erv.view_owner=dv.owner and erv.view_name=dv.view_name order by era.application_name, erv.view_name Y US EIS Views List of EIS report database views. This can be used, for example, when migrating from EIS to Blitz Report, to analyze your current EIS reports database views for the migration. EIS 1=1 1 10 1=1 era.application_name=:application_name LOV custom Y select era.application_name value, era.description from xxeis.eis_rs_applications era where era.application_id in (select erv.application_id from xxeis.eis_rs_views erv) order by era.application_name US Application