Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | Complete view for tables OKR_IP_PHOTOS_B, OKR_IP_COMMON_B, FND_LOOKUPS and FND_TERRITORIES_TL |
Implementation/DBA Data: | Not implemented in this database |
SELECT PB.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.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.ORIG_CPRGT_DATE ORIG_CPRGT_DATE
, CB.OWN_CPRGT OWN_CPRGT
, 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
, CT.KEYWORD_TEXT KEYWORD_TEXT
, CB.ATTACH_FILE_ID ATTACH_FILE_ID
, PB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PT.SFWT_FLAG SFWT_FLAG
, PT.PLACE PLACE
, PB.COLOR COLOR
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_PHOTO_COLOR'
, PB.COLOR)
, PB.RESOLUTION RESOLUTION
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_PHOTO_RESOLUTION'
, PB.RESOLUTION)
, PB.PHOTO_SIZE PHOTO_SIZE
, PB.FILM_TYPE FILM_TYPE
, PB.FILM_MFR FILM_MFR
, OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(PB.IP_ID
, 'R') ACCESS_LEVEL
, PB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PB.ATTRIBUTE1 ATTRIBUTE1
, PB.ATTRIBUTE2 ATTRIBUTE2
, PB.ATTRIBUTE3 ATTRIBUTE3
, PB.ATTRIBUTE4 ATTRIBUTE4
, PB.ATTRIBUTE5 ATTRIBUTE5
, PB.ATTRIBUTE6 ATTRIBUTE6
, PB.ATTRIBUTE7 ATTRIBUTE7
, PB.ATTRIBUTE8 ATTRIBUTE8
, PB.ATTRIBUTE9 ATTRIBUTE9
, PB.ATTRIBUTE10 ATTRIBUTE10
, PB.ATTRIBUTE11 ATTRIBUTE11
, PB.ATTRIBUTE12 ATTRIBUTE12
, PB.ATTRIBUTE13 ATTRIBUTE13
, PB.ATTRIBUTE14 ATTRIBUTE14
, PB.ATTRIBUTE15 ATTRIBUTE15
, PB.CREATION_DATE CREATION_DATE
, PB.CREATED_BY CREATED_BY
, PB.LAST_UPDATED_BY LAST_UPDATED_BY
, PB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_IP_COMMON_B CB
, OKR_IP_COMMON_TL CT
, OKR_IP_PHOTOS_B PB
, OKR_IP_PHOTOS_TL PT
WHERE PB.IP_ID = CB.IP_ID
AND PB.IP_ID = PT.IP_ID
AND PT.LANGUAGE = USERENV('LANG')
AND PB.IP_ID = CT.IP_ID
AND CT.LANGUAGE = USERENV('LANG')
AND OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(PB.IP_ID
, 'R') != 'N'