View: OKC_SECTIONED_ARTICLES_V

Product:	OKC - Contracts Core
Description:	Used to get articles text from CLOBs
Implementation/DBA Data:	APPS.OKC_SECTIONED_ARTICLES_V

View Text

SELECT KART.SCN_ID
, KART.DISPLAY_SEQUENCE CONTENT_SEQUENCE
, KART.LABEL
, NVL(VERS.DISPLAY_NAME
, ART.ARTICLE_TITLE) NAME
, FND.MEANING SUBJECT
, VERS.ARTICLE_TEXT TEXT
FROM OKC_K_ARTICLES_B KART
, OKC_ARTICLES_V ART
, FND_LOOKUPS FND
, OKC_ARTICLE_VERSIONS VERS
WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
AND KART.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
AND KART.ARTICLE_VERSION_ID = ART.ARTICLE_VERSION_ID
AND FND.LOOKUP_TYPE = 'OKC_SUBJECT'
AND FND.LOOKUP_CODE = ART.ARTICLE_TYPE

Columns