Search Results okl_pdt_pqy_vals




Overview
Explore in AI Chat

Overview

The OKL_PDT_PQY_VALS table is a core data object within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the Lease and Finance Management (OKL) product. Its primary function is to manage the association between product definitions and specific quality values. This table acts as a junction or intersection entity, enabling the flexible assignment of predefined quality attributes and their permissible values to products. This association is critical for configuring complex lease and finance products with detailed, rule-based characteristics that drive downstream contract and servicing logic.

Key Information Stored

The table stores the linking records that bind a product to a specific quality value. Key columns include the primary key ID, which uniquely identifies each association record. The PDT_ID column holds the foreign key reference to the product definition in the OKL_PRODUCTS table. The PDQ_ID column references the product quality definition in the OKL_PDT_PQYS table, which defines the quality attribute itself. Finally, the QVE_ID column references the specific permissible value for that attribute from the OKL_PQY_VALUES table. The combination of PDQ_ID and PDT_ID is enforced as a unique key (PQV_POT_UK), ensuring a product cannot have duplicate entries for the same quality attribute.

Common Use Cases and Queries

This table is central to product configuration and validation. A common use case is retrieving all quality values assigned to a specific product for display in a product configuration interface or for validation during contract creation. For reporting, it is used to analyze product feature sets. A typical query would join OKL_PDT_PQY_VALS to OKL_PRODUCTS, OKL_PDT_PQYS, and OKL_PQY_VALUES to produce a human-readable list of product qualities.

  • Sample Query: SELECT prod.name PRODUCT_NAME, pqy.name QUALITY_NAME, qve.value QUALITY_VALUE FROM okl_pdt_pqy_vals pqv, okl_products prod, okl_pdt_pqys pqy, okl_pqy_values qve WHERE pqv.pdt_id = prod.id AND pqv.pdq_id = pqy.id AND pqv.qve_id = qve.id AND prod.id = :p_product_id;
  • Data Validation: The table is often referenced in PL/SQL logic within the OKL product modules to validate that a contract line item's attributes conform to the allowed values defined for its associated product.

Related Objects

The OKL_PDT_PQY_VALS table is integral to the product quality data model, with defined foreign key relationships to three primary tables:

  • OKL_PDT_PQYS: Linked via PDQ_ID. This is the parent table defining the product quality attribute (e.g., "Asset Type," "Payment Frequency").
  • OKL_PRODUCTS: Linked via PDT_ID. This is the master table for lease and finance product definitions.
  • OKL_PQY_VALUES: Linked via QVE_ID. This table stores the discrete, allowed values (e.g., "Vehicle," "Equipment" for "Asset Type") for the qualities defined in OKL_PDT_PQYS.

These relationships ensure referential integrity and form a complete chain from the product (OKL_PRODUCTS) to the quality attribute (OKL_PDT_PQYS) to its specific allowed value (OKL_PQY_VALUES), with OKL_PDT_PQY_VALS serving as the connecting entity.