Results for “okc_art_var_type”

14 results




Overview
Explore in AI Chat

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

Overview

APPS.OKC_TERMS_ADD_VARIABL_V is a reporting and integration view in the Oracle E-Business Suite Contracts (OKC) module, part of the Enterprise Contracts / Terms and Conditions (ETRM) schema family. It presents the set of business variables available for use within contract terms and clause authoring, resolving the internal variable definitions into a language-translated, human-readable form. The view exposes variable metadata such as the variable code, its translated name and description, the variable type, data type, validation value set, default value, and source information. Because it joins the base variables tables to their translations and to the FND_LOOKUPS lookup that decodes variable types, the view is the natural integration point for reports, forms, concurrent programs, and external interfaces that need to enumerate or resolve contract authoring variables without re-implementing the translation and decode logic themselves.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

  • VARIABLE_CODE — the unique identifier of the business variable; the primary join key across all base objects.
  • VARIABLE_TYPE — the system/user classification of the variable (for example 'S' for system, 'U' for user-defined). This value drives the DECODE and lookup join.
  • MEANING — the decoded display meaning of the variable type, obtained from FND_LOOKUPS for lookup type OKC_ART_VAR_TYPE. Note that the lookup join uses a DECODE that maps 'U' to 'U' and everything else to 'S'.
  • VARIABLE_NAME / DESCRIPTION — the translated (language-specific) name and description of the variable.
  • VARIABLE_DATATYPE, APPLICATION_ID, VALUE_SET_ID, VARIABLE_DEFAULT_VALUE — the datatype and validation attributes governing how the variable's value is entered and validated.
  • EXTERNAL_YN, VARIABLE_INTENT, CONTRACT_EXPERT_YN, DISABLED_YN — control flags for availability, intended use, and whether the variable is exposed to external consumers.
  • DOC_TYPE — the document type associated with the variable, or NULL for user-defined variables.
  • ATTRIBUTE1..ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield context and attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns for the underlying base row.

Common Use Cases and Queries

Typical usage includes enumerating available variables for a contract document type, verifying translations and lookup meanings, and feeding external term-authoring engines or reports. A canonical query filters on document type and active variables:

SELECT VARIABLE_CODE, VARIABLE_NAME, MEANING, VARIABLE_DATATYPE, VALUE_SET_ID, DOC_TYPE
FROM APPS.OKC_TERMS_ADD_VARIABL_V
WHERE DISABLED_YN = 'N'
AND VARIABLE_TYPE = 'S'
ORDER BY VARIABLE_NAME;

To list user-defined variables irrespective of document type:

SELECT VARIABLE_CODE, VARIABLE_NAME, DESCRIPTION
FROM APPS.OKC_TERMS_ADD_VARIABL_V
WHERE VARIABLE_TYPE = 'U';

Because the view performs the translation and OKC_ART_VAR_TYPE lookup decode centrally, report writers and interface developers are advised to query it directly rather than reconstructing the joins against OKC_BUS_VARIABLES_B, OKC_BUS_VARIABLES_TL, OKC_VARIABLE_DOC_TYPES, and FND_LOOKUPS. This ensures consistent language handling and variable-type display across all consumers.