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