ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5C6923AF043B711AE0630100007F4A58Y select era.application_name application, errc.category_name category, err.report_name, err.report_id "EIS Report ID", err.view_name, xxen_util.yes(err.seeded_flag) seeded, errco.display_order, errco.display_name, errco.column_name, xxen_util.yes(errco.derived_flag) derived, errco.calculation_column calculation, xxen_util.yes(case when regexp_like(errco.calculation_column,'xxeis\.','i') then 'Y' end) "XXEIS Reference", errco.data_type, ervc.data_type view_column_data_type, errco.data_format format, decode(err.group_by_flag,'Y',errco.group_function) group_function, xxen_util.yes(nvl(errco.enabled_flag,'Y')) enabled, xxen_util.yes(errco.display_flag) displayed, ervc_comp.component_name component, ervc_comp.alias_name component_alias from xxeis.eis_rs_reports err, xxeis.eis_rs_applications era, xxeis.eis_rs_report_categories errc, xxeis.eis_rs_report_columns errco, xxeis.eis_rs_view_columns ervc, xxeis.eis_rs_view_components ervc_comp where 1=1 and err.application_id=era.application_id and err.category_id=errc.category_id(+) and err.report_id=errco.report_id and errco.view_column_id=ervc.view_column_id(+) and errco.view_component_id=ervc_comp.view_component_id(+) order by era.application_name, errc.category_name, err.report_name, errco.display_order, errco.column_id Initial version: one row per EIS report column with report context, derived calculation, XXEIS reference flag, report and view column data types, format, group function, enabled/displayed flags and component. US EIS Report Columns EIS eXpress report column definitions: one row per column of an EIS report (eis_rs_report_columns), including disabled and hidden columns. Enabled blank means the column was removed from the report and EIS does not select it. Displayed blank means EIS selects the column but hides it, mostly ids without a display order. Calculation is the select expression of a derived column as EIS runs it: unqualified column names refer to the report view, and :Parameter Name tokens are replaced by the parameter values as literals. XXEIS Reference flags calculations that use an object of the XXEIS schema, which remains a dependency on EIS code after a migration. Data Type is set on derived columns and blank on most others, whose type is View Column Data Type: the type registered for the EIS view column, which can differ from the database view. Group Function is shown for group-by reports only, as EIS ignores it on the others. Executed within Days keeps the reports run from eXpress or XL Connect in that window. EIS purges its run history; EIS Execution History shows the earliest retained run. EIS 1=1 1 10 1=1 era.application_name=:application LOV custom Y select era.application_name value, era.description from xxeis.eis_rs_applications era order by era.application_name US Application 2 20 1=1 errc.category_name=:category LOV custom Y select distinct errc.category_name value, null description from xxeis.eis_rs_report_categories errc, xxeis.eis_rs_applications era where errc.application_id=era.application_id and (:$flex$.application is null or xxen_util.contains(:$flex$.application,era.application_name)='Y') order by errc.category_name US Category 3 30 1=1 err.report_name=:report_name LOV custom Y select err.report_name value, err.description from xxeis.eis_rs_reports err order by err.report_name US Report Name 4 40 1=1 err.seeded_flag='Y' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Seeded 5 1=1 err.seeded_flag is null N US Seeded 6 50 1=1 err.report_id in (select /*+ no_unnest */ erp.report_id from xxeis.eis_rs_processes erp where erp.submission_source in ('eXpress','XL Connect') and erp.start_time>=sysdate-:executed_within_days) Number 365 US Executed within Days Reports run within this many days before today. Blank includes reports without runs. 7 60 1=1 errco.derived_flag='Y' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Derived 8 1=1 nvl(errco.derived_flag,'N')<>'Y' N US Derived 9 70 1=1 regexp_like(errco.calculation_column,'xxeis\.','i') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US XXEIS Reference