Search Results pdt_name




Overview
Explore in AI Chat

Overview

The view APPS.OKL_PDT_ALLOWED_STREAMS_UV is a supplementary database view within the Oracle E-Business Suite (EBS) Enterprise Contracts (OKL / ETRM) module. It is registered under the application schema APPS with FND Design Data reference OKL.OKL_PDT_ALLOWED_STREAMS_UV and carries a VALID status in both the 12.1.1 and 12.2.2 releases. The view's purpose is to simplify forms coding by presenting a flattened, denormalized projection of the stream types that are permitted for a given product (PDT). Oracle explicitly warns that this view is a supplementary device used to streamline Forms development, and therefore it should not be treated as a stable integration interface; its column set and underlying definition may change dramatically between minor or major releases. Consumers should treat it as a read-only convenience layer rather than a customer-facing API. In reporting and ad hoc analysis contexts, the view is most commonly queried to answer the question of which stream types (and associated purposes, effective dates, and template configuration) are allowed against particular products, and it is typically surfaced when users search on the PDT_NAME attribute.

Underlying Base Objects

The view's definition references the following documented objects, either directly or indirectly through its join logic:

No database object in EBS references OKL_PDT_ALLOWED_STREAMS_UV, confirming its status as a terminal, presentation-oriented view that does not feed downstream logic. All referenced base objects are exposed as APPS synonyms, consistent with standard EBS schema layering.

Key Columns

  • ID (NUMBER) — unique identifier for the stream type.
  • NAME (VARCHAR2 150) — the stream type name.
  • DESCRIPTION (VARCHAR2 1995) — user-entered description of the stream type.
  • PDT_ID (NUMBER) — product identifier.
  • PDT_NAME (VARCHAR2 150) — the product name associated with the allowed stream, and the field most frequently used as a query filter.
  • START_DATE / END_DATE (DATE) — effectiveness window for the stream type.
  • PURPOSE (VARCHAR2 80) — the stream type purpose, typically resolved through FND_LOOKUPS.

Common Use Cases and Queries

Typical uses include reporting which streams are permitted for a product, validating effective-dated stream configurations, and driving Forms-based maintenance screens. A basic query retrieves all allowed streams for a specific product name:

  • SELECT id, name, pdt_name, purpose, start_date, end_date FROM apps.okl_pdt_allowed_streams_uv WHERE pdt_name = :product_name;
  • SELECT pdt_name, name, purpose FROM apps.okl_pdt_allowed_streams_uv WHERE SYSDATE BETWEEN start_date AND end_date ORDER BY pdt_name, name;
  • SELECT DISTINCT pdt_name FROM apps.okl_pdt_allowed_streams_uv ORDER BY 1;

Because the view is not referenced by any other database object and carries Oracle's explicit stability warning, consumers should restrict its use to reporting and development-support scenarios and avoid embedding it in custom interfaces expected to survive an upgrade.