View: OKR_IP_LITWORKS_CV

View Text

SELECT LB.IP_ID IP_ID
, CB.IP_TYPE IP_TYPE
, CB.IP_IDENTIFIER IP_IDENTIFIER
, CT.NAME NAME
, CT.SUBJECT SUBJECT
, CT.DESCRIPTION DESCRIPTION
, CB.DATE_OF_CREATION DATE_OF_CREATION
, CB.REFERENCE_PROPERTY REFERENCE_PROPERTY
, CB.ORIG_CPRGT_DATE ORIG_CPRGT_DATE
, CB.OWN_CPRGT OWN_CPRGT
, CB.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, DECODE(CB.COUNTRY_OF_ORIGIN
, NULL
, NULL
, OKR_UTIL_PUB.GET_TERRITORY_NAME(CB.COUNTRY_OF_ORIGIN)) COO_NAME
, CB.ASSET_ID ASSET_ID
, CB.IP_LANG_CODE IP_LANG_CODE
, DECODE(CB.IP_LANG_CODE
, NULL
, NULL
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_IP_LANGUAGE'
, CB.IP_LANG_CODE)) IP_LANG_MEANING
, CB.START_DATE_ACTIVE START_DATE_ACTIVE
, CB.END_DATE_ACTIVE END_DATE_ACTIVE
, LB.WORD_COUNT WORD_COUNT
, LB.EDITION EDITION
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_LW_EDITIONS'
, LB.EDITION)
, CT.KEYWORD_TEXT KEYWORD_TEXT
, CB.ATTACH_FILE_ID ATTACH_FILE_ID
, OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(LB.IP_ID
, 'R') ACCESS_LEVEL
, LB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LT.SFWT_FLAG SFWT_FLAG
, LB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LB.ATTRIBUTE1 ATTRIBUTE1
, LB.ATTRIBUTE2 ATTRIBUTE2
, LB.ATTRIBUTE3 ATTRIBUTE3
, LB.ATTRIBUTE4 ATTRIBUTE4
, LB.ATTRIBUTE5 ATTRIBUTE5
, LB.ATTRIBUTE6 ATTRIBUTE6
, LB.ATTRIBUTE7 ATTRIBUTE7
, LB.ATTRIBUTE8 ATTRIBUTE8
, LB.ATTRIBUTE9 ATTRIBUTE9
, LB.ATTRIBUTE10 ATTRIBUTE10
, LB.ATTRIBUTE11 ATTRIBUTE11
, LB.ATTRIBUTE12 ATTRIBUTE12
, LB.ATTRIBUTE13 ATTRIBUTE13
, LB.ATTRIBUTE14 ATTRIBUTE14
, LB.ATTRIBUTE15 ATTRIBUTE15
, LB.CREATION_DATE CREATION_DATE
, LB.CREATED_BY CREATED_BY
, LB.LAST_UPDATED_BY LAST_UPDATED_BY
, LB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_IP_COMMON_B CB
, OKR_IP_COMMON_TL CT
, OKR_IP_LITWORKS_B LB
, OKR_IP_LITWORKS_TL LT
WHERE LB.IP_ID = CB.IP_ID
AND LB.IP_ID = LT.IP_ID
AND LT.LANGUAGE = USERENV('LANG')
AND LB.IP_ID = CT.IP_ID
AND CT.LANGUAGE = USERENV('LANG')
AND OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(LB.IP_ID
, 'R') != 'N'

Columns