Search Results okr_prop_types_cv

Overview

OKR_PROP_TYPES_CV is a correlation view (the "_CV" suffix) within the Oracle EBS OKR — Contracts for Rights module. The OKR module supports the licensing and management of intellectual property rights, and this view exposes the property type definitions used to classify intellectual property (IP) records throughout the application. Its primary role is to resolve and present the descriptive, language-dependent attributes of property types alongside their operational attributes, joined against the current user's language setting.

The view is documented as obsolete and is not implemented in the referenced database, meaning it should be treated as a legacy or seed-data artifact rather than an actively supported object. Nevertheless, it remains a useful reference point for understanding how OKR property types were modeled and reported on, particularly for organizations upgrading from earlier OKR releases.

Underlying Base Objects

The view is defined over two base tables in a standard Oracle EBS multilingual (TL) pattern:

• OKR_PROP_TYPES_B — the base table holding language-independent property type data (all columns aliased as PTYB).
• OKR_PROP_TYPES_TL — the translation table holding the language-dependent meanings and descriptions (aliased as PTYT).

The two tables are joined on the IP_TYPE key, with the translation restricted by PTYT.LANGUAGE = USERENV('LANG'), ensuring only the meaning and description for the session's language are returned. The view also invokes the OKR_UTIL_PUB.GET_LU_MEANING lookup utility to derive a translated meaning for the basic property type, referencing the lookup type OKR_BASE_PROPERTY_TYPES. No other referenced base objects are documented.

Key Columns

• IP_TYPE — the primary identifier of the property type.
• IP_TYPE_MEANING — the language-specific descriptive name; this is the column most directly associated with the searched term "ip_type_meaning."
• IMAGE_SOURCE — indicates the source of imagery associated with the property type.
• BASIC_IP_TYPE — the underlying or parent property type classification.
• BASIC_IP_TYPE_MEANING — the translated meaning of the basic property type, computed via OKR_UTIL_PUB.GET_LU_MEANING.
• DESCRIPTION — the language-specific detailed description.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range of the property type.
• SFWT_FLAG — a flag originating from the translation table.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard Oracle EBS descriptive flexfield (DFF) columns.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard auditing and concurrency columns.

Common Use Cases and Queries

Typical uses include validating property type lookup values, joining property types to licensed IP records, and building multilingual reports where the correct translated meaning must appear. A representative query follows:

• SELECT ip_type, ip_type_meaning, basic_ip_type_meaning FROM okr_prop_types_cv WHERE NVL(end_date_active, SYSDATE+1) > SYSDATE; — retrieves active property types with translated meanings.
• SELECT ip_type, description FROM okr_prop_types_cv WHERE ip_type_meaning LIKE 'Audio%'; — searches property types by meaning.

Because the view is obsolete and not implemented in the current database, implementations should confirm its availability before use and consider a direct join of OKR_PROP_TYPES_B and OKR_PROP_TYPES_TL as a substitute.