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.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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