[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DIVAT.ID ID
, DIVAB.DIMENSION_CODE DIMENSION_CODE
, DIVAT.DIMENSION_VALUE DIMENSION_VALUE
, DIVAB.START_DATE_ACTIVE START_DATE_ACTIVE
, DIVAT.SFWT_FLAG SFWT_FLAG
, DIVAB.END_DATE_ACTIVE END_DATE_ACTIVE
, DIVAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DIVAB.CREATED_BY CREATED_BY
, DIVAB.CREATION_DATE CREATION_DATE
, DIVAB.LAST_UPDATED_BY LAST_UPDATED_BY
, DIVAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DIVAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DIVAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DIVAB.ATTRIBUTE1 ATTRIBUTE1
, DIVAB.ATTRIBUTE2 ATTRIBUTE2
, DIVAB.ATTRIBUTE3 ATTRIBUTE3
, DIVAB.ATTRIBUTE4 ATTRIBUTE4
, DIVAB.ATTRIBUTE5 ATTRIBUTE5
, DIVAB.ATTRIBUTE6 ATTRIBUTE6
, DIVAB.ATTRIBUTE7 ATTRIBUTE7
, DIVAB.ATTRIBUTE8 ATTRIBUTE8
, DIVAB.ATTRIBUTE9 ATTRIBUTE9
, DIVAB.ATTRIBUTE10 ATTRIBUTE10
, DIVAB.ATTRIBUTE11 ATTRIBUTE11
, DIVAB.ATTRIBUTE12 ATTRIBUTE12
, DIVAB.ATTRIBUTE13 ATTRIBUTE13
, DIVAB.ATTRIBUTE14 ATTRIBUTE14
, DIVAB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_IP_UDEF_DIM_VAL_B DIVAB
, OKR_IP_UDEF_DIM_VAL_TL DIVAT
WHERE DIVAB.ID =DIVAT.ID
AND DIVAT.LANGUAGE = USERENV('LANG')