Search Results okl_ptq_values




Overview
Explore in AI Chat

Overview

The OKL_PTQ_VALUES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as a repository for the specific, allowable values that can be assigned to a Template Quality during the configuration of financial products. In the context of product setup, a Template Quality defines a characteristic or attribute of a product template. This table provides the discrete set of valid entries for each such quality, enabling controlled, standardized data entry and ensuring data integrity. Its primary role is to support the Product Template - Template Qualities functionality, a critical component for defining and maintaining the detailed attributes of leasing and financing products within the system.

Key Information Stored

The table stores the association between a Template Quality and its permissible values. The key columns, as indicated by the metadata, are the ID, PTQ_ID, and VALUE. The ID column serves as the table's unique primary key identifier. The PTQ_ID is a foreign key column that links each value record to its parent Template Quality defined in the OKL_PTL_QUALITYS table. The VALUE column holds the actual data entry option, such as a specific term (e.g., "36 Months"), an asset type, or a rate basis, that is valid for the associated quality. The uniqueness constraint on the combination of PTQ_ID and VALUE (PTV_PTV_UK) ensures that duplicate values cannot be created for the same quality.

Common Use Cases and Queries

The primary use case is during the setup and maintenance of product templates, where administrators select from the pre-defined values in this table to configure product attributes. For reporting, it is used to analyze the configuration of product offerings. Common queries involve joining this table to its parent to list all qualities and their associated values, or to validate user input against the permissible set. For instance, to retrieve all configured values for a specific product template quality, a query would join OKL_PTL_QUALITYS to OKL_PTQ_VALUES.

  • SELECT q.NAME, v.VALUE FROM OKL_PTL_QUALITYS q, OKL_PTQ_VALUES v WHERE q.ID = v.PTQ_ID AND q.NAME = 'Lease Term';
  • SELECT * FROM OKL_PTQ_VALUES WHERE PTQ_ID = (SELECT ID FROM OKL_PTL_QUALITYS WHERE NAME = 'Asset Category');

Related Objects

The OKL_PTQ_VALUES table is centrally connected within the product template data model. It has a direct foreign key relationship with the OKL_PTL_QUALITYS table, which defines the Template Qualities themselves. Conversely, the OKL_PTL_PTQ_VALS table references OKL_PTQ_VALUES, establishing a link where specific values are assigned to instances of product templates. This creates a hierarchy: Quality (OKL_PTL_QUALITYS) -> Permissible Values (OKL_PTQ_VALUES) -> Assigned Value for a Template (OKL_PTL_PTQ_VALS).

  • Referenced Table (Parent): OKL_PTL_QUALITYS. Join Column: OKL_PTQ_VALUES.PTQ_ID = OKL_PTL_QUALITYS.ID
  • Referencing Table (Child): OKL_PTL_PTQ_VALS. Join Column: OKL_PTL_PTQ_VALS.PTV_ID = OKL_PTQ_VALUES.ID