[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for OKC_SECTIONS_BH/TLH |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SNHB.ROWID ROW_ID
, SNHB.ID ID
, SNHB.MAJOR_VERSION MAJOR_VERSION
, SNHB.SCN_TYPE SCN_TYPE
, SNHB.CHR_ID CHR_ID
, SNHB.SAT_CODE SAT_CODE
, SNHB.SECTION_SEQUENCE SECTION_SEQUENCE
, SNHB.LABEL LABEL
, SCNTH.HEADING HEADING
, SNHB.SCN_ID SCN_ID
, SNHB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SCNTH.SFWT_FLAG SFWT_FLAG
, SNHB.CREATED_BY CREATED_BY
, SNHB.CREATION_DATE CREATION_DATE
, SNHB.LAST_UPDATED_BY LAST_UPDATED_BY
, SNHB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SNHB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SNHB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SNHB.ATTRIBUTE1 ATTRIBUTE1
, SNHB.ATTRIBUTE2 ATTRIBUTE2
, SNHB.ATTRIBUTE3 ATTRIBUTE3
, SNHB.ATTRIBUTE4 ATTRIBUTE4
, SNHB.ATTRIBUTE5 ATTRIBUTE5
, SNHB.ATTRIBUTE6 ATTRIBUTE6
, SNHB.ATTRIBUTE7 ATTRIBUTE7
, SNHB.ATTRIBUTE8 ATTRIBUTE8
, SNHB.ATTRIBUTE9 ATTRIBUTE9
, SNHB.ATTRIBUTE10 ATTRIBUTE10
, SNHB.ATTRIBUTE11 ATTRIBUTE11
, SNHB.ATTRIBUTE12 ATTRIBUTE12
, SNHB.ATTRIBUTE13 ATTRIBUTE13
, SNHB.ATTRIBUTE14 ATTRIBUTE14
, SNHB.ATTRIBUTE15 ATTRIBUTE15
FROM OKC_SECTIONS_TLH SCNTH
, OKC_SECTIONS_BH SNHB
WHERE SNHB.ID = SCNTH.ID
AND SCNTH.LANGUAGE = USERENV('LANG')