EIS Views

➜ Back to Library
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
Download
Related Blitz Reports
EIS Reports EIS Execution History DIS Items, Folders and Formulas DIS Folders, Business Areas, Items and LOVs DIS Workbooks, Folders, Items and LOVs EIS Execution Summary AR Aging - 7 Buckets - By Salesperson/Agent RWB Report Columns AR Transactions and Payments
Blitz Report™

Blitz Report™ provides multiple benefits: