Search Results properties_yn

Overview

OKR_CLASSIFICATIONS_CV is a view defined in the Oracle E-Business Suite module OKR — Contracts for Rights, a legacy vertical application that is documented as obsolete in the ETRM registry. The view is catalogued with the title "View: OKR_CLASSIFICATIONS_CV" and is described as "View for table OKR_CLASSIFICATIONS." Its principal purpose is to present classification records together with their decoded lookup meanings, so that reports, forms, and integration interfaces can display human-readable values rather than raw lookup codes. It is therefore a reporting convenience layer over the OKR_CLASSIFICATIONS base table rather than a transactional entity in its own right.

Users searching for the term "clsf_type" are typically working with the classification type attribute that drives how an intellectual property record — for example a title, trademark, or licensed right — is categorized. The CLSF_TYPE column is exposed directly, and it is also decoded through the OKR_CLASSIFICATION_TYPES lookup into CLSF_TYPE_MEANING. A secondary classification dimension, CLSF_CODE, is decoded through the OKR_CLASSIFICATION_CODES lookup into CLSF_CODE_MEANING and CLSF_CODE_DESC. The ETRM metadata records an important operational caveat: the view is "not implemented in this database" in the documented environment, so availability depends on whether the OKR module was installed and whether the obsolete component was ever deployed.

Underlying Base Objects

The view text identifies a multi-table join. The driving table is OKR_CLASSIFICATIONS, aliased CSNB, from which the ROW_ID pseudo-column and all attribute columns are sourced. Two self-joins against FND_LOOKUPS supply the lookup translations: alias CSFT joins on LOOKUP_TYPE = 'OKR_CLASSIFICATION_TYPES' and matches CSFT.LOOKUP_CODE to CSNB.CLSF_TYPE, while alias CSFC joins on LOOKUP_TYPE = 'OKR_CLASSIFICATION_CODES' and matches CSFC.LOOKUP_CODE to CSNB.CLSF_CODE.

The ETRM metadata states that no referenced base objects are formally documented and that the view is not implemented in the database, which means the runtime dependency chain should be verified directly against the target instance. Because the view joins FND_LOOKUPS without an outer join operator, classification rows whose CLSF_TYPE or CLSF_CODE has no corresponding lookup entry will be suppressed from the result set. A function call, OKR_UTIL_PUB.HAS_PROPERTIES, is executed inline against IP_TYPE, CLSF_TYPE, and CLSF_CODE to derive the PROPERTIES_YN flag, adding a PL/SQL dependency to the definition.

Key Columns

• ROW_ID — the ROWID of the underlying OKR_CLASSIFICATIONS row, useful for direct-row addressing.
• IP_TYPE — the intellectual property type to which the classification applies.
• CLSF_TYPE — the classification type code; this is the column most frequently targeted in searches for "clsf_type".
• CLSF_TYPE_MEANING — the decoded meaning of CLSF_TYPE from the OKR_CLASSIFICATION_TYPES lookup.
• CLSF_CODE and CLSF_CODE_MEANING, CLSF_CODE_DESC — the classification code and its decoded meaning and description from OKR_CLASSIFICATION_CODES.
• PROPERTIES_YN — a derived Y/N indicator returned by OKR_UTIL_PUB.HAS_PROPERTIES, showing whether property records exist for the combination.
• OBJECT_VERSION_NUMBER — optimistic locking version for the row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include validation reports that list classifications by type, integration extracts that publish classification data with readable meanings, and diagnostic queries confirming that lookup codes are correctly defined. A simple listing by classification type is:

SELECT clsf_type, clsf_type_meaning, clsf_code, clsf_code_meaning, properties_yn FROM okr_classifications_cv ORDER BY clsf_type, clsf_code;

To locate all rows for a specific type, filter on the code directly:

SELECT ip_type, clsf_code, clsf_code_desc FROM okr_classifications_cv WHERE clsf_type = :p_clsf_type;

To identify classification rows that exist in the base table but are excluded by the inner lookup joins, query OKR_CLASSIFICATIONS directly and compare against the view. Given the obsolete status and unverified deployment, always confirm object existence in ALL_OBJECTS before relying on this view in production reporting.