FND Design Data [Home] [Help]

Table: OKC_ARTICLE_VERSIONS

Product: OKC - Contracts Core
Description: This table stores all the versions of a standard clause and non-standard clause created on a business document. Standard Clauses have multiple versions while the non-standard clauses are created as a single version. This table replaces the
Implementation/DBA Data: TableOKC.OKC_ARTICLE_VERSIONS
Primary Key: OKC_ARTICLE_VERSIONS_PK1
  1. ColumnARTICLE_VERSION_ID
Primary Key: OKC_ARTICLE_VERSIONS_UK1
  1. ColumnARTICLE_ID
  2. ColumnARTICLE_VERSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
OKC_ARTICLE_VERSIONS FK Joins to TableOKC_ARTICLES_ALL OKC_ARTICLE_VERSIONS.ARTICLE_ID
OKC_ARTICLE_VERSIONS FK Joins to TableOKC_ARTICLE_VERSIONS OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID
TableOKC_ARTICLE_ADOPTIONS FK Joins to OKC_ARTICLE_VERSIONS OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID
TableOKC_ARTICLE_ADOPTIONS FK Joins to OKC_ARTICLE_VERSIONS OKC_ARTICLE_ADOPTIONS.LOCAL_ARTICLE_VERSION_ID
TableOKC_ARTICLE_VARIABLES FK Joins to OKC_ARTICLE_VERSIONS OKC_ARTICLE_VARIABLES.ARTICLE_VERSION_ID
TableOKC_ARTICLE_VERSIONS FK Joins to OKC_ARTICLE_VERSIONS OKC_ARTICLE_VERSIONS.STD_ARTICLE_VERSION_ID
TableOKC_K_ARTICLES_B FK Joins to OKC_ARTICLE_VERSIONS OKC_K_ARTICLES_B.ARTICLE_VERSION_ID
TableOKC_K_ARTICLES_B FK Joins to OKC_ARTICLE_VERSIONS OKC_K_ARTICLES_B.REF_ARTICLE_VERSION_ID