VIEW: APPS.OKC_STD_ARTICLES_V

Source

View Text - Preformatted

SELECT ART.ROWID ROW_ID , ART.ARTICLE_ID ID , ART.OBJECT_VERSION_NUMBER, 'N' SFWT_FLAG, ART.ARTICLE_TYPE SBT_CODE, ART.ARTICLE_TITLE NAME, ART.ATTRIBUTE_CATEGORY , ART.ATTRIBUTE1 , ART.ATTRIBUTE2 , ART.ATTRIBUTE3 , ART.ATTRIBUTE4 , ART.ATTRIBUTE5 , ART.ATTRIBUTE6 , ART.ATTRIBUTE7 , ART.ATTRIBUTE8 , ART.ATTRIBUTE9 , ART.ATTRIBUTE10 , ART.ATTRIBUTE11 , ART.ATTRIBUTE12 , ART.ATTRIBUTE13 , ART.ATTRIBUTE14 , ART.ATTRIBUTE15 , ART.CREATED_BY , ART.CREATION_DATE , ART.LAST_UPDATED_BY , ART.LAST_UPDATE_DATE , ART.LAST_UPDATE_LOGIN FROM OKC_ARTICLES_ALL ART WHERE STANDARD_YN = 'Y' AND EXISTS (SELECT 1 FROM OKC_ARTICLES ART1 WHERE STANDARD_YN = 'Y' AND ART.ARTICLE_ID = ART1.ARTICLE_ID UNION ALL SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS VER WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID AND ART.ARTICLE_ID = VER.ARTICLE_ID AND MO_GLOBAL.CHECK_ACCESS(ADP.LOCAL_ORG_ID) = 'Y')

View Text - HTML Formatted

SELECT ART.ROWID ROW_ID
, ART.ARTICLE_ID ID
, ART.OBJECT_VERSION_NUMBER
, 'N' SFWT_FLAG
, ART.ARTICLE_TYPE SBT_CODE
, ART.ARTICLE_TITLE NAME
, ART.ATTRIBUTE_CATEGORY
, ART.ATTRIBUTE1
, ART.ATTRIBUTE2
, ART.ATTRIBUTE3
, ART.ATTRIBUTE4
, ART.ATTRIBUTE5
, ART.ATTRIBUTE6
, ART.ATTRIBUTE7
, ART.ATTRIBUTE8
, ART.ATTRIBUTE9
, ART.ATTRIBUTE10
, ART.ATTRIBUTE11
, ART.ATTRIBUTE12
, ART.ATTRIBUTE13
, ART.ATTRIBUTE14
, ART.ATTRIBUTE15
, ART.CREATED_BY
, ART.CREATION_DATE
, ART.LAST_UPDATED_BY
, ART.LAST_UPDATE_DATE
, ART.LAST_UPDATE_LOGIN
FROM OKC_ARTICLES_ALL ART
WHERE STANDARD_YN = 'Y'
AND EXISTS (SELECT 1
FROM OKC_ARTICLES ART1
WHERE STANDARD_YN = 'Y'
AND ART.ARTICLE_ID = ART1.ARTICLE_ID UNION ALL SELECT 1
FROM OKC_ARTICLE_ADOPTIONS ADP
, OKC_ARTICLE_VERSIONS VER
WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
AND ART.ARTICLE_ID = VER.ARTICLE_ID
AND MO_GLOBAL.CHECK_ACCESS(ADP.LOCAL_ORG_ID) = 'Y')