Search Results dnz_rgtp_id




Overview
Explore in AI Chat

Overview

OKR_IP_RGTS_TXN_LANG_CV is a read-only view in the Oracle E-Business Suite (EBS) OKR — Contracts for Rights module, a component of the Oracle E-Records and intellectual property rights management functionality. The object is classified as obsolete in the ETRM (E-Business Suite Technical Reference Manual) documentation and is explicitly noted as "Not implemented in this database," meaning it exists as a metadata artifact rather than an active runtime database object in the 12.1.1 and 12.2.2 environments described.

The view presents language-specific translation records for intellectual property rights transaction data. Its role in reporting and integration is to expose the language dimension of rights transactions — the LANGUAGE_CODE and its human-readable equivalent — alongside the transactional foreign keys that link each row back to its parent rights transaction, IP, and rights-group records. The _CV suffix indicates a "code view" convention, where coded values are commonly joined to lookup definitions; here the decode is performed inline via OKR_UTIL_PUB.GET_LU_MEANING.

Underlying Base Objects

The view is defined over a single documented base table: OKR_IP_RGTS_TXN_LANG. This table stores the translated or language-variant descriptions associated with rights transaction lines. The view applies a straightforward projection of all principal columns from that table, aliased as TXLA, and augments them with a derived LANGUAGE_NAME value.

The ETRM metadata records "Referenced base objects: none" in the structured section, but the embedded view text clearly identifies OKR_IP_RGTS_TXN_LANG as the sole FROM clause source. No joins to other tables appear in the view definition. The only external dependency is the PL/SQL function OKR_UTIL_PUB.GET_LU_MEANING, invoked with the lookup type OKR_IP_LANGUAGE, which resolves the stored LANGUAGE_CODE into a descriptive LANGUAGE_NAME at query time.

Key Columns

  • ID — Primary identifier of the language row in OKR_IP_RGTS_TXN_LANG.
  • IP_RGTS_TXN_ID — Foreign key to the parent intellectual-property rights transaction record.
  • DNZ_IP_ID — Reference to the associated IP (intellectual property) entity.
  • DNZ_RGTP_ID — Reference to the rights group or rights type parent record; the user's search term "dnz_rgtp_id" corresponds directly to this column.
  • DNZ_IP_RIGHTS_ID — Reference to the specific IP rights definition.
  • LANGUAGE_CODE — The stored language code for the translation.
  • LANGUAGE_NAME — Decoded language description derived through OKR_UTIL_PUB.GET_LU_MEANING using lookup type OKR_IP_LANGUAGE.
  • OBJECT_VERSION_NUMBER — Optimistic locking/versioning attribute.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.
  • START_DATE_ACTIVE, END_DATE_ACTIVE — Effective-dating bounds controlling when the language record is active.

Common Use Cases and Queries

Typical usage centers on retrieving or reconciling multi-language descriptions for rights transactions and tracing the DNZ_RGTP_ID linkage. A representative query filtering by the searched column:

SELECT id,
       ip_rgts_txn_id,
       dnz_rgtp_id,
       language_code,
       language_name,
       start_date_active,
       end_date_active
FROM   okr_ip_rgts_txn_lang_cv
WHERE  dnz_rgtp_id = :p_rgtp_id
AND    TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE))
                         AND NVL(end_date_active, TRUNC(SYSDATE));

Because the object is documented as obsolete and not implemented in the target database, references to it should be validated against the actual dictionary before deployment. In environments where it does not exist, equivalent results can be obtained by querying OKR_IP_RGTS_TXN_LANG directly and applying OKR_UTIL_PUB.GET_LU_MEANING('OKR_IP_LANGUAGE', language_code) manually. This view should not be relied upon for new development on 12.1.1 or 12.2.2.