[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TMRB.ROWID ROW_ID
, TMRB.ID ID
, TMRB.CHR_ID CHR_ID
, TMRB.IP_ID IP_ID
, TMRB.VAL_PTRT_ID VAL_PTRT_ID
, TMRB.RGTP_ID RGTP_ID
, TMRT.NAME NAME
, TMRT.DESCRIPTION DESCRIPTION
, TMRT.KEYWORD_TEXT KEYWORD_TEXT
, TMRB.START_DATE_ACTIVE START_DATE_ACTIVE
, TMRB.END_DATE_ACTIVE END_DATE_ACTIVE
, TMRT.SFWT_FLAG SFWT_FLAG
, TMRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TMRB.CREATED_BY CREATED_BY
, TMRB.CREATION_DATE CREATION_DATE
, TMRB.LAST_UPDATED_BY LAST_UPDATED_BY
, TMRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TMRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TMRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TMRB.ATTRIBUTE1 ATTRIBUTE1
, TMRB.ATTRIBUTE2 ATTRIBUTE2
, TMRB.ATTRIBUTE3 ATTRIBUTE3
, TMRB.ATTRIBUTE4 ATTRIBUTE4
, TMRB.ATTRIBUTE5 ATTRIBUTE5
, TMRB.ATTRIBUTE6 ATTRIBUTE6
, TMRB.ATTRIBUTE7 ATTRIBUTE7
, TMRB.ATTRIBUTE8 ATTRIBUTE8
, TMRB.ATTRIBUTE9 ATTRIBTE9
, TMRB.ATTRIBUTE10 ATTRIBUTE10
, TMRB.ATTRIBUTE11 ATTRIBUTE11
, TMRB.ATTRIBUTE12 ATTRIBUTE12
, TMRB.ATTRIBUTE13 ATTRIBUTE13
, TMRB.ATTRIBUTE14 ATTRIBUTE14
, TMRB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_TEMPLATE_RGTS_B TMRB
, OKR_TEMPLATE_RGTS_TL TMRT
WHERE TMRB.ID = TMRT.ID
AND TMRT.LANGUAGE = USERENV('LANG')