Search Results show_details_flag




Overview
Explore in AI Chat

Overview

OKC_TERMS_ALTERNATE_ART_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKC – Contracts Core product family. It presents alternate article relationships defined against contract or template articles, resolving each relationship to the latest applicable article version. The view consolidates data from the article master, the relationship table, the base contract article assignment table, and the version table, and it derives additional display attributes through calls to OKC_TERMS_UTIL_PVT.

The view is primarily used by the Terms and Conditions authoring and clause-selection user interfaces, where users select substitute or alternate clauses during contract generation. Because it exposes both a normalized relationship path and a set of "current" article rows, it serves as both a reporting source and an integration point for downstream contract assembly logic. The column INSTRUCTION_TEXT is a truncated representation of ADDITIONAL_INSTRUCTIONS from OKC_ARTICLE_VERSIONS, capped at 2,000 characters via SUBSTR, and is returned for every row produced by the view's UNION ALL branches.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the view as referencing the following base objects, all exposed as synonyms in the APPS schema:

The view is defined as a UNION ALL of multiple branches. The first branch resolves alternates through OKC_ARTICLE_RELATNS_ALL; subsequent branches surface current articles directly from OKC_K_ARTICLES_B. Rows are tagged with literal flags such as CURRENT_ARTICLE_FLAG ('CURRENTDISABLED' or 'CURRENTENABLED') and SHOW_DETAILS_FLAG ('N') to signal the row's role to the calling application.

Key Columns

  • ALT_ARTICLE_ID / ALT_ARTICLE_NAME – identifier and title of the alternate (target) article.
  • DISPLAY_NAME – the display label of the resolved article version.
  • LATEST_ARTICLE_VERSION_ID – the version identifier returned by OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_ID for the article, document type, and document.
  • ARTICLE_DESCRIPTION – the first 100 characters of the version description.
  • ARTICLE_TEXT – up to 2,000 characters of the article body, extracted with DBMS_LOB.SUBSTR.
  • INSTRUCTION_TEXT – up to 2,000 characters of ADDITIONAL_INSTRUCTIONS, the authoring guidance attached to the article version.
  • RELATIONSHIP_ORG_ID / ORG_ID – the operating unit context of the relationship row; NULL in the current-article branch.
  • KARTICLES_ID / CAT_ID, DOCUMENT_TYPE, DOCUMENT_ID, OBJECT_VERSION_NUMBER – the owning contract article record and its document context.
  • CURRENT_ARTICLE_FLAG, SHOW_DETAILS_FLAG – control flags consumed by the Terms UI.

Common Use Cases and Queries

Typical scenarios include retrieving alternate clauses for a contract, validating which alternates are provision-enabled, and extracting authoring instructions for display or documentation. The following query returns alternates and their instruction text for a given document:

SELECT alt_article_name, display_name, latest_article_version_id, instruction_text FROM okc_terms_alternate_art_v WHERE document_type = :p_doc_type AND document_id = :p_doc_id AND current_article_flag = 'CURRENTDISABLED';

To locate alternates carrying specific authoring guidance, filter on INSTRUCTION_TEXT:

SELECT document_id, alt_article_name, SUBSTR(instruction_text, 1, 200) instr FROM okc_terms_alternate_art_v WHERE UPPER(instruction_text) LIKE '%REQUIRED%' ORDER BY document_id, alt_article_name;

Because the view applies ORG_ID filtering through OKC_TERMS_UTIL_PVT.GET_CURRENT_ORG_ID in its first branch, and because version resolution depends on the utility package, queries should supply valid DOCUMENT_TYPE and DOCUMENT_ID values and account for the possibility of NULL ORG_ID on current-article rows. Join results back to OKC_K_ARTICLES_B on KARTICLES_ID when a full contract context is required.