[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for table OKR_INTELL_PROPS_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IPYBB.ROWID
, IPYBB.IP_ID IP_ID
, IPYBB.IP_TYPE IP_TYPE
, OKR_UTIL_PUB.GET_IP_TYP_MEANING(IPYBB.IP_TYPE) IP_TYPE_MEANING
, IPYBB.IP_IDENTIFIER IP_IDENTIFIER
, IPYBT.NAME NAME
, IPYBT.SUBJECT SUBJECT
, IPYBT.DESCRIPTION DESCRIPTION
, IPYBB.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, OKR_UTIL_PUB.GET_TERRITORY_NAME(IPYBB.COUNTRY_OF_ORIGIN) COUNTRY_NAME
, IPYBB.IP_LANG_CODE IP_LANG_CODE
, IPYBB.DATE_OF_CREATION DATE_OF_CREATION
, IPYBB.ORIG_CPRGT_DATE ORIG_CPRGT_DATE
, IPYBB.OWN_CPRGT OWN_CPRGT
, IPYBB.ASSET_ID ASSET_ID
, IPYBB.REFERENCE_PROPERTY REFERENCE_PROPERTY
, IPYBT.KEYWORD_TEXT KEYWORD_TEXT
, IPYBB.ATTACH_FILE_ID ATTACH_FILE_ID
, IPYBB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPYBB.START_DATE_ACTIVE START_DATE_ACTIVE
, IPYBB.END_DATE_ACTIVE END_DATE_ACTIVE
, IPYBT.SFWT_FLAG SFWT_FLAG
, IPYBB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IPYBB.ATTRIBUTE1 ATTRIBUTE1
, IPYBB.ATTRIBUTE2 ATTRIBUTE2
, IPYBB.ATTRIBUTE3 ATTRIBUTE3
, IPYBB.ATTRIBUTE4 ATTRIBUTE4
, IPYBB.ATTRIBUTE5 ATTRIBUTE5
, IPYBB.ATTRIBUTE6 ATTRIBUTE6
, IPYBB.ATTRIBUTE7 ATTRIBUTE7
, IPYBB.ATTRIBUTE8 ATTRIBUTE8
, IPYBB.ATTRIBUTE9 ATTRIBUTE9
, IPYBB.ATTRIBUTE10 ATTRIBUTE10
, IPYBB.ATTRIBUTE11 ATTRIBUTE11
, IPYBB.ATTRIBUTE12 ATTRIBUTE12
, IPYBB.ATTRIBUTE13 ATTRIBUTE13
, IPYBB.ATTRIBUTE14 ATTRIBUTE14
, IPYBB.ATTRIBUTE15 ATTRIBUTE15
, IPYBB.CREATED_BY CREATED_BY
, IPYBB.CREATION_DATE CREATION_DATE
, IPYBB.LAST_UPDATED_BY LAST_UPDATED_BY
, IPYBB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPYBB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(IPYBB.IP_ID
, 'R') ACCESS_LEVEL
FROM OKR_IP_COMMON_B IPYBB
, OKR_IP_COMMON_TL IPYBT
WHERE IPYBB.IP_ID = IPYBT.IP_ID
AND IPYBT.LANGUAGE = USERENV('LANG')
AND OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(IPYBB.IP_ID
, 'R') != 'N'