Results for “bne_queries”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BNE_QUERIES_VL is a standard translation (MLS) view owned by the APPS schema in Oracle E-Business Suite, residing in the BNE — Web Applications Desktop Integrator product. It is VALID in both 12.1.1 and 12.2.2. The view presents a language-resolved projection of the BNE_QUERIES entity, exposing query definitions stored in the base and translation tables with the translated user-facing name substituted for the current session language. Its role is to provide a single, denormalized read interface for query metadata that reporting tools, integrations, and application forms can consume without manually joining base and translation tables or filtering by language.
Underlying Base Objects
The view is defined over two documented base objects, both exposed through APPS synonyms: BNE_QUERIES_B (the base table holding language-independent query attributes) and BNE_QUERIES_TL (the translation table holding language-dependent text). The join is performed on the composite keys APPLICATION_ID and QUERY_CODE, with the translation row restricted by the condition T.LANGUAGE = USERENV('LANG'), so that only the translation matching the caller's session language is returned. The select list sources the ROWID of the base row and its attributes, combined with the user-facing name from the translation table. Because it is a view rather than a table, no physical data is stored; it reflects the current state of the base and translation tables at query time, and any DML against BNE_QUERIES must target the underlying tables.
Key Columns
- ROW_ID — the ROWID of the base table row, retained for row-level operations and identification.
- APPLICATION_ID — identifies the owning application; part of the composite primary key.
- QUERY_CODE — the internal code identifying the query; the second component of the composite key.
- USER_NAME — the translated, user-facing name of the query, sourced from BNE_QUERIES_TL. This is the primary text column consumers display.
- QUERY_CLASS — classifies the query type or category.
- DIRECTIVE_APP_ID and DIRECTIVE_CODE — reference the associated directive that the query is tied to.
- OBJECT_VERSION_NUMBER — supports optimistic locking and change detection.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard audit columns recording who created and last modified the row and when.
Common Use Cases and Queries
Typical scenarios include building listings of available queries for a given application, resolving the display name of a query from its code, and validating that translations exist for a target language. Integrating with the view avoids duplicating the base-to-translation join logic in custom reports.
List queries for an application with their translated names:
- SELECT APPLICATION_ID, QUERY_CODE, USER_NAME, QUERY_CLASS FROM APPS.BNE_QUERIES_VL WHERE APPLICATION_ID = :app_id ORDER BY USER_NAME;
Resolve a specific query by code:
- SELECT USER_NAME, QUERY_CLASS, DIRECTIVE_APP_ID, DIRECTIVE_CODE FROM APPS.BNE_QUERIES_VL WHERE APPLICATION_ID = :app_id AND QUERY_CODE = :query_code;
Inspect audit and version metadata:
- SELECT QUERY_CODE, USER_NAME, OBJECT_VERSION_NUMBER, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.BNE_QUERIES_VL ORDER BY LAST_UPDATE_DATE DESC;
Because results follow USERENV('LANG'), callers running under different language sessions obtain translated names without altering the query text, making the view suitable for locale-aware reporting and integration extract load processes.
-
View: BNE_QUERIES_VL 12.1.1
BNE_QUERIES_VL is a standard translation view over the BNE_QUERIES entity.
APPS.BNE_QUERIES_VL·↳ BNE_QUERIES_B·↳ BNE_QUERIES_TL·Explore BNE module →
-
View: BNE_QUERIES_VL 12.2.2
BNE_QUERIES_VL is a standard translation view over the BNE_QUERIES entity.
APPS.BNE_QUERIES_VL·↳ BNE_QUERIES_B·↳ BNE_QUERIES_TL·Explore BNE module →
-
VIEW: APPS.BNE_QUERIES_VL 12.1.1
-
VIEW: APPS.BNE_QUERIES_VL 12.2.2
-
eTRM - BNE Tables and Views 12.2.2
Translations for BNE_VIEWERS_B
-
eTRM - BNE Tables and Views 12.1.1
Translations for BNE_VIEWERS_B