[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IDB.ROWID ROW_ID
, IDB.IP_ID IP_ID
, IDB.INVENTION_OID INVENTION_OID
, IDT.PROBLEM_DESCRIPTION PROBLEM_DESCRIPTION
, IDT.SOLUTION SOLUTION
, IDT.ADVANTAGES ADVANTAGES
, IDT.DISADVANTAGES DISADVANTAGES
, IDT.COMPETETIVE_SIGNIFICANCE COMPETETIVE_SIGNIFICANCE
, IDB.SUBMITTED_YN SUBMITTED_YN
, IDB.IMPLEMENTED_YN IMPLEMENTED_YN
, IDT.IMPLEMENTATION_TIMEFRAME IMPLEMENTATION_TIMEFRAME
, IDT.CONCEPTION_TIMEFRAME CONCEPTION_TIMEFRAME
, IDT.CONCEPTION_DETAILS CONCEPTION_DETAILS
, IDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IDB.CREATED_BY CREATED_BY
, IDB.CREATION_DATE CREATION_DATE
, IDB.LAST_UPDATED_BY LAST_UPDATED_BY
, IDT.SFWT_FLAG SFWT_FLAG
, IDB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IDB.ATTRIBUTE1 ATTRIBUTE1
, IDB.ATTRIBUTE2 ATTRIBUTE2
, IDB.ATTRIBUTE3 ATTRIBUTE3
, IDB.ATTRIBUTE4 ATTRIBUTE4
, IDB.ATTRIBUTE5 ATTRIBUTE5
, IDB.ATTRIBUTE6 ATTRIBUTE6
, IDB.ATTRIBUTE7 ATTRIBUTE7
, IDB.ATTRIBUTE8 ATTRIBUTE8
, IDB.ATTRIBUTE9 ATTRIBUTE9
, IDB.ATTRIBUTE10 ATTRIBUTE10
, IDB.ATTRIBUTE11 ATTRIBUTE11
, IDB.ATTRIBUTE12 ATTRIBUTE12
, IDB.ATTRIBUTE13 ATTRIBUTE13
, IDB.ATTRIBUTE14 ATTRIBUTE14
, IDB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_IP_INVENT_DISC_B IDB
, OKR_IP_INVENT_DISC_TL IDT
WHERE IDB.IP_ID = IDT.IP_ID
AND IDT.LANGUAGE = USERENV('LANG')