Results for “okr_k_hdr_ip_dv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view OKR_K_HDR_IP_DV belongs to the Oracle EBS module OKR — Contracts for Rights, which is documented as an obsolete product in the ETRM repository. It is a denormalized, read-only database view that consolidates contract header, line, process, and rights-specific intellectual property (IP) attributes into a single flattened result set. The "_DV" suffix follows the EBS convention for a "detail view" used primarily for reporting and integration rather than for transactional data entry.

The view's principal role is to expose a contract-centric record that combines core contracting data from the OKC (Oracle Contracts Core) schema with expanded attributes such as termination reasons, quality checklist information, workflow process definitions, and the associated IP common translations from the OKR schema. By joining business and translation tables in one definition, it removes the need for downstream reports, extracts, and interfaces to reproduce these joins manually. The reference to OKC_PROCESS_DEFS_B — the search term that led to this object — confirms that the view surfaces process definition metadata (workflow process name, process usage, and translated description) alongside each contract header.

Because it draws on several base tables through outer and inner joins, the view behaves as a point-in-time, multi-table snapshot rather than a stored structure, and its output reflects the current state of the underlying rows at query time.

Underlying Base Objects

The ETRM metadata documents the view as defined over a specific set of base objects, referenced directly in the view text:

• OKC_K_HEADERS_B — the base contract header table, supplying identifier, number, dates, amounts, currency, status, and audit columns.
• OKC_K_HEADERS_TL — the translation table for contract headers, supplying the short description, long description, and comments.
• OKC_K_ITEMS and OKC_K_LINES_B — contract item and line structures used in the join path.
• OKR_IP_COMMON_TL — the translated IP common table, providing the IP identifier and IP name.
• OKC_PROCESS_DEFS_B and OKC_PROCESS_DEFS_TL — base and translated process definition tables, yielding the workflow process name, definition name, description, and usage.
• OKC_K_PROCESSES — the link table associating contracts with their processes, supplying the process identifier.
• OKC_QA_CHECK_LISTS_TL — the quality checklist translation table, supplying the checklist name and short description.

The view therefore acts as a bridge between the generic OKC contract tables and the OKR rights-specific extension tables, joining them on the contract header identifier and related keys.

Key Columns

Notable columns exposed by the view include:

• CHR_ID, CONTRACT_NUMBER, and VERSION — the contract identifier, contract number, and version returned by a utility function.
• START_DATE, END_DATE, and the period duration — temporal boundaries of the contract.
• ESTIMATED_AMOUNT and CURRENCY_CODE — value and currency of the contract.
• STS_CODE and STS_CODE_MEANING — the status code and its translated meaning.
• DATE_APPROVED, DATE_ISSUED, DATE_SIGNED, DATE_TERMINATED, DATETIME_CANCELLED, and DATE_RENEWED — lifecycle milestone dates.
• TRN_CODE — termination reason, with its lookup meaning.
• QCL_ID, QCL_CHECKLIST_NAME, and QCL_DESCRIPTION — quality checklist linkage.
• PDF_ID, PDF_NAME, PDF_DESCRIPTION, WF_PROCESS_NAME, and PDF_USAGE — the process definition attributes associated with the contract.
• IP_ID and IP_NAME — the intellectual property record linked via the translation table.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) inherited from the header base table.

Common Use Cases and Queries

Typical uses include reporting on active rights contracts, auditing process definitions attached to contracts, and extracting IP-linked contract detail for integration interfaces. A representative query retrieves contract header detail with its associated process definition:

SELECT CONTRACT_NUMBER, VERSION, START_DATE, END_DATE, STS_CODE_MEANING, WF_PROCESS_NAME, PDF_NAME, IP_NAME FROM OKR_K_HDR_IP_DV WHERE STS_CODE = 'ACTIVE';

Because the module is obsolete, implementers should verify availability in the target instance before relying on this view, and prefer direct queries against the base tables where the view is not implemented.