Search Results current_article_flag

Overview

The view APPS.OKC_TERMS_ALTERNATE_ART_V is a dictionary object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and registered under the FND Design Data path OKC.OKC_TERMS_ALTERNATE_ART_V. Its status is VALID, and it is classified as an internal view that Oracle Corporation supports only when accessed through standard Oracle Applications programs. The view presents alternate article information associated with contract terms, exposing both article metadata and the latest article version details in a single flattened row set. It serves reporting and integration scenarios where consumers need to enumerate alternate article clauses, identify the current published version, and inspect article body text without joining the underlying ETRM (Enterprise Contract and Terms Management) article tables directly. The presence of the CURRENT_ARTICLE_FLAG column, which the user searched for, allows downstream reports to distinguish the active version of an article from historical versions in the same result set.

Underlying Base Objects

According to the documented metadata, APPS.OKC_TERMS_ALTERNATE_ART_V references the following base objects:

• OKC_ARTICLES_ALL — master article definitions.
• OKC_ARTICLE_RELATNS_ALL — relationships between articles and related entities.
• OKC_ARTICLE_VERSIONS — versioned article content, including text and description.
• OKC_BUS_DOC_TYPES_B — business document type definitions.
• OKC_K_ARTICLES_B — contract article associations.
• OKC_TERMS_UTIL_PVT — the ETRM terms utility package, used to derive computed columns such as display and instruction text.

Each of these dependencies is a synonym resolving to the corresponding ETRM base table or package. The view is not referenced by any other database object, confirming that it exists as a terminal reporting construct rather than an intermediate dependency for other ETRM views. Its internal (non-supported) view type underscores that direct SQL against it should be treated as read-only reporting and not as an application extension point.

Key Columns

• ALT_ARTICLE_ID (NUMBER) — primary identifier for the alternate article record.
• ALT_ARTICLE_NAME and DISPLAY_NAME (VARCHAR2 450) — the article name and its user-facing display label.
• ALT_ART_LATEST_VERSION_ID (NUMBER) — foreign key to the newest version record in OKC_ARTICLE_VERSIONS.
• ARTICLE_DESCRIPTION (VARCHAR2 100) and ARTICLE_TEXT (CLOB) — short description and full clause text.
• INSTRUCTION_TEXT (VARCHAR2 1000) — guidance text presented to the user during term entry.
• RELATIONSHIP_ORG_ID (NUMBER) — operating unit context for the article relationship.
• KARTICLES_ID (NUMBER) — identifier linking to the contract article association.
• DOCUMENT_TYPE (VARCHAR2 30) and DOCUMENT_ID (NUMBER) — the business document type and its identifier.
• OBJECT_VERSION_NUMBER (NUMBER) — concurrency control version for the row.
• CURRENT_ARTICLE_FLAG (VARCHAR2 15) — indicates whether the row represents the current article version.
• SHOW_DETAILS_FLAG (CHAR) — controls whether expanded details are displayed.

Common Use Cases and Queries

A frequent requirement is to list only the active alternate articles for a given organization, filtering on the current version indicator. For example:

SELECT alt_article_name, display_name, article_description
FROM APPS.OKC_TERMS_ALTERNATE_ART_V
WHERE current_article_flag = 'Y'
AND relationship_org_id = :org_id
ORDER BY alt_article_name;

Another common scenario is retrieving full text for a specific document context:

SELECT document_type, document_id, article_text, instruction_text
FROM APPS.OKC_TERMS_ALTERNATE_ART_V
WHERE document_type = :doc_type
AND document_id = :doc_id;

Because the view is internal and not supported for direct integration, any such queries should be limited to diagnostics, data extraction, or reporting layers, with the understanding that the structure is subject to change across EBS releases.