Search Results value_set_table

Overview

The HXC_ALIAS_DEFINITIONS_V view is a reporting and integration construct within the Oracle E-Business Suite Time and Labor Engine (HXC) product family. It exposes alias definition metadata that governs how time card and time collection aliases are resolved at runtime, mapping symbolic alias names to concrete reference objects such as descriptive flexfield contexts and flexfield value sets. The view is owned by the APPS schema and is documented as VALID in ETRM for releases 12.1.1 and 12.2.2.

A distinguishing characteristic of this view is that it is not a single-source projection of one base table. It is a UNION of two distinct query branches, each resolving a different class of alias reference object. The first branch targets descriptive flexfield contexts, while the second branch targets flexfield value sets. Both branches join the same header and translation tables, and both are constrained to the alias type OTL_ALT_DDF or the three value set alias types (VALUE_SET_NONE, VALUE_SET_TABLE, VALUE_SET_INDEPENDENT). Because of this union design, consumers must be aware that the ALIAS_CONTEXT_NAME column carries different semantics depending on which alias type the row represents.

The view's role in reporting is to provide a denormalized, language-aware representation of alias configuration so that downstream inquiries can resolve alias names, prompts, descriptions, and the underlying reference object without separately joining translation and type tables.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over five referenced objects:

• HXC_ALIAS_DEFINITIONS (synonym to the base table) — the alias definition header, supplying ALIAS_DEFINITION_ID, ALIAS_CONTEXT_CODE, BUSINESS_GROUP_ID, LEGISLATION_CODE, ALIAS_TYPE_ID, audit columns, and OBJECT_VERSION_NUMBER.
• HXC_ALIAS_DEFINITIONS_TL (synonym) — the translation table, restricted to ADTL.LANGUAGE = USERENV('LANG'), supplying ALIAS_DEFINITION_NAME, DESCRIPTION, and PROMPT.
• HXC_ALIAS_TYPES (synonym) — supplies ALIAS_TYPE and ALIAS_TYPE_ID, and provides the REFERENCE_OBJECT discriminator used to join to the appropriate reference table.
• FND_DESCR_FLEX_CONTEXTS_VL (view) — the descriptive flexfield context view joined in the first UNION branch via HAT.REFERENCE_OBJECT = TO_CHAR(FF.DESCRIPTIVE_FLEX_CONTEXT_CODE).
• FND_FLEX_VALUE_SETS (synonym) — the value set table joined in the second UNION branch via HAT.REFERENCE_OBJECT = TO_CHAR(FF.FLEX_VALUE_SET_ID).

The two branches are unified by ALIAS_DEFINITION_ID and by the consistent output column list, which aligns column counts and datatypes across the union.

Key Columns

• ALIAS_DEFINITION_ID — Primary identifier for the alias definition; join key to the translation table.
• ALIAS_DEFINITION_NAME — Language-specific name of the alias definition, sourced from the TL table.
• ALIAS_CONTEXT_NAME — A polymorphic column. For descriptive flexfield context rows it holds FF.DESCRIPTIVE_FLEX_CONTEXT_NAME; for value set rows it holds FF.FLEX_VALUE_SET_NAME.
• ALIAS_CONTEXT_CODE — The code stored on the alias definition header (AD.ALIAS_CONTEXT_CODE). This is the column most frequently used for filtering and lookup, as reflected by the common search term "alias_context_code".
• BUSINESS_GROUP_ID — Owning business group, enabling multi-org-style filtering where applicable.
• LEGISLATION_CODE — Optional legislative restriction associated with the alias definition.
• DESCRIPTION / PROMPT — Language-specific descriptive text and UI prompt text from the TL table.
• ALIAS_TYPE / ALIAS_TYPE_ID — Classifies the alias (descriptive flexfield or value set variant), driven by HXC_ALIAS_TYPES.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

The view is commonly used to report alias definitions by context code, to determine which flexfield context or value set an alias resolves to, and to drive integration extracts that map alias names to reference objects. A typical query filtering on the alias context code is:

SELECT alias_definition_id, alias_definition_name, alias_context_code,
  alias_context_name, alias_type, prompt, description
FROM apps.hxc_alias_definitions_v
WHERE alias_context_code = :p_context_code
ORDER BY alias_definition_name;

To list aliases by type, filtering distinguishes the union branches because ALIAS_CONTEXT_NAME is polymorphic:

SELECT alias_type, alias_definition_name, alias_context_name
FROM apps.hxc_alias_definitions_v
WHERE alias_type = 'OTL_ALT_DDF';

Additional scenarios include restricting to a business group (WHERE business_group_id = :p_bg_id), filtering on legislation, or joining back to the base tables on ALIAS_DEFINITION_ID for update-tracking reports. Because the view enforces USERENV('LANG'), all queries return text in the session language, and consumers should expect one row per alias definition per language, with the reference object resolved through either the flexfield context or the flexfield value set depending on alias type.