Search Results allow_set_targetval_flag

Overview

AZ_SELECTION_SET_ENTITIES_VL is a bilingual (VL, "view with language") database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AZ — Application Implementation product family. It presents selection set entity definitions together with their translated entity occurrence names, exposing a single logical row per selection set entity for the session's active language. In the Oracle EBS 12.1.1 and 12.2.2 data models, the AZ module underpins the configuration and setup infrastructure used by application implementation and functional setup workflows, and selection sets define the entities, filters, and target value rules available for a given setup or configuration context. The view is marked VALID and serves as the reporting and integration access point over the underlying _B (base) and _TL (translation) tables, shielding consumers from the multilingual join logic and translating the LANGUAGE predicate to USERENV('LANG') automatically.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms under APPS:

• AZ_SELECTION_SET_ENTITIES_B — the base table holding language-independent selection set entity data, including flags, filtering parameters, sequence numbers, and WHO audit columns.
• AZ_SELECTION_SET_ENTITIES_TL — the translation table holding the language-dependent ENTITY_OCCURANCE_NAME, keyed by SELECTION_SET_CODE, USER_ID, ENTITY_OCCURANCE_CODE, and LANGUAGE.

The view joins the two tables on the compound key SELECTION_SET_CODE, USER_ID, and ENTITY_OCCURANCE_CODE, and restricts the translation row to the current runtime language. Because the query aliases AZ_SELECTION_SET_ENTITIES_B as B and AZ_SELECTION_SET_ENTITIES_TL as T, the ROWID exposed as ROW_ID is B.ROWID, identifying the underlying base row rather than the translation row.

Key Columns

• ROW_ID — ROWID of the base table row; usable for direct-row addressing against AZ_SELECTION_SET_ENTITIES_B.
• SELECTION_SET_CODE and USER_ID — composite identifier of the selection set and its owning user context.
• ENTITY_CODE, ENTITY_OCCURANCE_CODE, and REF_ENTITY_OCCURANCE_CODE — the entity being configured, its occurrence within the selection set, and any referenced occurrence.
• ENTITY_OCCURANCE_NAME — user-facing, language-translated display name (from the _TL table).
• UPDATABLE_FLAG, ALLOW_SET_TARGETVAL_FLAG, ALLOW_FILTER_FLAG, CHANGE_UPDATABLE_FLAG, FILTER_SET_FLAG, SELECTION_FLAG — Y/N behavior flags governing whether the entity is updatable, may set target values, may be filtered, and current selection/filter state.
• INCLUDE_TYPE, FILTERING_PARAMETERS, SEQ_NUM — inclusion semantics, filter criteria, and display/processing order.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include validating selection set configuration, reporting enabled entities per selection set, and integrating AZ setup definitions into downstream processes. The translated name makes the view suitable for user-facing reports without an explicit language join.

List entities for a selection set, ordered for display:

SELECT entity_occurance_code,
       entity_occurance_name,
       entity_code,
       include_type,
       updatable_flag,
       allow_filter_flag
FROM   apps.az_selection_set_entities_vl
WHERE  selection_set_code = :p_selection_set_code
ORDER  BY seq_num;

Identify entities that permit filtering and target value selection:

SELECT selection_set_code,
       entity_occurance_code,
       entity_occurance_name
FROM   apps.az_selection_set_entities_vl
WHERE  allow_filter_flag       = 'Y'
AND    allow_set_targetval_flag = 'Y';

Audit recent configuration changes via the WHO columns:

SELECT entity_occurance_code,
       entity_occurance_name,
       last_updated_by,
       last_update_date
FROM   apps.az_selection_set_entities_vl
WHERE  last_update_date >= TRUNC(SYSDATE) - 30;

Because the view resolves translation via USERENV('LANG'), reports execute correctly under the caller's session language, making it a reliable source for AZ selection set entity reporting and integration in both 12.1.1 and 12.2.2 environments.