Results for “report_application_id”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EGO_REPORT_LISTS_VL is a multi-lingual (VL) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the EGO - Advanced Product Catalog product family. It exposes the report list definitions maintained by the Advanced Product Catalog reporting framework, presenting user-defined groupings of reports that control which reports appear on a given region for a given user and responsibility. As a translated view, it resolves the language-specific name and description columns (LIST_NAME and LIST_DESCRIPTION) against the session language, so applications and reports automatically display list metadata in the language indicated by USERENV('LANG'). The view is documented as VALID in both ETRM 12.1.1 and 12.2.2 metadata sets. Because reporting and personalization features in Advanced Product Catalog frequently need to present a list identifier together with its user-facing description, the view is the primary access point for queries that search on list_description.
Underlying Base Objects
The view is defined over two base objects, exposed through synonyms in the APPS schema:
- EGO_REPORT_LISTS_B – the base (non-translated) table holding the structural and key attributes of each report list, including LIST_ID, USER_ID, REPORT_APPLICATION_ID, REPORT_REGION_CODE, DEFAULT_FLAG, CUSTOMIZATION_LEVEL_ID, CLASSIFICATION1–3, ORGANIZATION_ID, and the standard WHO audit columns.
- EGO_REPORT_LISTS_TL – the translation table holding LIST_NAME and LIST_DESCRIPTION for each language.
The join is performed on LIST_ID, with the translation table filtered by ERLTL.LANGUAGE = USERENV('LANG'), which restricts the result to exactly one row per list for the caller's session language. This is the classic EBS _VL pattern: a _B table for language-independent data joined to a _TL table for translated text.
Key Columns
- LIST_ID – Primary key of the report list; the join key between _B and _TL tables.
- LIST_NAME – Language-specific name of the list, sourced from EGO_REPORT_LISTS_TL.
- LIST_DESCRIPTION – Language-specific description of the list, the column most commonly searched by end users.
- USER_ID – Owner of the list when it is a personal (user-defined) list; may be null for seeded or shared lists.
- REPORT_APPLICATION_ID / REPORT_REGION_CODE – Identify the application and region against which the list applies.
- DEFAULT_FLAG – Indicates whether the list is the default for its region/user context.
- CUSTOMIZATION_LEVEL_ID – The customization level governing who may modify the list (e.g., user, responsibility, site).
- CLASSIFICATION1, CLASSIFICATION2, CLASSIFICATION3, ORGANIZATION_ID – Flexible classification and organization-scoping attributes.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.
Common Use Cases and Queries
The view is typically queried to look up a list by its description, to retrieve the description for a known LIST_ID, or to drive LOVs and reports that must respect session language. A representative search on description is:
SELECT list_id, list_name, list_description, user_id, default_flag
FROM apps.ego_report_lists_vl
WHERE UPPER(list_description) LIKE UPPER('%&search_text%');- Retrieve the active default list for a region:
SELECT list_id, list_name, list_description
FROM apps.ego_report_lists_vl
WHERE report_region_code = :region
AND NVL(default_flag,'N') = 'Y'; - List all personal lists for a user:
SELECT list_id, list_name, list_description
FROM apps.ego_report_lists_vl
WHERE user_id = :user_id;
Because the translation filter uses USERENV('LANG'), query results depend on the session's NLS language setting; concurrent programs and integrations should initialize the session language explicitly when a deterministic description is required.
-
View: EGO_REPORT_LISTS_VL 12.1.1
This view is a multi-lingual view on the Report Lists tables
APPS.EGO_REPORT_LISTS_VL·↳ EGO_REPORT_LISTS_B·↳ EGO_REPORT_LISTS_TL·Explore EGO module →
-
Oracle Order Entry/Shipping reports
-
Table: EGO_REPORTS 12.1.1
This table is used to store Report information
-
Table: EGO_REPORTS 12.2.2
This table is used to store Report information
-
This table is used to store Report List information
-
This table is used to store Report List information
-
View: EGO_REPORT_LISTS_VL 12.2.2
This view is a multi-lingual view on the Report Lists tables
APPS.EGO_REPORT_LISTS_VL·↳ EGO_REPORT_LISTS_B·↳ EGO_REPORT_LISTS_TL·Explore EGO module →
-
Oracle Order Entry/Shipping reports
-
VIEW: OE.SO_REPORTS# 12.2.2
-
VIEW: EGO.EGO_REPORTS# 12.2.2
-
VIEW: EGO.EGO_REPORTS# 12.2.2
-
TABLE: EGO.EGO_REPORTS 12.1.1
-
VIEW: OE.SO_REPORTS# 12.2.2
-
TABLE: OE.SO_REPORTS 12.2.2
-
TABLE: EGO.EGO_REPORTS 12.2.2
-
TABLE: OE.SO_REPORTS 12.1.1
-
eTRM - OE Tables and Views 12.2.2
Temporary table
-
eTRM - OE Tables and Views 12.1.1
Temporary table
-
eTRM - EGO Tables and Views 12.1.1
This table is used to store XML Schema Definitions.
-
eTRM - EGO Tables and Views 12.2.2
Interface table for Item Catalog Category header information
-
eTRM - OE Tables and Views 12.1.1
Temporary table
-
eTRM - OE Tables and Views 12.2.2
Temporary table