Results for “pdq_id”
46 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_PDT_PQY_VALS_UV is an APPS-owned database view within the Oracle E-Business Suite Lease and Finance Management (OKL) module. Its name reflects its purpose: it presents product ("PDT") quality ("PQY") values ("VALS") in a user-agnostic form, denoted by the "_UV" suffix. The view consolidates attribute values that a leased or financed product can carry for each of the qualities associated with its product template line (PTL), and it is designed to present one row per defined value while also surfacing qualities that have no explicitly stored value.
Because the view sits directly over the core product-qualification tables, it functions as a reporting and integration surface. It allows inquiry forms, concurrent reports, and external interfaces to read the complete set of a product's qualifying attributes without duplicating the join logic across each consumer. In EBS 12.1.1 and 12.2.2 the view is registered in the applications schema and is referenced from many lease product setup and quotation flows.
Underlying Base Objects
The view is defined over five OKL base objects, which appear in the ETRM metadata as synonyms resolving to their underlying tables:
- OKL_PRODUCTS (PDT) — the product definition; supplies PDT_ID and the PTL link.
- OKL_PDT_QUALITYS (PQY) — the quality (qualifier) definition, providing the NAME, FROM_DATE, and TO_DATE.
- OKL_PDT_PQYS (PDQ) — the association between a product template line and a quality.
- OKL_PDT_PQY_VALS (PQV) — the stored value for a product/quality pairing.
- OKL_PQY_VALUES (QVE) — the value master, supplying VALUE and DESCRIPTION.
Functionally, OKL_PRODUCTS links to OKL_PDT_PQYS on PTL_ID, OKL_PDT_PQYS links to OKL_PDT_QUALITYS on PQY_ID, and OKL_PDT_PQY_VALS links both the product and the PDQ row to the value master OKL_PQY_VALUES. The view is a UNION of two branches: the first returns stored values, while the second returns a distinct row per applicable quality using a NOT EXISTS exclusion when no stored value exists.
Key Columns
- ID — the primary key of the stored value row (OKL_PDT_PQY_VALS.ID); NULL for rows synthesized from the second UNION branch.
- PDT_ID — the product identifier; this is the column most commonly used when filtering, and the object requested by searches for "pdt_id".
- PDQ_ID — the product-to-quality association identifier from OKL_PDT_PQYS.
- PQY_ID — the quality identifier from OKL_PDT_QUALITYS.
- NAME — the quality name, typically the user-facing attribute label.
- VALUE — the stored value for the quality; NULL where no value is defined.
- DESCRIPTION — the descriptive text of the value from OKL_PQY_VALUES.
- OBJECT_VERSION_NUMBER — the optimistic locking version of the value row.
- FROM_DATE / TO_DATE — effective dating; populated from the quality definition when no stored value exists.
Common Use Cases and Queries
The view is most often queried to render all qualities applicable to a product, whether or not values have been captured. A typical query filters by the product identifier:
- Retrieving all qualities for a product:
SELECT pdt_id, pqy_id, name, value, description FROM okl_pdt_pqy_vals_uv WHERE pdt_id = :p_product_id; - Identifying qualities missing values:
SELECT name FROM okl_pdt_pqy_vals_uv WHERE pdt_id = :p_product_id AND value IS NULL; - Joining to product master data to enrich reports with product names and template-line context.
- Facilitating data migration or integration extracts, since the union guarantees a complete list of qualities per product rather than only those with stored values.
Because the view is read-only and maintained by the OKL application, it should not be modified; consumers should treat it as the canonical read interface for product quality values.
-
View: OKL_PDT_PQY_VALS_UV 12.1.1
APPS.OKL_PDT_PQY_VALS_UV·↳ OKL_PDT_PQYS·↳ OKL_PDT_PQY_VALS·↳ OKL_PDT_QUALITYS·Explore OKL module →
-
Association Quality Values with a product.
-
View: OKL_PDT_PQY_VALS_V 12.2.2
Association Quality Values with a product.
APPS.OKL_PDT_PQY_VALS_V·↳ OKL_PDT_PQY_VALS·Explore OKL module →
-
View: OKL_PDT_PQY_VALS_UV 12.2.2
APPS.OKL_PDT_PQY_VALS_UV·↳ OKL_PDT_PQYS·↳ OKL_PDT_PQY_VALS·↳ OKL_PDT_QUALITYS·Explore OKL module →
-
Association Quality Values with a product.
-
View: OKL_PDT_PQY_VALS_V 12.1.1
Association Quality Values with a product.
APPS.OKL_PDT_PQY_VALS_V·↳ OKL_PDT_PQY_VALS·Explore OKL module →
-
VIEW: OKL.OKL_PDT_PQY_VALS# 12.2.2
-
TABLE: OKL.OKL_PDT_PQY_VALS 12.1.1
-
TABLE: OKL.OKL_PDT_PQY_VALS 12.2.2
-
VIEW: OKL.OKL_PDT_PQY_VALS# 12.2.2
-
PACKAGE: APPS.OKL_PQV_PVT 12.1.1
-
PACKAGE: APPS.OKL_PQV_PVT 12.2.2
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards