[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for table OKR_AWDS_WON_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AWNBB.ROWID ROW_ID
, AWNBB.AWN_ID AWN_ID
, AWNBB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AWNBT.SFWT_FLAG SFWT_FLAG
, AWNBB.AWARD_CODE AWARD_CODE
, AWNBB.PARTY_ID1 PARTY_ID1
, AWNBB.IP_ID IP_ID
, AWNBB.PARTY_ID2 PARTY_ID2
, AWNBB.AWARD_DATE AWARD_DATE
, AWNBT.COMMENTS COMMENTS
, AWNBB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AWNBB.ATTRIBUTE1 ATTRIBUTE1
, AWNBB.ATTRIBUTE2 ATTRIBUTE2
, AWNBB.ATTRIBUTE3 ATTRIBUTE3
, AWNBB.ATTRIBUTE4 ATTRIBUTE4
, AWNBB.ATTRIBUTE5 ATTRIBUTE5
, AWNBB.ATTRIBUTE6 ATTRIBUTE6
, AWNBB.ATTRIBUTE7 ATTRIBUTE7
, AWNBB.ATTRIBUTE8 ATTRIBUTE8
, AWNBB.ATTRIBUTE9 ATTRIBUTE9
, AWNBB.ATTRIBUTE10 ATTRIBUTE10
, AWNBB.ATTRIBUTE11 ATTRIBUTE11
, AWNBB.ATTRIBUTE12 ATTRIBUTE12
, AWNBB.ATTRIBUTE13 ATTRIBUTE13
, AWNBB.ATTRIBUTE14 ATTRIBUTE14
, AWNBB.ATTRIBUTE15 ATTRIBUTE15
, AWNBB.CREATION_DATE CREATION_DATE
, AWNBB.CREATED_BY CREATED_BY
, AWNBB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AWNBB.LAST_UPDATED_BY LAST_UPDATED_BY
, AWNBB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_IP_AWDS_WON_B AWNBB
, OKR_IP_AWDS_WON_TL AWNBT
WHERE AWNBB.AWN_ID = AWNBT.AWN_ID
AND AWNBT.LANGUAGE = USERENV('LANG')