Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | Complete View for table OKR_IP_FILMS_B, OKR_IP_COMMON_B, FND_LOOKUPS and FND_TERRITORIES_TL |
Implementation/DBA Data: | Not implemented in this database |
SELECT FB.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
, FB.IN_COLOR IN_COLOR
, FB.SOUND_MIX SOUND_MIX
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_FILM_SOUND_MIX'
, FB.SOUND_MIX)
, FB.DURATION DURATION
, FB.DURATION_UOM DURATION_UOM
, FB.CINEMATOGRAPHIC_PROCESS CINEMATOGRAPHIC_PROCESS
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_CINEMATOGRAPHIC_PROCESS'
, FB.CINEMATOGRAPHIC_PROCESS)
, FB.ASPECT_RATIO ASPECT_RATIO
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_ASPECT_RATIO'
, FB.ASPECT_RATIO)
, FB.FILM_FORMAT FILM_FORMAT
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_FILM_FORMAT'
, FB.FILM_FORMAT)
, FB.BUDGET_AMOUNT BUDGET_AMOUNT
, FB.BUDGET_CURRENCY BUDGET_CURRENCY
, FB.MPAA_RATING MPAA_RATING
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_FILM_RATING'
, FB.MPAA_RATING)
, FT.MPAA_REASON MPAA_REASON
, FT.PLOT_OUTLINE PLOT_OUTLINE
, FT.TAG_LINE TAG_LINE
, FT.CAMERA CAMERA
, FT.LABORATORY LABORATORY
, OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(FB.IP_ID
, 'R') ACCESS_LEVEL
, FT.SFWT_FLAG SFWT_FLAG
, CB.ATTACH_FILE_ID ATTACH_FILE_ID
, FB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FB.CREATION_DATE CREATION_DATE
, FB.CREATED_BY CREATED_BY
, FB.LAST_UPDATED_BY LAST_UPDATED_BY
, FB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, FB.ATTRIBUTE1 ATTRIBUTE1
, FB.ATTRIBUTE2 ATTRIBUTE2
, FB.ATTRIBUTE3 ATTRIBUTE3
, FB.ATTRIBUTE4 ATTRIBUTE4
, FB.ATTRIBUTE5 ATTRIBUTE5
, FB.ATTRIBUTE6 ATTRIBUTE6
, FB.ATTRIBUTE7 ATTRIBUTE7
, FB.ATTRIBUTE8 ATTRIBUTE8
, FB.ATTRIBUTE9 ATTRIBUTE9
, FB.ATTRIBUTE10 ATTRIBUTE10
, FB.ATTRIBUTE11 ATTRIBUTE11
, FB.ATTRIBUTE12 ATTRIBUTE12
, FB.ATTRIBUTE13 ATTRIBUTE13
, FB.ATTRIBUTE14 ATTRIBUTE14
, FB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_IP_COMMON_B CB
, OKR_IP_COMMON_TL CT
, OKR_IP_FILMS_B FB
, OKR_IP_FILMS_TL FT
WHERE FB.IP_ID = CB.IP_ID
AND FB.IP_ID = FT.IP_ID
AND FT.LANGUAGE = USERENV('LANG')
AND FB.IP_ID = CT.IP_ID
AND CT.LANGUAGE = USERENV('LANG')
AND OKR_UTIL_PUB.GET_PROP_ACCESS_LEVEL(FB.IP_ID
, 'R') != 'N'