[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | History view on OKR_K_ARTICLES |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CABH.ROWID ROW_ID
, CABH.ID ID
, CABH.MAJOR_VERSION
, CABH.CHR_ID CHR_ID
, CABH.CLE_ID CLE_ID
, CABH.CAT_ID CAT_ID
, CABH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CATH.SFWT_FLAG SFWT_FLAG
, CABH.SAV_SAE_ID SAV_SAE_ID
, CATH.SAV_SAV_RELEASE SAV_SAV_RELEASE
, CABH.SBT_CODE SBT_CODE
, CABH.DNZ_CHR_ID DNZ_CHR_ID
, CATH.COMMENTS COMMENTS
, CABH.FULLTEXT_YN FULLTEXT_YN
, CATH.VARIATION_DESCRIPTION VARIATION_DESCRIPTION
, CATH.NAME NAME
, OKR_DATATYPE_UTIL_PUB.OKR_CLOB_TO_VC(CATH.TEXT) TEXT
, CABH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CABH.ATTRIBUTE1 ATTRIBUTE1
, CABH.ATTRIBUTE2 ATTRIBUTE2
, CABH.ATTRIBUTE3 ATTRIBUTE3
, CABH.ATTRIBUTE4 ATTRIBUTE4
, CABH.ATTRIBUTE5 ATTRIBUTE5
, CABH.ATTRIBUTE6 ATTRIBUTE6
, CABH.ATTRIBUTE7 ATTRIBUTE7
, CABH.ATTRIBUTE8 ATTRIBUTE8
, CABH.ATTRIBUTE9 ATTRIBUTE9
, CABH.ATTRIBUTE10 ATTRIBUTE10
, CABH.ATTRIBUTE11 ATTRIBUTE11
, CABH.ATTRIBUTE12 ATTRIBUTE12
, CABH.ATTRIBUTE13 ATTRIBUTE13
, CABH.ATTRIBUTE14 ATTRIBUTE14
, CABH.ATTRIBUTE15 ATTRIBUTE15
, CABH.CAT_TYPE CAT_TYPE
, CABH.CREATED_BY CREATED_BY
, CABH.CREATION_DATE CREATION_DATE
, CABH.LAST_UPDATED_BY LAST_UPDATED_BY
, CABH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CABH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_ARTICLES_BH CABH
, OKC_K_ARTICLES_TLH CATH
WHERE CABH.ID = CATH.ID
AND CATH.LANGUAGE = USERENV('LANG')