Search Results okl_pdt_pqys_pk

Overview

The OKL_PDT_PQYS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Leasing and Finance Management) product family. Its primary function is to manage the association between product templates and their defined qualities. This table serves as a junction or intersection entity, enabling a many-to-many relationship between product templates (OKL_PDT_TEMPLATES) and product qualities (OKL_PDT_QUALITYS). This design is fundamental to the product configuration framework in Oracle Leasing, allowing flexible definition of product attributes and characteristics.

Key Information Stored

The table's structure is designed to establish and enforce the association between two key entities. The primary columns are the unique identifier and the foreign keys linking to related tables. The ID column serves as the primary key (OKL_PDT_PQYS_PK), providing a unique system identifier for each association record. The PTL_ID column is a foreign key referencing the OKL_PDT_TEMPLATES table, identifying the specific product template. The PQY_ID column is a foreign key referencing the OKL_PDT_QUALITYS table, identifying the specific quality being assigned to the template. A unique key constraint (PDQ_POT_UK) on the combination of PTL_ID and PQY_ID ensures that a specific quality is not duplicated for the same product template.

Common Use Cases and Queries

This table is central to queries that list all qualities assigned to a product or find all products that possess a specific quality. A common reporting use case involves generating a product specification document that details all associated attributes. For instance, to retrieve all qualities for a given product template named 'EQUIPMENT_LEASE', a typical SQL pattern would involve joining the three core tables:

• SELECT ptl.name TEMPLATE_NAME, pqy.name QUALITY_NAME FROM okl_pdt_pqys pdq, okl_pdt_templates ptl, okl_pdt_qualitys pqy WHERE pdq.ptl_id = ptl.id AND pdq.pqy_id = pqy.id AND ptl.name = 'EQUIPMENT_LEASE';

Data maintenance tasks, such as adding a new quality to a set of product templates or validating configurations, also rely heavily on this table.

Related Objects

The OKL_PDT_PQYS table is a pivotal link in the product data model, with documented relationships to several key objects. It is directly dependent on the product template and quality master tables, and it is referenced by a child table that stores specific values for these associations.

• OKL_PDT_TEMPLATES: The parent table for product templates. Joined via OKL_PDT_PQYS.PTL_ID = OKL_PDT_TEMPLATES.ID.
• OKL_PDT_QUALITYS: The parent table for product quality definitions. Joined via OKL_PDT_PQYS.PQY_ID = OKL_PDT_QUALITYS.ID.
• OKL_PDT_PQY_VALS: A child table that holds the specific values for a quality assigned to a product. Joined via OKL_PDT_PQY_VALS.PDQ_ID = OKL_PDT_PQYS.ID.