View: OKC_STD_ARTICLES_V

Product:	OKC - Contracts Core
Description:	Backward compatible View for table OKC_ARTICLES_ALL
Implementation/DBA Data:	APPS.OKC_STD_ARTICLES_V

View Text

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 ( ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) OR EXISTS (SELECT 1
FROM OKC_ARTICLE_VERSIONS VER
, OKC_ARTICLE_ADOPTIONS ADP
WHERE VER.ARTICLE_VERSION_ID = ADP.GLOBAL_ARTICLE_VERSION_ID
AND VER.ARTICLE_ID = ART.ARTICLE_ID
AND ADP. LOCAL_ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) )

Columns