VIEW: APPS.OKC_TERMS_ART_DETAILS_V

Source

View Text - Preformatted

SELECT KART.ID,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,NVL(AV.PROVISION_YN,'N'), 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,KART.MANDATORY_YN,KART.AMENDMENT_DESCRIPTION, KART.AMENDMENT_OPERATION_CODE,NVL(KART.PRINT_TEXT_YN,'N'), KART.CHANGE_NONSTD_YN,KART.OBJECT_VERSION_NUMBER,KART.CREATED_BY, KART.CREATION_DATE,KART.LAST_UPDATED_BY,KART.LAST_UPDATE_DATE, KART.LAST_UPDATE_LOGIN,KART.SUMMARY_AMEND_OPERATION_CODE,AV.EDITED_IN_WORD,AV.ARTICLE_TEXT_IN_WORD FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV,OKC_K_ARTICLES_B KART WHERE AA.ARTICLE_ID = AV.ARTICLE_ID AND KART.SAV_SAE_ID = AA.ARTICLE_ID

View Text - HTML Formatted

SELECT KART.ID
, 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
, NVL(AV.PROVISION_YN
, 'N')
, 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
, KART.MANDATORY_YN
, KART.AMENDMENT_DESCRIPTION
, KART.AMENDMENT_OPERATION_CODE
, NVL(KART.PRINT_TEXT_YN
, 'N')
, KART.CHANGE_NONSTD_YN
, KART.OBJECT_VERSION_NUMBER
, KART.CREATED_BY
, KART.CREATION_DATE
, KART.LAST_UPDATED_BY
, KART.LAST_UPDATE_DATE
, KART.LAST_UPDATE_LOGIN
, KART.SUMMARY_AMEND_OPERATION_CODE
, AV.EDITED_IN_WORD
, AV.ARTICLE_TEXT_IN_WORD
FROM OKC_ARTICLES_ALL AA
, OKC_ARTICLE_VERSIONS AV
, OKC_K_ARTICLES_B KART
WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
AND KART.SAV_SAE_ID = AA.ARTICLE_ID