Besides the business objects, the repository offers reporting views for lists, choice lists and reports. They are read-only and can be queried with Invantive Query Tool, for instance to list the tables of an application with their columns. The reporting views of the repository: - `itgen_active_sessions_r`, "Active Sessions": Reporting view containing a list of active sessions. - `itgen_ale_picklist_r`, "Application Languages": Reporting view for use as a picklist of application languages available in the GUI. - `itgen_apn_columns_r`, "Application's Special Columns": List of all columns with special meaning in an application. - `itgen_apn_picklist_r`, "Applications": Reporting view for use as a picklist of applications available in the GUI. - `itgen_aur_picklist_r`, "Application Users": Reporting view for use as a picklist of application users available in the GUI. - `itgen_cde_picklist_r`, "Codes": Reporting view for use as a picklist of codes available in the GUI. - `itgen_cgh_columns_r`: List of charts graph columns, retrieve from chart graphs on code..cgh_code. - `itgen_chart_columns_r`: List of all allowed chart columns, either dimension or measure. - `itgen_chart_graphs_r`: List of charts graphs, retrieve chart on mde_code..mde_code. - `itgen_charts_r`: List of charts. - `itgen_columns_r`, "Columns": Columns of tables, business objects views and reporting views included in the application, and their definitions. - `itgen_composition_extensions_r`, "Software Extensions": Extensions for Invantive Composition, registered in the database. - `itgen_composition_models_r`, "Models": Central model repository for Invantive Composition, registered in the database. - `itgen_composition_templates_r`, "Templates": Templates for Invantive Composition. - `itgen_composition_tmpl_s_r`, "Template Samples": Samples of Invantive Composition templates. - `itgen_control_extensions_r`, "Software Extensions": Extensions for Invantive Control, registered in the database. - `itgen_control_templates_r`, "Templates": Templates for Invantive Control. - `itgen_control_tmpl_s_r`, "Template Samples": Samples of Invantive Control templates. - `itgen_current_blocking_locks_r`, "Currently Blocking Locks": Reporting view with database sessions and their status. - `itgen_cve_picklist_r`, "Code Values": Reporting view for use as a picklist of code values available in the GUI. - `itgen_datamodel_are_r`, "Attribute Rules": List of attribute rules for the report 'itgen_datamodel'. - `itgen_datamodel_icn_r`, "Index Columns": List of index columns for the report 'itgen_datamodel'. - `itgen_datamodel_idx_r`, "Indexes": List of indexes for the report 'itgen_datamodel'. - `itgen_datamodel_r`, "Data Models": List of applications for the report 'itgen_datamodel'. - `itgen_datamodel_rct_r`, "Referential Constraints": List of referential constraints for the report 'itgen_datamodel'. - `itgen_datamodel_tbe_r`, "Tables": List of tables for the report 'itgen_datamodel'. - `itgen_datamodel_tcn_r`, "Table Columns": List of table columns for the report 'itgen_datamodel'. - `itgen_datamodel_vet_r`, "View Elements": List of view elements for the report 'itgen_datamodel'. - `itgen_datamodel_viw_r`, "Business Objects": List of views for the report 'itgen_datamodel'. - `itgen_db_context_settings_r`, "Database Contexts": Reporting view which provides the settings of all context variables excluding USERENV. - `itgen_db_ctx_r`, "Database Context": Reporting view with with session information. - `itgen_db_sessions_r`, "Database Sessions": Reporting view with all the business views of all Invantive Producer installations in this database. - `itgen_documents_r`, "Documents": Document of Invantive Producer. - `itgen_dss_picklist_r`, "Document Statuses": Reporting view for use as a picklist of views available in the GUI. - `itgen_dte_picklist_r`, "Document Types": Reporting view for use as a picklist of views available in the GUI. - `itgen_fk_tables_in_view_r`, "Related Tables directly used in Views": Tables joined directly to the master table in a view. - `itgen_ftn_picklist_r`, "Functions": Reporting view for use as a picklist of functions available in the GUI. - `itgen_gsy_picklist_r`, "Modules": Reporting view for use as a picklist of modules available in the GUI. - `itgen_gui_columns_r`, "GUI Columns": A discrete list of types of data categories for tables. - `itgen_implementation_order_r`, "Business objects ordered for implementation": Ordered list of business objects to be addressed in an implementation of an application. - `itgen_implementation_r`, "Implementations": A discrete list of types of data categories for tables. - `itgen_installations_r`, "Installations": Reporting view with the schemanames of all Invantive Producer installations in this database. - `itgen_invantive_news_r`, "Invantive News": Reporting view with news from the Invantive RSS feed. - `itgen_lce_usage_r`, "License Usage": Reporting view containing license usage for all users. - `itgen_lge_picklist_r`, "Applications": Reporting view for use as a picklist of applications available in the GUI. - `itgen_lov_are_action_moment_r`, "Action Moments": A discrete list of moments of action events for an attribute rule. - `itgen_lov_are_action_r`, "Action Categories": A discrete list of types of actions for an attribute rule. - `itgen_lov_are_event_r`, "Event Categories": A discrete list of types of events for an attribute rule. - `itgen_lov_data_length_type_r`, "Data Length Types": Reporting view. - `itgen_lov_data_type_r`, "Data Types": Reporting view. - `itgen_lov_delete_rule_r`, "Delete Rule Categories": A discrete list of types of possible actions on delete on a table. - `itgen_lov_evt_category_r`, "Event Categories": A discrete list of types of events for an attribute rule. - `itgen_lov_logging_level_r`, "Logging Level Types": Reporting view. - `itgen_lov_tbe_data_r`, "Data Categories": A discrete list of types of data categories for tables. - `itgen_master_table_per_view_r`, "Master Tables per View": Reporting view. - `itgen_mde_picklist_r`, "Modules": Reporting view for use as a picklist of modules available in the GUI. - `itgen_mle_picklist_r`, "Module Languages": Reporting view for use as a picklist of module languages available in the GUI. - `itgen_mve_columns_r`, "Web User Interfaces": Temporary view for the auto generated web UI. - `itgen_my_applications_pub_r`, "My Public Applications": Reporting view containing a list of active sessions. - `itgen_my_applications_r`, "My Application": Reporting view containing a list of active sessions. - `itgen_my_function_ids_r`, "My Function IDs": Reporting view containing function ids available to the user logged in. - `itgen_my_functions_r`, "My Functions": Reporting view containing functions available to the user logged in. - `itgen_my_lge_picklist_r`, "Languages": Reporting view for use as a picklist of application languages available in the GUI. - `itgen_my_roles_r`, "My Roles": List of roles assigned to the current user. - `itgen_natural_key_columns_r`, "Natural Key Columns": List of natural key columns per table. - `itgen_object_checksums_r`, "Object Checksums": Reporting view. - `itgen_object_definitions_r`, "Definitions": Reporting view with the code behind stored objects, consisting of procedures, functions, triggers and packages. - `itgen_object_origin_r`, "Object Origins": Versions of the objects installed on the server. - `itgen_object_tree_changes_r`, "Object Tree Changes": Overview of dependencies between a master object and all objects used by it. It can be used to analyze the reason why a project version views must be recalculated. - `itgen_object_versions_r`, "Object Versions": Reporting view which provides the versions of all objects in the database, as far as they can be determined. - `itgen_objects_r`, "Objects": Reporting view with the stored objects, consisting of tables, views, indexes and sequences. - `itgen_pre_load_r`, "Loading Action": Reporting view to enable logging on through an insert in Oracle SQL*Loader. - `itgen_qt_viewlist_r`, "Business Objects": Reporting view with all the business views of all Invantive Producer installations in this database. - `itgen_querytool_templates_r`, "Templates": Templates for Invantive Querytool. - `itgen_ref_constraints_vv_r`, "Referential Constraints": Reporting view with all inter-referential-constraints relationships in both directions (vice versa). - `itgen_rfn_picklist_r`, "Role Functions": Reporting view for use as a picklist of role functions available in the GUI. - `itgen_rle_picklist_r`, "Roles": Reporting view for use as a picklist of roles available in the GUI. - `itgen_session_temp_usage_r`, "Session Temporary Tablespace Usages": Reporting view with per session the amount of temporary tablespace used. - `itgen_session_trace_r`, "This Session Trace": Reporting view for use as a picklist of translations available in the GUI. - `itgen_solitary_bus_views_r`, "Solitary Business Views": Reporting view. - `itgen_source_code_r`, "Source Code Lines": Reporting view containing a all database objects with their user source lines. - `itgen_sources_r`, "Source Code": Reporting view containing a list of database objects with user sources. - `itgen_stg_picklist_r`, "Settings": Reporting view for use as a picklist of settings available in the GUI. - `itgen_tables_in_view_r`, "Tables in Views": Reporting view. - `itgen_tables_physical_r`, "Physical Tables": Reporting view with statistics on tables of the application. It is a modified copy of all_tables, changed to improve performance. - `itgen_tbe_picklist_r`, "Tables": Reporting view for use as a picklist of views available in the GUI. - `itgen_tcn_picklist_r`, "Table Columns": Reporting view for use as a picklist of codes available in the GUI. - `itgen_tln_picklist_r`, "Translations": Reporting view for use as a picklist of translations available in the GUI. - `itgen_translations_r`, "Translations": Reporting view for translations. - `itgen_translations_smoke_r`, "Translations": View to aid smoke process creating translation files. - `itgen_ure_picklist_r`, "User Roles": Reporting view for use as a picklist of user roles available in the GUI. - `itgen_user_segment_dep_r`, "Segment Dependencies": A 50 times quicker alternative for user_dependencies. - `itgen_usr_picklist_r`, "Users": Reporting view for use as a picklist of users available in the GUI. - `itgen_vet_analysis_r`, "View Element Analysis": Analysis of view elements when you get errors on Found no match. - `itgen_view_relations_r`, "View Relations": Reporting view. - `itgen_views_with_dct_r`, "Views with Documents": Reporting view with the views whose base tables can have documents attached. - `itgen_viw_picklist_r`, "Business Objects": Reporting view for use as a picklist of views available in the GUI. - `itgen_web_menu_functions_r`, "Web Menu Functions": Temporary view for the auto generated web UI. - `itgen_web_my_functions_r`, "Web Functions": Reporting view for use as a picklist of translations available in the GUI. - `itgen_web_relations_r`, "Web Relations": Temporary view for the auto generated web UI. - `itgen_web_ui_r`, "Web User Interfaces": Temporary view for the auto generated web UI.