Results for “okl_prod_qlty_val_uv”

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

Overview

The OKL_PROD_QLTY_VAL_UV view is a database object owned by the APPS schema within Oracle E-Business Suite, belonging to the OKL (Leasing and Finance Management) product family. It is classified as a VALID view in both EBS 12.1.1 and 12.2.2 and serves as the Product Quality Values View. Its principal role is to flatten the normalized quality-attribute model used by OKL products into a single, report-friendly result set. Rather than requiring report authors and integration developers to join four separate tables, the view exposes one row per product quality value, combining the product identifier, the human-readable quality name, and the assigned value. This simplifies reporting against product configuration data and supports downstream integration, extracts, and custom concurrent programs that need to retrieve product quality definitions without reconstructing the underlying relational model. Because it is documented as a "_UV" (user view), it is intended for read-only consumption by reporting and integration layers rather than for transactional updates.

Underlying Base Objects

The view is defined over four base objects, all referenced through synonyms resolving to the OKL application tables:

• OKL_PRODUCTS — the product master, supplying the product identifier (PDT_ID).
• OKL_PDT_QUALITYS — the quality definition, supplying the quality name (QUALITY_NAME).
• OKL_PDT_PQY_VALS — the association linking a product to a specific quality record (PDT_ID to QVE_ID).
• OKL_PQY_VALUES — the individual quality value records (QVE.VALUE, QVE.PQY_ID).

The join logic chains these objects together: OKL_PRODUCTS.ID = OKL_PDT_PQY_VALS.PDT_ID, OKL_PDT_PQY_VALS.QVE_ID = OKL_PQY_VALUES.ID, and OKL_PQY_VALUES.PQY_ID = OKL_PDT_QUALITYS.ID. In effect, the view traverses from a product, through its assigned quality values, up to the parent quality definition, yielding the resolved name/value pair per product.

Key Columns

• PDT_ID — the numeric identifier of the product in OKL_PRODUCTS; acts as the joining key for reporting on a specific product.
• QUALITY_NAME — the descriptive name of the quality definition (OKL_PDT_QUALITYS.NAME), used as the attribute label in reports.
• QUALITY_VAL — the value assigned to that quality for the product (OKL_PQY_VALUES.VALUE), representing the configured attribute content.

Common Use Cases and Queries

The view is most commonly used to enumerate the quality attributes and values configured for one or more leasing products, typically for audit, listing, or migration extracts. A typical query retrieving all qualities for a single product is:

• SELECT pdt_id, quality_name, quality_val FROM apps.okl_prod_qlty_val_uv WHERE pdt_id = :p_product_id ORDER BY quality_name;
• SELECT a.pdt_id, b.name product_name, a.quality_name, a.quality_val FROM apps.okl_prod_qlty_val_uv a, apps.okl_products b WHERE a.pdt_id = b.id AND a.quality_name = :p_quality;

The first query supports point lookups of product configuration; the second extends the view by joining to OKL_PRODUCTS to surface the product name alongside each quality. Because the view already encapsulates the four-table join internally, custom reports built on it remain simpler, less error-prone, and easier to maintain across EBS releases. It is suitable for read-only reporting and integration extraction, consistent with its documented status as a user view in the OKL module.