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
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
|
|
|