Search Results okl_ptl_ptq_vals




Overview
Explore in AI Chat

Overview

The OKL_PTL_PTQ_VALS table is a core intersection table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to manage the association between product templates, template qualities, and their assigned values. This structure is fundamental to the product configuration and definition capabilities of the OKL module, enabling the creation of complex financial products by linking a base product template (PDT) with specific, configurable attributes (qualities) and the permissible values for those attributes. It acts as a critical junction in the data model, enforcing business rules about which quality-value combinations are valid for a given product template.

Key Information Stored

The table's structure is designed to store associative relationships through foreign key references. The key columns are the foreign keys that link to the related master data tables. The system-generated primary key, ID, ensures uniqueness of each record. The three critical foreign key columns define the association: PTL_ID links to the product template in OKL_PDT_TEMPLATES, PTQ_ID links to the defined quality or attribute in OKL_PTL_QUALITYS, and PTV_ID links to the specific allowable value for that quality from the OKL_PTQ_VALUES table. A unique key constraint (PMV_PMV_UK) on the combination of PTL_ID and PTQ_ID typically ensures that a specific quality is not assigned more than once to the same template.

Common Use Cases and Queries

This table is central to queries that retrieve the complete attribute profile of a financial product template for display, validation, or product instantiation. A common use case is generating a list of all configurable qualities and their possible values for a given product template ID during contract setup. For reporting, it is used to analyze which qualities are most frequently applied across a portfolio of product templates. A typical SQL pattern involves joining OKL_PTL_PTQ_VALS with the three referenced tables to get descriptive names.

SELECT ptl.name TEMPLATE_NAME,
       ptq.name QUALITY_NAME,
       ptv.name VALUE_NAME
FROM okl.okl_ptl_ptq_vals ppv,
     okl.okl_pdt_templates ptl,
     okl.okl_ptl_qualitys ptq,
     okl.okl_ptq_values ptv
WHERE ppv.ptl_id = ptl.id
  AND ppv.ptq_id = ptq.id
  AND ppv.ptv_id = ptv.id
  AND ptl.id = :p_template_id;

Related Objects

The functionality of OKL_PTL_PTQ_VALS is defined by its documented foreign key relationships, which are essential for data integrity and application logic. The table has three direct parent tables:

  • OKL_PDT_TEMPLATES: Linked via PTL_ID. This is the master table for product templates.
  • OKL_PTL_QUALITYS: Linked via PTQ_ID. This table stores the definition of the qualities or attributes themselves.
  • OKL_PTQ_VALUES: Linked via PTV_ID. This table stores the discrete, allowable values for the qualities defined in OKL_PTL_QUALITYS.

This table is likely referenced by various OKL APIs and user interfaces responsible for product template maintenance and contract booking, where the valid quality-value combinations for a template must be enforced.