eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKC.OKC_ARTICLE_VERSIONS

Object Details

Object Name:	OKC_ARTICLE_VERSIONS
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_ARTICLE_VERSIONS
Subobject Name:
Status:	VALID

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 OKC_STD_ART_VERSIONS available in releases prior to 11.5.10. Furthermore, the non- standard clause text in OKC_K_ARTICLES_TL is migrated to this table as a part of 11.5.10 migration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_ARTICLE_VERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ARTICLE_VERSION_ID
OKC_ARTICLE_VERSIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ARTICLE_ID ARTICLE_VERSION_NUMBER
SYS_IL0000329298C00005$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000329298C00056$$	LOB	UNIQUE	APPS_TS_TX_DATA
OKC_ARTICLES_CTX	DOMAIN	NONUNIQUE		ARTICLE_TEXT
OKC_ARTICLE_VERSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID2
OKC_ARTICLE_VERSIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE
OKC_ARTICLE_VERSIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
OKC_ARTICLE_VERSIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STD_ARTICLE_VERSION_ID
OKC_ARTICLE_VERSIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARTICLE_STATUS PROGRAM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ARTICLE_VERSION_ID	NUMBER		Yes	System generated Primary Key.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
ARTICLE_ID	NUMBER		Yes	This references the Clause for which this version is created. Foreign Key to OKC_ARTICLES_ALL.
ARTICLE_VERSION_NUMBER	NUMBER		Yes	This is the system generated version number of the clause. Sequence begins at 1.
ARTICLE_TEXT	CLOB	(4000)	Yes	This is the textual content of the clause including the embedded variables.
PROVISION_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether the clause is provision or not i.e. if Y then Provision, if N then Clause.
INSERT_BY_REFERENCE	VARCHAR2	(1)	Yes	Yes/No flag to determine the text that will be printed i.e. if Y then clause should be printed without the clause text, if N then the clause text is printed.
LOCK_TEXT	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether the clause text can be modified on a business document ( this flag determines whether user can modify a standard clause to create a non-standard clause).
GLOBAL_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether the clause is global or not i.e. if Y then Global , if N then Local.
ARTICLE_LANGUAGE	VARCHAR2	(4)	Yes	This is the language of the Clause. Same as that of OKC_ARTICLES_ALL as it is required for text index.
ARTICLE_STATUS	VARCHAR2	(30)		This is the status of standard clause. This is a foreign key to FND_LOOKUPS with LOOKUP_TYPE = OKC_ARTICLE_STATUS.
SAV_RELEASE	VARCHAR2	(50)		This is the user entered release label prior to 11.5.10. Kept for backward compatibility for migrated clauses.
START_DATE	DATE			This is the Effective Start Date of the Standard Clause Version.
END_DATE	DATE			This is the Effective End Date of the Standard Clause Version.
ADOPTION_TYPE	VARCHAR2	(30)		This is the adoption type of the local clause. It could either be LOCALIZED (same as the adoption type of OKC_ARTICLE_ADOPTIONS) or LOCAL.
STD_ARTICLE_VERSION_ID	NUMBER			This references the standard clause version that was modified to create a non-standard clause. This is a foreign key to OKC_ARTICLE_VERSIONS.
DISPLAY_NAME	VARCHAR2	(450)		This is the clause name that will be printed or displayed in a business document. If this column is not populated , the clause title will be used.
TRANSLATED_YN	VARCHAR2	(1)		Yes/No flag to indicate whether the clause is created as a translation of global clause or not.
ARTICLE_DESCRIPTION	VARCHAR2	(2000)		This is a short description of the Clause Version.
DATE_APPROVED	DATE			This is the approval date of the clause.
DEFAULT_SECTION	VARCHAR2	(30)		This is the default section to which the clause belongs. Foreign Key to FND_LOOKUPS where Lookup_Type = OKC_ARTICLE_SECTION.
REFERENCE_SOURCE	VARCHAR2	(150)		This is the reference source of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
REFERENCE_TEXT	VARCHAR2	(2000)		This is the reference text of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)		This column is used to preserve the code for the migrated system.
ORIG_SYSTEM_REFERENCE_ID1	VARCHAR2	(100)		This column is used to preserve the identifier1 for the migrated system.
ORIG_SYSTEM_REFERENCE_ID2	VARCHAR2	(100)		This column is used to preserve the identifier2 for the migrated system.
ADDITIONAL_INSTRUCTIONS	VARCHAR2	(2000)		This column stores any additional instructions that are needed for using the Clause Version.
VARIATION_DESCRIPTION	VARCHAR2	(240)		This is used in the case of non-standard clauses to enter variations from Standard Clauses prior to 11.5.10. This column is kept for backward compatibility.
CREATED_BY	NUMBER		Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.
PROGRAM_ID	NUMBER			Standard Concurrent Program Column.
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Program Column.
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Program Column.
REQUEST_ID	NUMBER			Standard Concurrent Program Column.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield category column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
DATE_PUBLISHED	DATE			Date the clause was published , specifically used for XML based Clause Import
EDITED_IN_WORD	VARCHAR2	(1)
ARTICLE_TEXT_IN_WORD	BLOB	(4000)
VARIABLE_CODE	VARCHAR2	(150)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ARTICLE_VERSION_ID
,      OBJECT_VERSION_NUMBER
,      ARTICLE_ID
,      ARTICLE_VERSION_NUMBER
,      ARTICLE_TEXT
,      PROVISION_YN
,      INSERT_BY_REFERENCE
,      LOCK_TEXT
,      GLOBAL_YN
,      ARTICLE_LANGUAGE
,      ARTICLE_STATUS
,      SAV_RELEASE
,      START_DATE
,      END_DATE
,      ADOPTION_TYPE
,      STD_ARTICLE_VERSION_ID
,      DISPLAY_NAME
,      TRANSLATED_YN
,      ARTICLE_DESCRIPTION
,      DATE_APPROVED
,      DEFAULT_SECTION
,      REFERENCE_SOURCE
,      REFERENCE_TEXT
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      ADDITIONAL_INSTRUCTIONS
,      VARIATION_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_LOGIN_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DATE_PUBLISHED
,      EDITED_IN_WORD
,      ARTICLE_TEXT_IN_WORD
,      VARIABLE_CODE
FROM OKC.OKC_ARTICLE_VERSIONS;

Dependencies

[top of page]

OKC.OKC_ARTICLE_VERSIONS does not reference any database object

OKC.OKC_ARTICLE_VERSIONS is referenced by following:

OKC: OKC_ARTICLE_VERSIONS#