Search Results clsf_code




Overview
Explore in AI Chat

Overview

OKR_IP_CLASSIFICATIONS_V is a database view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases belonging to the OKR — Contracts for Rights product family. Contracts for Rights was Oracle's licensing and intellectual property management module, distributed under the Applications technology stack and later classified as obsolete. The view presents a filtered, denormalized projection over the OKR_IP_CLASSIFICATIONS base table, exposing intellectual property classification assignments so that concurrent programs, forms, and integration interfaces can query classification data without directly referencing the physical table.

Within the OKR data model, intellectual property (IP) records are tagged with classification codes that categorize the nature of the asset, such as patent, trademark, copyright, or trade secret. OKR_IP_CLASSIFICATIONS_V serves as the read interface for those assignments. According to the ETRM metadata for 12.2.2, the object is documented as obsolete and the DBA data section states "Not implemented in this database," meaning the view may not exist in a given environment even though it appears in the shipped documentation set.

Underlying Base Objects

The view is defined over a single base table, OKR_IP_CLASSIFICATIONS, aliased as PCNB in the view text. No additional joins, lookup tables, or subqueries are documented. The view text is a straightforward column projection:

  • FROM OKR_IP_CLASSIFICATIONS PCNB
  • All columns are selected directly from the base table without transformation or filtering predicates.
  • The ROWID pseudocolumn is explicitly selected and aliased, exposing the physical row identifier of the underlying row.

The ETRM metadata records no documented referenced base objects beyond this table. Because the view performs no joins, its cardinality and row population are identical to that of OKR_IP_CLASSIFICATIONS.

Key Columns

  • ID — Primary identifier of the classification row, mapped from PCNB.ID.
  • ROW_ID — Rowid of the base table record; useful for direct row addressing in forms and correction scripts.
  • IP_ID — Foreign key to the intellectual property master record that the classification applies to.
  • CLSF_TYPE — Classification type discriminator, indicating the category or scheme under which the classification code is applied.
  • CLSF_CODE — The classification code value itself; this is the attribute users most frequently search for (the search term "clsf_code" maps directly to this column).
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO (Who Columns) audit attributes.

Common Use Cases and Queries

Typical usage centers on reporting and integration around classification codes. A frequent pattern retrieves all classifications for a given IP record:

  • SELECT ip_id, clsf_type, clsf_code FROM okr_ip_classifications_v WHERE ip_id = :ip_id;
  • SELECT clsf_code, COUNT(*) FROM okr_ip_classifications_v GROUP BY clsf_code; — summarizes usage of each classification code across the IP portfolio.
  • SELECT v.ip_id, v.clsf_code FROM okr_ip_classifications_v v WHERE v.clsf_code LIKE 'PAT%'; — pattern search when the exact code is unknown.

Because the view is a direct projection, queries against it are functionally equivalent to querying OKR_IP_CLASSIFICATIONS, and no performance advantage is gained beyond abstraction. In environments where the view is not implemented — as the metadata indicates for the documented 12.2.2 instance — queries must target the base table directly. Given the obsolete status of the OKR module, any dependent customizations should be reviewed for migration to supported alternatives.