Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | View for OKR_RESPONSE_SET_B and OKR_RESPONSE_SET_TL |
Implementation/DBA Data: | Not implemented in this database |
SELECT RPSB.ROWID
, RPSB.ID ID
, RPSB.IP_TYPE IP_TYPE
, RPST.NAME NAME
, RPST.DESCRIPTION DESCRIPTION
, RPSB.START_DATE_ACTIVE START_DATE_ACTIVE
, RPSB.END_DATE_ACTIVE END_DATE_ACTIVE
, RPST.SFWT_FLAG SFWT_FLAG
, RPSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RPSB.CREATED_BY CREATED_BY
, RPST.CREATION_DATE CREATION_DATE
, RPSB.LAST_UPDATED_BY LAST_UPDATED_BY
, RPSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RPSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RPSB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RPSB.ATTRIBUTE1 ATTRIBUTE1
, RPSB.ATTRIBUTE2 ATTRIBUTE2
, RPSB.ATTRIBUTE3 ATTRIBUTE3
, RPSB.ATTRIBUTE4 ATTRIBUTE4
, RPSB.ATTRIBUTE5 ATTRIBUTE5
, RPSB.ATTRIBUTE6 ATTRIBUTE6
, RPSB.ATTRIBUTE7 ATTRIBUTE7
, RPSB.ATTRIBUTE8 ATTRIBUTE8
, RPSB.ATTRIBUTE9 ATTRIBUTE9
, RPSB.ATTRIBUTE10 ATTRIBUTE10
, RPSB.ATTRIBUTE11 ATTRIBUTE11
, RPSB.ATTRIBUTE12 ATTRIBUTE12
, RPSB.ATTRIBUTE13 ATTRIBUTE13
, RPSB.ATTRIBUTE14 ATTRIBUTE14
, RPSB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_PROP_RESP_SET_TL RPST
, OKR_PROP_RESP_SET_B RPSB
WHERE RPSB.ID = RPST.ID
AND RPST.LANGUAGE = USERENV('LANG')