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