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