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