Search Results validation_tmplt_display_name




Overview
Explore in AI Chat

Overview

OE_PC_VTMPLTS_VL is a seeded, VALID view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ONT (Order Management) product family. The "_VL" suffix follows the standard Oracle Applications convention for a translated, language-sensitive view: it joins a base entity table to its corresponding translation table and filters the translation rows to the session language. In this case, the view exposes validation template definitions used by Order Management's Processing Constraints and validation framework, unifying the technical template definition with its language-specific display name and description. The view is available in both 12.1.1 and 12.2.2 and forms part of the public query surface through which validation template setup data is reported and consumed.

Notably, the view exposes API_PKG and API_PROC columns, which carry the name of the PL/SQL package and procedure invoked to perform the underlying validation logic. This makes the view directly relevant to the user's search term "api_pkg": the API_PKG column is the physical link between each configured validation template and the server-side API that implements it.

Underlying Base Objects

The view is defined over two base objects, both referenced in the ETRM metadata as synonyms:

The view text performs an inner join on VALIDATION_TMPLT_ID between the two tables and applies the predicate TL.LANGUAGE = USERENV('LANG'), so only rows translated into the caller's session language are returned. The view also selects V.ROWID as ROW_ID, providing a row identifier through the join.

Key Columns

Common Use Cases and Queries

Typical uses include setup reporting of validation templates, auditing which API package and procedure back each validation, and driving integration or extension logic that must resolve a template to its implementing API. Because the view is language-filtered, queries return display text in the session language.

List all validation templates with their implementing API:

  • SELECT validation_tmplt_id, validation_tmplt_short_name, validation_tmplt_display_name, validation_type, system_flag, api_pkg, api_proc FROM oe_pc_vtmplts_vl ORDER BY validation_tmplt_short_name;

Find the templates backed by a specific package (matching the "api_pkg" search):

  • SELECT validation_tmplt_short_name, validation_tmplt_display_name, api_pkg, api_proc, validation_type FROM oe_pc_vtmplts_vl WHERE api_pkg = :p_api_pkg;

Restrict to seeded templates for a given entity:

  • SELECT validation_tmplt_id, validation_tmplt_short_name, api_proc FROM oe_pc_vtmplts_vl WHERE entity_id = :p_entity_id AND system_flag = 'Y';

As with all APPS views, access should respect the standard MO security model, and joins to OE_PC_VTMPLTS by VALIDATION_TMPLT_ID are required when untranslated technical data beyond the exposed columns is needed.