EIS Views
Description
Categories: EIS
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.
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Application |
|
LOV |