VIEW: APPS.OKC_SECTION_CONTENTS_V

Source

View Text - Preformatted

SELECT SCC.ROWID ROW_ID, SCC.ID ID, SCC.SCN_ID SCN_ID, SCC.LABEL LABEL, SCC.ID CAT_ID, SCC.CLE_ID CLE_ID, DECODE( ART.STANDARD_YN, 'Y', SCC.SAV_SAE_ID, SCC.REF_ARTICLE_ID) SAE_ID, SCC.DISPLAY_SEQUENCE CONTENT_SEQUENCE, SCC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SCC.CREATED_BY CREATED_BY, SCC.CREATION_DATE CREATION_DATE, SCC.LAST_UPDATED_BY LAST_UPDATED_BY, SCC.LAST_UPDATE_DATE LAST_UPDATE_DATE, SCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, '' ATTRIBUTE_CATEGORY, '' ATTRIBUTE1, '' ATTRIBUTE2, '' ATTRIBUTE3, '' ATTRIBUTE4, '' ATTRIBUTE5, '' ATTRIBUTE6, '' ATTRIBUTE7, '' ATTRIBUTE8, '' ATTRIBUTE9, '' ATTRIBUTE10, '' ATTRIBUTE11, '' ATTRIBUTE12, '' ATTRIBUTE13, '' ATTRIBUTE14, '' ATTRIBUTE15 FROM OKC_ARTICLES_ALL ART,OKC_K_ARTICLES_B SCC WHERE SCC.SAV_SAE_ID = ART.ARTICLE_ID

View Text - HTML Formatted

SELECT SCC.ROWID ROW_ID
, SCC.ID ID
, SCC.SCN_ID SCN_ID
, SCC.LABEL LABEL
, SCC.ID CAT_ID
, SCC.CLE_ID CLE_ID
, DECODE( ART.STANDARD_YN
, 'Y'
, SCC.SAV_SAE_ID
, SCC.REF_ARTICLE_ID) SAE_ID
, SCC.DISPLAY_SEQUENCE CONTENT_SEQUENCE
, SCC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SCC.CREATED_BY CREATED_BY
, SCC.CREATION_DATE CREATION_DATE
, SCC.LAST_UPDATED_BY LAST_UPDATED_BY
, SCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, '' ATTRIBUTE_CATEGORY
, '' ATTRIBUTE1
, '' ATTRIBUTE2
, '' ATTRIBUTE3
, '' ATTRIBUTE4
, '' ATTRIBUTE5
, '' ATTRIBUTE6
, '' ATTRIBUTE7
, '' ATTRIBUTE8
, '' ATTRIBUTE9
, '' ATTRIBUTE10
, '' ATTRIBUTE11
, '' ATTRIBUTE12
, '' ATTRIBUTE13
, '' ATTRIBUTE14
, '' ATTRIBUTE15
FROM OKC_ARTICLES_ALL ART
, OKC_K_ARTICLES_B SCC
WHERE SCC.SAV_SAE_ID = ART.ARTICLE_ID