Results for “additional_quickpick_columns”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EGO_VAL_SET_VALUE_TABLES_V is an APPS-owned database view in Oracle E-Business Suite, registered under the EGO product family (Advanced Product Catalog). It exposes the physical table-and-column mappings that Oracle Flexfields use to validate values within a given value set. In effect, the view answers the question: for a specific flexfield value set, which application table and which columns supply the valid values, their meanings, and their surrogate identifiers?

Views of this type are essential to Flexfield validation logic and to any integration that must resolve a value set's backing storage. When a value set is defined with a table-based validation (rather than an independent or dependent value set), its permissible values originate from a designated application table. This view surfaces the metadata describing that storage: the table name, the value, meaning, and ID columns, their data types and sizes, and any supplementary WHERE clause or quick-pick configuration. In EBS 12.1.1 and 12.2.2, it functions as a metadata bridge, allowing reports, integrations, and concurrent programs to introspect value set validation sources without querying the underlying flexfield repository directly.

Underlying Base Objects

The view is defined as a single-source SELECT over FND_FLEX_VALIDATION_TABLES, referenced through a SYNONYM. No joins, unions, or aggregations are present; every column in EGO_VAL_SET_VALUE_TABLES_V is a direct projection of a corresponding column in that base table. The view therefore acts as a filtered presentation layer, giving EGO a stable interface onto the Flexfields validation repository maintained by the Application Object Library.

Because it does not perform transformation, correctness mirrors the base table: if a value set's validation table registration is incomplete, the view reflects that incompleteness. The ETRM metadata lists exactly one referenced object, FND_FLEX_VALIDATION_TABLES, confirming the view's role as a simple, read-only projection.

Key Columns

The view exposes fourteen columns, all inherited from FND_FLEX_VALIDATION_TABLES:

• VALUE_SET_ID — Foreign key to FND_FLEX_VALUE_SETS; identifies the value set whose validation storage is described.
• TABLE_NAME and TABLE_APPLICATION_ID — The application table supplying valid values and its owning application.
• VALUE_COLUMN_NAME, VALUE_COLUMN_TYPE, VALUE_COLUMN_SIZE — Column holding the actual valid value, plus its datatype and length.
• MEANING_COLUMN_NAME, MEANING_COLUMN_SIZE, MEANING_COLUMN_TYPE — Column supplying the displayed meaning/description, with size and datatype. The user term "meaning_column_type" corresponds directly to MEANING_COLUMN_TYPE here.
• ID_COLUMN_NAME, ID_COLUMN_SIZE, ID_COLUMN_TYPE — Column supplying the surrogate identifier for the value.
• ADDITIONAL_WHERE_CLAUSE — Optional SQL predicate restricting the rows eligible as valid values.
• ADDITIONAL_QUICKPICK_COLUMNS — Extra columns exposed in the Flexfield quick-pick list of values.

Common Use Cases and Queries

Typical uses include auditing value set definitions, diagnosing validation errors, building generic LOV integrations, and documenting data lineage for table-validated flexfields. The following query returns validation details for a specific value set:

• SELECT value_set_id, table_name, value_column_name, meaning_column_name, meaning_column_type, meaning_column_size FROM ego_val_set_value_tables_v WHERE value_set_id = :p_value_set_id;
• SELECT value_set_id, table_name, additional_where_clause FROM ego_val_set_value_tables_v WHERE table_name = 'MTL_SYSTEM_ITEMS_B';

Because the view is read-only and unaggregated, it is safe for high-volume reporting. Access is governed by standard APPS schema grants and Flexfields responsibilities.