Results for “ptq_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_PTL_PTQ_VALS_UV is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Leasing and Finance Management product family. The view consolidates pricing term qualification data used within the Oracle Lease and Finance Management pricing engine, presenting a denormalized, join-ready projection over three underlying OKL objects. Its role is to expose the effective qualification values assigned to a pricing term list (PTL) in a single queryable structure, allowing reporting, integration, and extension developers to retrieve qualification context without reconstructing the joins manually.

The "_UV" suffix identifies this as a user view — a supported interface intended for external consumption rather than internal application processing. This distinction is important in ETRM, where base tables such as OKL_PTL_PTQ_VALS carry normalized foreign keys that are not meaningful in isolation. The view resolves those keys into descriptive names and values, so the object is commonly used as the reporting layer for lease pricing qualification analysis.

Underlying Base Objects

The view is defined over three documented base objects, each referenced through a synonym in the APPS schema:

• OKL_PTQ_VALUES (aliased PTV) — stores the individual qualification values available for selection.
• OKL_PTL_QUALITYS (aliased PTQ) — stores the qualification definitions, including their names and identifiers.
• OKL_PTL_PTQ_VALS (aliased PMV) — the intersection or assignment table that links a pricing term list to a specific qualification and its value, with effective dating.

The join condition is expressed as PMV.PTV_ID = PTV.ID AND PMV.PTQ_ID = PTQ.ID. Consequently, the assignment table drives the result set; every row returned represents one qualification-value pairing attached to a pricing term list as recorded in OKL_PTL_PTQ_VALS.

Key Columns

• ID — the surrogate identifier from the assignment row (PMV.ID), uniquely identifying the qualification-value association.
• PTQ_NAME — the descriptive name of the qualification drawn from OKL_PTL_QUALITYS.
• PTQ_ID — the foreign key to the qualification definition.
• PTV_VALUE — the qualification value text from OKL_PTQ_VALUES, representing the selected qualifier.
• PTV_ID — the foreign key to the qualification value record.
• PTL_ID — the pricing term list identifier, the primary grouping key. This is the column most frequently referenced when users search for "ptl_id".
• FROM_DATE and TO_DATE — the effective date range during which the qualification-value association is active.
• OBJECT_VERSION_NUMBER — the optimistic locking version column maintained by the underlying base table.

Common Use Cases and Queries

Typical scenarios include auditing which qualifications apply to a given pricing term list, extracting qualification values for downstream pricing simulation, validating effective dating when pricing results appear inconsistent, and joining the view into custom reports on lease pricing structure.

To retrieve all qualification values for a specific pricing term list:

• SELECT ptq_name, ptv_value, from_date, to_date FROM apps.okl_ptl_ptq_vals_uv WHERE ptl_id = :p_ptl_id AND SYSDATE BETWEEN from_date AND NVL(to_date, SYSDATE);

To list all distinct qualifications defined across term lists, use SELECT DISTINCT ptq_id, ptq_name FROM apps.okl_ptl_ptq_vals_uv ORDER BY ptq_name;. Because the view performs an inner join through OKL_PTL_PTQ_VALS, rows will only appear where a valid qualification and value pair exists; orphaned assignments are naturally excluded, which makes the view a reliable source for reporting without additional null-handling logic.