Product: | OKC - Contracts Core |
---|---|
Description: | View for table OKC_ARTICLES_B |
Implementation/DBA Data: | APPS.OKC_ART_STANDARDS_V |
SELECT CATB.ROWID ROW_ID
, CATB.ID ID
, CATB.DOCUMENT_TYPE DOCUMENT_TYPE
, CATB.DOCUMENT_ID DOCUMENT_ID
, CATB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NULL SFWT_FLAG
, VERS.ARTICLE_ID SAV_SAE_ID
, NVL(VERS.SAV_RELEASE
, VERS. ARTICLE_VERSION_NUMBER) SAV_SAV_RELEASE
, CATB.CHR_ID CHR_ID
, CATB.CLE_ID CLE_ID
, CATB.CAT_ID CAT_ID
, CATB.DNZ_CHR_ID DNZ_CHR_ID
, VERS.ARTICLE_DESCRIPTION COMMENTS
, NVL(VERS.DISPLAY_NAME
, ART.ARTICLE_TITLE) NAME
, CATB.FULLTEXT_YN FULLTEXT_YN
, VERS.VARIATION_DESCRIPTION VARIATION_DESCRIPTION
, VERS.ARTICLE_TEXT TEXT
, CATB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CATB.ATTRIBUTE1 ATTRIBUTE1
, CATB.ATTRIBUTE2 ATTRIBUTE2
, CATB.ATTRIBUTE3 ATTRIBUTE3
, CATB.ATTRIBUTE4 ATTRIBUTE4
, CATB.ATTRIBUTE5 ATTRIBUTE5
, CATB.ATTRIBUTE6 ATTRIBUTE6
, CATB.ATTRIBUTE7 ATTRIBUTE7
, CATB.ATTRIBUTE8 ATTRIBUTE8
, CATB.ATTRIBUTE9 ATTRIBUTE9
, CATB.ATTRIBUTE10 ATTRIBUTE10
, CATB.ATTRIBUTE11 ATTRIBUTE11
, CATB.ATTRIBUTE12 ATTRIBUTE12
, CATB.ATTRIBUTE13 ATTRIBUTE13
, CATB.ATTRIBUTE14 ATTRIBUTE14
, CATB.ATTRIBUTE15 ATTRIBUTE15
, CATB.CREATED_BY CREATED_BY
, CATB.CREATION_DATE CREATION_DATE
, CATB.LAST_UPDATED_BY LAST_UPDATED_BY
, CATB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CATB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_ARTICLES_B CATB
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS VERS
WHERE CATB.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
AND CATB.SAV_SAE_ID = ART.ARTICLE_ID
AND ART.STANDARD_YN = 'Y'