VIEW: APPS.OKC_STD_ART_VERSIONS_V

Source

View Text - Preformatted

SELECT VER.ROWID ROW_ID , VER.ARTICLE_ID SAE_ID , NVL(VER.SAV_RELEASE,TO_CHAR(VER.ARTICLE_VERSION_NUMBER)) SAV_RELEASE, VER.OBJECT_VERSION_NUMBER , 'N' SFWT_FLAG, VER.START_DATE DATE_ACTIVE , VER.ARTICLE_TEXT TEXT , VER.ARTICLE_DESCRIPTION SHORT_DESCRIPTION, VER.ARTICLE_STATUS ARTICLE_STATUS, VER.ATTRIBUTE_CATEGORY , VER.ATTRIBUTE1 , VER.ATTRIBUTE2 , VER.ATTRIBUTE3 , VER.ATTRIBUTE4 , VER.ATTRIBUTE5 , VER.ATTRIBUTE6 , VER.ATTRIBUTE7 , VER.ATTRIBUTE8 , VER.ATTRIBUTE9 , VER.ATTRIBUTE10 , VER.ATTRIBUTE11 , VER.ATTRIBUTE12 , VER.ATTRIBUTE13 , VER.ATTRIBUTE14 , VER.ATTRIBUTE15 , VER.CREATED_BY , VER.CREATION_DATE , VER.LAST_UPDATED_BY , VER.LAST_UPDATE_DATE , VER.LAST_UPDATE_LOGIN FROM OKC_ARTICLE_VERSIONS VER WHERE EXISTS (SELECT 1 FROM OKC_ARTICLES ART WHERE STANDARD_YN = 'Y' AND ART.ARTICLE_ID = VER.ARTICLE_ID UNION ALL SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID AND MO_GLOBAL.CHECK_ACCESS(ADP.LOCAL_ORG_ID) = 'Y')

View Text - HTML Formatted

SELECT VER.ROWID ROW_ID
, VER.ARTICLE_ID SAE_ID
, NVL(VER.SAV_RELEASE
, TO_CHAR(VER.ARTICLE_VERSION_NUMBER)) SAV_RELEASE
, VER.OBJECT_VERSION_NUMBER
, 'N' SFWT_FLAG
, VER.START_DATE DATE_ACTIVE
, VER.ARTICLE_TEXT TEXT
, VER.ARTICLE_DESCRIPTION SHORT_DESCRIPTION
, VER.ARTICLE_STATUS ARTICLE_STATUS
, VER.ATTRIBUTE_CATEGORY
, VER.ATTRIBUTE1
, VER.ATTRIBUTE2
, VER.ATTRIBUTE3
, VER.ATTRIBUTE4
, VER.ATTRIBUTE5
, VER.ATTRIBUTE6
, VER.ATTRIBUTE7
, VER.ATTRIBUTE8
, VER.ATTRIBUTE9
, VER.ATTRIBUTE10
, VER.ATTRIBUTE11
, VER.ATTRIBUTE12
, VER.ATTRIBUTE13
, VER.ATTRIBUTE14
, VER.ATTRIBUTE15
, VER.CREATED_BY
, VER.CREATION_DATE
, VER.LAST_UPDATED_BY
, VER.LAST_UPDATE_DATE
, VER.LAST_UPDATE_LOGIN
FROM OKC_ARTICLE_VERSIONS VER
WHERE EXISTS (SELECT 1
FROM OKC_ARTICLES ART
WHERE STANDARD_YN = 'Y'
AND ART.ARTICLE_ID = VER.ARTICLE_ID UNION ALL SELECT 1
FROM OKC_ARTICLE_ADOPTIONS ADP
WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
AND MO_GLOBAL.CHECK_ACCESS(ADP.LOCAL_ORG_ID) = 'Y')