Search Results ptq_ptq_uk

Overview

The OKL_PTL_QUALITYS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically in versions 12.1.1 and 12.2.2. It functions as a master repository for defining Template Qualities. These qualities are configurable attributes or characteristics that can be assigned to Product Templates during the product setup and configuration process. The table's role is to establish a standardized set of descriptive criteria—such as condition, grade, or performance metrics—that can be consistently applied across leasing and financing products, enabling structured product definition and classification within the complex financial agreements managed by the OKL module.

Key Information Stored

The table's structure is designed to uniquely identify and describe each template quality. While the full column list is not detailed in the provided metadata, the documented primary and unique keys highlight the most critical fields. The ID column serves as the primary key (OKL_PTL_QUALITYS_PK), providing a unique system-generated identifier for each record. The NAME column is enforced as a unique key (PTQ_PTQ_UK), storing the distinct, user-defined name of the quality attribute (e.g., 'Equipment Condition', 'Credit Tier'). Additional columns, typical for such setup tables, would likely include creation and last update dates, descriptive fields, and active status indicators to control the quality's usability in product templates.

Common Use Cases and Queries

This table is primarily accessed during the administrative setup of leasing products and during runtime validation. A common operational scenario involves querying the available qualities to assign to a new product template or validating user input against the defined list. For reporting, it is often joined to transaction tables to analyze product portfolios by their configured qualities. Sample SQL patterns include retrieving all active qualities for a setup UI or finding which qualities are used in specific product families.

• Retrieve all defined template qualities: SELECT id, name FROM okl_ptl_qualitys WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Find a specific quality's ID for validation: SELECT id FROM okl_ptl_qualitys WHERE name = '<Quality_Name>';

Related Objects

The OKL_PTL_QUALITYS table is a parent entity in two key relationships, as documented by its foreign keys. These relationships link the definition of a quality to the specific values permitted for it and to its assignment on templates.

• OKL_PTQ_VALUES: This table references OKL_PTL_QUALITYS via the PTQ_ID column. It stores the list of valid discrete values (e.g., 'New', 'Used', 'Refurbished') for a given template quality defined in OKL_PTL_QUALITYS.
• OKL_PTL_PTQ_VALS: This table also references OKL_PTL_QUALITYS via the PTQ_ID column. It acts as an association table, linking Product Templates (likely in a table such as OKL_PRODUCT_TEMPLATES) to the specific Quality-Value pairs (from OKL_PTQ_VALUES) that define that template's attributes.