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.
Run EIS Views and other Oracle EBS reports with Blitz Report™ on our demo environment
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
era.application_name=:application_name
LOV