[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for OKR_RESP_VALUES_B and OKR_RESP_VALUES_TL |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RPVB.ROWID
, RPVB.ID ID
, RPVT.NAME NAME
, RPVT.DESCRIPTION DESCRIPTION
, RPVB.NUMERIC_VALUE NUMERIC_VALUE
, RPVB.RESP_SET_ID RESP_SET_ID
, RPVB.DETAIL_REQ_YN DETAIL_REQ_YN
, RPVB.START_DATE_ACTIVE START_DATE_ACTIVE
, RPVB.END_DATE_ACTIVE END_DATE_ACTIVE
, RPVT.SFWT_FLAG SFWT_FLAG
, RPVB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RPVB.CREATED_BY CREATED_BY
, RPVB.CREATION_DATE CREATION_DATE
, RPVB.LAST_UPDATED_BY LAST_UPDATED_BY
, RPVB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RPVB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RPVB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RPVB.ATTRIBUTE1 ATTRIBUTE1
, RPVB.ATTRIBUTE2 ATTRIBUTE2
, RPVB.ATTRIBUTE3 ATTRIBUTE3
, RPVB.ATTRIBUTE4 ATTRIBUTE4
, RPVB.ATTRIBUTE5 ATTRIBUTE5
, RPVB.ATTRIBUTE6 ATTRIBUTE6
, RPVB.ATTRIBUTE7 ATTRIBUTE7
, RPVB.ATTRIBUTE8 ATTRIBUTE8
, RPVB.ATTRIBUTE9 ATTRIBUTE9
, RPVB.ATTRIBUTE10 ATTRIBUTE10
, RPVB.ATTRIBUTE11 ATTRIBUTE11
, RPVB.ATTRIBUTE12 ATTRIBUTE12
, RPVB.ATTRIBUTE13 ATTRIBUTE13
, RPVB.ATTRIBUTE14 ATTRIBUTE14
, RPVB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_RESP_VALUES_TL RPVT
, OKR_RESP_VALUES_B RPVB
WHERE RPVB.ID =RPVT.ID
AND RPVT.LANGUAGE = USERENV('LANG')