Search Results qve_ove_uk

Overview

The OKL_PQY_VALUES table is a core reference data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically in the context of product configuration. It serves as a master repository for the discrete values that can be assigned to product qualities. During the setup of a financial product, such as a lease or loan, administrators define qualities (attributes) for that product. The OKL_PQY_VALUES table stores the permissible list of values for those qualities, enabling structured and controlled product definition. Its primary role is to support the "Product - Quality Value" association during the product setup process, ensuring data integrity and consistency across the leasing portfolio.

Key Information Stored

The table's structure is designed to manage the relationship between a quality and its valid values. The most critical columns include the primary key ID, which uniquely identifies each value record. The VALUE column stores the actual textual or coded entry that users can select, such as "New," "Used," or "Refurbished" for an asset condition quality. The PQY_ID column is a foreign key that links the value back to its parent product quality definition in the OKL_PDT_QUALITYS table. This establishes which values are applicable to which specific quality. The table enforces a unique constraint (QVE_OVE_UK) on the combination of VALUE and PQY_ID, preventing duplicate value entries for the same quality.

Common Use Cases and Queries

A primary use case is the validation and population of lists of values (LOVs) in the product setup user interface. When a user assigns a quality to a product, the application queries this table to present the available choices. For reporting, analysts may query this table to understand the full spectrum of configurable product attributes. Common SQL patterns include retrieving all values for a specific product quality or finding which qualities a particular value is associated with. For example, to list all values for a quality with ID 100, one would use: SELECT value FROM okl_pqy_values WHERE pqy_id = 100 ORDER BY value;. Another common query joins OKL_PQY_VALUES with OKL_PDT_QUALITYS to produce a comprehensive list of qualities and their permissible values for product documentation.

Related Objects

The OKL_PQY_VALUES table is centrally connected to other key product setup entities via documented foreign key relationships. It has a direct parent-child relationship with the OKL_PDT_QUALITYS table, which stores the definition of the product qualities themselves. The join is made on the column OKL_PQY_VALUES.PQY_ID = OKL_PDT_QUALITYS.[Primary Key]. Furthermore, OKL_PQY_VALUES is referenced as a parent table by OKL_PDT_PQY_VALS, which is the junction table that physically assigns a specific quality value to a specific product. This relationship is defined by the foreign key on OKL_PDT_PQY_VALS.QVE_ID pointing to the ID column in OKL_PQY_VALUES. This hierarchy forms the backbone of the product qualification data model.