View: OKC_SECTION_CONTENTS_HV

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_SECTION_CONTENTS_HV

View Text

SELECT SCC.ID ID
, SCC.MAJOR_VERSION MAJOR_VERSION
, SCC.SCN_ID SCN_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
, 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
, '' 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_BH SCC
WHERE SCC.SAV_SAE_ID = ART.ARTICLE_ID

Columns