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