EIS Views

Description

Categories
EIS
One row per EIS view that has reports, with the structure of its SQL, the XXEIS objects it references and the usage of its reports.

Source Type follows the EIS runtime: a view of type SQL runs from the SQL stored with it, any other from the database object of that name, looked up in the registered owner, then APPS, then XXEIS. View Owner and View Status describe that object. For a Missing view, Text Length and the SQL flags come from the SQL stored with the EIS view, where one exists.

Union (also minus and intersect), Group By and With Clause are evaluated at the top level of the SQL, outside inline views and subqueries, Distinct on its first select and Connect By anywhere; comments and literals are ignored. DFF Columns, KFF Columns and GL Account Columns show that EIS generated flexfield columns into the view between its descr#flexfield, kff and gl#accountff markers. XXEIS Objects lists the objects of the XXEIS schema that the database view references, with synonyms resolved, so it is blank for SQL views.

Reports, Active Reports, Runs and Users count the reports that run from the view. Reports with pasted SQL run from their own SQL and are counted only in Paste SQL Reports. Runs are eXpress and XL Connect executions that started within Executed within Days. EIS purges its run history, so a view without runs may still have been used before the earliest retained run.

SQL 231 lines

Parameters 9

ParameterTypeList of values SQL
ApplicationLOV
era.application_name=:application
CategoryLOV
erv.view_id in (select err.view_id from xxeis.eis_rs_reports err, xxeis.eis_rs_report_categories errc where err.category_id=errc.category_id and errc.category_name=:category)
Report NameLOV
erv.view_id in (select err.view_id from xxeis.eis_rs_reports err where err.report_name=:report_name)
View NameLOV
erv.view_name=:view_name
Source TypeLOV
z.source_type=:source_type
SeededLOV Oracle
erv.seeded_flag='Y'
Executed within DaysNumber
erp.start_time>=sysdate-:executed_within_days
ExecutedLOV Oracle
p.runs>0
Show SQLLOV
z.text "View SQL",