View: OKC_ARTICLES_V

Product:	OKC - Contracts Core
Description:	This View is based on tables OKC_ARTICLES_ALL and OKC_ARTICLE_VERSIONS.
Implementation/DBA Data:	APPS.OKC_ARTICLES_V

View Text

SELECT AA.ARTICLE_ID
, AA.ARTICLE_TITLE
, AA.ORG_ID
, AA.ARTICLE_NUMBER
, AA.STANDARD_YN
, AA.ARTICLE_INTENT
, AA.ARTICLE_LANGUAGE
, AA.ARTICLE_TYPE
, AA.ORIG_SYSTEM_REFERENCE_CODE
, AA.ORIG_SYSTEM_REFERENCE_ID1
, AA.ORIG_SYSTEM_REFERENCE_ID2
, AA.CZ_TRANSFER_STATUS_FLAG
, AV.ARTICLE_VERSION_ID
, AV.ARTICLE_VERSION_NUMBER
, AV.ARTICLE_TEXT
, AV.PROVISION_YN
, AV.INSERT_BY_REFERENCE
, AV.LOCK_TEXT
, AV.GLOBAL_YN
, AV.ARTICLE_STATUS
, AV.SAV_RELEASE
, AV.START_DATE
, AV.END_DATE
, AV.ADOPTION_TYPE
, AV.STD_ARTICLE_VERSION_ID
, AV.DISPLAY_NAME
, AV.TRANSLATED_YN
, AV.ARTICLE_DESCRIPTION
, AV.DATE_APPROVED
, AV.DEFAULT_SECTION
, AV.REFERENCE_SOURCE
, AV.REFERENCE_TEXT
, AV.ORIG_SYSTEM_REFERENCE_CODE
, AV.ORIG_SYSTEM_REFERENCE_ID1
, AV.ORIG_SYSTEM_REFERENCE_ID2
, AV.ADDITIONAL_INSTRUCTIONS
, AV.VARIATION_DESCRIPTION
, AV.ATTRIBUTE_CATEGORY
, AV.ATTRIBUTE1
, AV.ATTRIBUTE2
, AV.ATTRIBUTE3
, AV.ATTRIBUTE4
, AV.ATTRIBUTE5
, AV.ATTRIBUTE6
, AV.ATTRIBUTE7
, AV.ATTRIBUTE8
, AV.ATTRIBUTE9
, AV.ATTRIBUTE10
, AV.ATTRIBUTE11
, AV.ATTRIBUTE12
, AV.ATTRIBUTE13
, AV.ATTRIBUTE14
, AV.ATTRIBUTE15
, AV.EDITED_IN_WORD
, AV.ARTICLE_TEXT_IN_WORD
, AV.VARIABLE_CODE
FROM OKC_ARTICLES_ALL AA
, OKC_ARTICLE_VERSIONS AV
WHERE AA.ARTICLE_ID = AV.ARTICLE_ID

Columns