View: OKR_SECTION_CONTENTS_V

View Text

SELECT SC.ROW_ID ROW_ID
, SC.ID ID
, ART.ID K_ART_ID
, ART.CHR_ID CHR_ID
, SC.SCN_ID
, SC.CAT_ID CAT_ID
, -99 SAE_ID
, '-99' SAV_RELEASE
, SC.LABEL LABEL
, SC.CONTENT_SEQUENCE CONTENT_SEQUENCE
, NVL(ART.NAME
, SAE.NAME) NAME
, OKR_DATATYPE_UTIL_PUB.OKR_CLOB_TO_VC(ART.TEXT) TEXT
, NULL VARIATION_TEXT
, FND.LOOKUP_CODE SBT_CODE
, FND.MEANING SUBJECT
, ART.CAT_TYPE ARTICLE_TYPE
, 'NON-STANDARD' ARTICLE_TYPE_MEANING
FROM OKC_SECTION_CONTENTS_V SC
, OKC_K_ARTICLES_V ART
, OKC_STD_ART_VERSIONS_V SAV
, OKC_STD_ARTICLES_V SAE
, FND_LOOKUPS FND
WHERE ART.ID = SC.CAT_ID
AND ART.TEXT IS NOT NULL
AND ART.CAT_TYPE = 'NSD'
AND ART.SAV_SAE_ID = SAV.SAE_ID (+)
AND ART.SAV_SAV_RELEASE = SAV.SAV_RELEASE (+)
AND SAV.SAE_ID = SAE.ID (+)
AND FND.LOOKUP_TYPE = 'OKC_SUBJECT'
AND FND.LOOKUP_CODE = NVL(ART.SBT_CODE
, SAE.SBT_CODE) UNION ALL SELECT SC.ROW_ID ROW_ID
, SC.ID ID
, ART.ID K_ART_ID
, ART.CHR_ID CHR_ID
, SC.SCN_ID
, SC.CAT_ID CAT_ID
, ART.SAV_SAE_ID SAE_ID
, ART.SAV_SAV_RELEASE SAV_RELEASE
, SC.LABEL LABEL
, SC.CONTENT_SEQUENCE CONTENT_SEQUENCE
, SAE.NAME
, OKR_DATATYPE_UTIL_PUB.OKR_CLOB_TO_VC(SAV.TEXT) TEXT
, OKR_DATATYPE_UTIL_PUB.OKR_CLOB_TO_VC(ART.TEXT) VARIATION_TEXT
, FND.LOOKUP_CODE SBT_CODE
, FND.MEANING SUBJECT
, ART.CAT_TYPE ARTICLE_TYPE
, 'STANDARD' ARTICLE_TYPE_MEANING
FROM OKC_SECTION_CONTENTS_V SC
, OKC_K_ARTICLES_V ART
, OKC_STD_ART_VERSIONS_V SAV
, OKC_STD_ARTICLES_V SAE
, FND_LOOKUPS FND
WHERE ART.ID = SC.CAT_ID
AND ART.CAT_TYPE = 'STA'
AND ART.SAV_SAE_ID = SAV.SAE_ID
AND ART.SAV_SAV_RELEASE = SAV.SAV_RELEASE
AND SAV.SAE_ID = SAE.ID
AND FND.LOOKUP_TYPE = 'OKC_SUBJECT'
AND FND.LOOKUP_CODE = SAE.SBT_CODE

Columns