Search Results fnd_lookup_values_vl




Overview
Explore in AI Chat

Overview

XNC_ITEM_ACTION_PARS_VL is a language (VL) view belonging to the XNC – Sales for Communications product family, a module now marked obsolete in Oracle E-Business Suite. As documented, the view is "the join of the base table and translation table with all the columns from both table." In EBS terminology, a "_VL" view typically denotes a view that combines a "_B" (base) table with its corresponding "_TL" (translation) table, filtering the translation rows to the session language.

In practice, XNC_ITEM_ACTION_PARS_VL exposes the definition of item action parameters used to configure parameterized item actions within the XNC schema. Each row represents an individual parameter that can be attached to an item action, along with its display properties, default value, source configuration, and lookup-derived meanings. The view is not a transactional or reporting table in the usual sense; it acts as a reference and configuration data source that supports both functional page rendering and ad hoc queries that need human-readable (translated) descriptions rather than raw lookup codes.

Its role in reporting and integration is largely master-data oriented. It provides descriptive labels for lookup codes (such as parameter names, display flags, source types), enabling downstream reports, interfaces, and UI layers to present meaningful text instead of coded values. Because the view resolves lookups against FND_LOOKUP_VALUES_VL, it is a convenient single source for joining parameter metadata with its associated lookup meanings.

Underlying Base Objects

The view is defined over four distinct source objects (with translation further resolving language-specific descriptions):

  • XNC_ITEM_ACTION_PARS_B — the base table holding item action parameter records and their attributes.
  • XNC_ITEM_ACTION_PARS_TL — the translation table providing parameter descriptions per language, joined on ITEM_ACTION_PARAM_ID and filtered by T.LANGUAGE = USERENV('LANG').
  • FND_LOOKUP_VALUES_VL — the standard Oracle lookups view, joined four times (aliases D, G, E, F) to derive meanings for parameter name, display flag, source type, and source name.

The documentation notes that no referenced base objects are recorded in the ETRM metadata, and the view is "not implemented in this database," meaning the object is not physically present in the documented environment. Where it exists, the join conditions rely on lookup types CSI_EXTEND_ATTRIB_POOL, XNC_IA_PARS_DISPLAY, and XNC_IA_PARS_SOURCE_TYPE.

Key Columns

Common Use Cases and Queries

Typical usage centers on configuration reporting and interface validation. Analysts query the view to list parameters for a given item action, to confirm which parameters are mandatory or displayed, or to reconcile lookup meanings. The presence of the CSI_EXTEND_ATTRIB_POOL lookup join means the view is frequently referenced in scenarios involving extend-attribute pool parameters. A sample query retrieving parameters for a specific action is shown below.

  • List all parameters for an item action:
    SELECT ITEM_ACTION_PARAM_ID, PARAMETER_NAME, PARAMETER_MEANING, MANDATORY_FLAG, DEFAULT_VALUE, DISPLAY_MEANING, SOURCE_TYPE_MEANING, SEQUENCE FROM XNC_ITEM_ACTION_PARS_VL WHERE ITEM_ACTION_ID = :action_id ORDER BY SEQUENCE;
  • Find mandatory parameters only:
    SELECT PARAMETER_NAME, PARAMETER_MEANING, DEFAULT_VALUE FROM XNC_ITEM_ACTION_PARS_VL WHERE MANDATORY_FLAG = 'Y' AND START_DATE_ACTIVE <= SYSDATE;
  • Resolve source configuration details:
    SELECT PARAMETER_NAME, SOURCE_TYPE_MEANING, SOURCE_NAME, SOURCE_MEANING FROM XNC_ITEM_ACTION_PARS_VL WHERE SOURCE_TYPE_CODE IS NOT NULL;

Because translation is filtered on the session language, queries return labels in the runtime language of the connecting user, making the view suitable for both user-facing reports and localized interface integrations.