Search Results ref_selection_set_code

Overview

AZ_SELECTION_SETS_VL is a valid, predefined view owned by the APPS schema within the Oracle E-Business Suite. It belongs to the AZ product family, Application Implementation (also referred to as Application Implementation and Diagnostics or "Application Install"), a module responsible for the setup, configuration, and diagnostic infrastructure that supports the broader EBS environment. In Oracle EBS 12.1.1 and 12.2.2, this view functions primarily as a reporting and integration-facing object rather than a transactional entry point.

The view presents selection set definitions in a fully resolved, language-aware form. A selection set is a named grouping of structural or reference entries used during application implementation and setup activities, allowing administrators to define, reuse, and organize configuration data. By exposing both the descriptive (translated) attributes and the technical control attributes in a single result set, AZ_SELECTION_SETS_VL serves as the standard read-only access layer for downstream reports, concurrent programs, and interface extracts that must display selection set metadata without querying the underlying base tables directly.

Underlying Base Objects

According to the documented ETRM metadata for release 12.2.2, AZ_SELECTION_SETS_VL is defined over two base objects, both referenced through public synonyms in the APPS schema:

• AZ_SELECTION_SETS_B — the base (non-translated) table holding the core selection set attributes, including codes, flags, ownership, and audit columns.
• AZ_SELECTION_SETS_TL — the translation table holding language-specific descriptive text for each selection set.

The view joins these two objects on SELECTION_SET_CODE and USER_ID, and filters the translation table by T.LANGUAGE = USERENV('LANG'), so that each query returns only the description rows matching the session's current language. This join pattern is characteristic of Oracle's "_VL" (view language) convention, which presents a translated view of a _B/_TL table pair. The _B table supplies ROW_ID, audit columns, and the technical flags; the _TL table supplies SELECTION_SET_NAME and SELECTION_SET_DESC.

Key Columns

The view exposes the following documented columns, which fall into three logical groups:

• Identity and audit: ROW_ID (base table row identifier), CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
• Selection set definition: SELECTION_SET_CODE (the unique business key), SELECTION_SET_NAME and SELECTION_SET_DESC (translated descriptive values), USER_ID (owning user context), STRUCTURE_CODE (identifies the structure to which the selection set applies), and REF_SELECTION_SET_CODE (reference to another selection set, where applicable).
• Control and behavioral flags: ACTIVE (whether the selection set is enabled), HIERARCHICAL_FLAG (indicates hierarchical rather than flat selection), PARTIAL_SELECTION (indicates partial selection behavior), SOURCE_INSTANCE (origin or instance context), and PREDEFINED_FLAG — the column the user searched for, which distinguishes seed/predefined (Oracle-delivered) selection sets from user-defined ones. This flag is central to queries that need to isolate Oracle-provided configuration from customer-created configuration.

Common Use Cases and Queries

Because the view is language-aware and combines technical and descriptive data, it is commonly used for reporting on selection set inventories, distinguishing predefined (seeded) content from custom content, and feeding setup or diagnostic extracts. The PREDEFINED_FLAG column is especially useful when auditing which selection sets were shipped by Oracle versus created in-house.

A typical query listing active, predefined selection sets in the session language is:

SELECT selection_set_code,
       selection_set_name,
       structure_code,
       predefined_flag,
       hierarchical_flag,
       active
FROM   apps.az_selection_sets_vl
WHERE  active = 'Y'
AND    predefined_flag = 'Y'
ORDER BY selection_set_name;

A second common pattern retrieves a specific selection set by its code, returning both the descriptive and control attributes for display in an implementation report or concurrent program parameter list:

SELECT selection_set_code,
       selection_set_name,
       selection_set_desc,
       ref_selection_set_code,
       partial_selection
FROM   apps.az_selection_sets_vl
WHERE  selection_set_code = :p_selection_set_code;

In both cases, querying the _VL view ensures that descriptions are returned in the user's language and that only current translation rows are surfaced, avoiding the manual joins and language filter that would otherwise be required against AZ_SELECTION_SETS_B and AZ_SELECTION_SETS_TL directly.