VIEW: APPS.OKC_ARTICLES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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