Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | View for OKR_IP_FILMS_B and OKR_IP_FILMS_TL |
Implementation/DBA Data: | Not implemented in this database |
SELECT IFMB.IP_ID IP_ID
, IFMT.TAG_LINE TAG_LINE
, IFMT.PLOT_OUTLINE PLOT_OUTLINE
, IFMB.IN_COLOR IN_COLOR
, IFMB.SOUND_MIX SOUND_MIX
, IFMB.DURATION DURATION
, IFMB.DURATION_UOM DURATION_UOM
, IFMB.CINEMATOGRAPHIC_PROCESS CINEMATOGRAPHIC_PROCESS
, IFMB.ASPECT_RATIO ASPECT_RATIO
, IFMB.FILM_FORMAT FILM_FORMAT
, IFMB.BUDGET_AMOUNT BUDGET_AMOUNT
, IFMB.BUDGET_CURRENCY BUDGET_CURRENCY
, IFMB.MPAA_RATING MPAA_RATING
, IFMT.MPAA_REASON MPAA_REASON
, IFMT.LABORATORY LABORATORY
, IFMT.CAMERA CAMERA
, IFMT.SFWT_FLAG SFWT_FLAG
, IFMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IFMB.CREATION_DATE CREATION_DATE
, IFMB.CREATED_BY CREATED_BY
, IFMB.LAST_UPDATED_BY LAST_UPDATED_BY
, IFMB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IFMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IFMB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IFMB.ATTRIBUTE1 ATTRIBUTE1
, IFMB.ATTRIBUTE2 ATTRIBUTE2
, IFMB.ATTRIBUTE3 ATTRIBUTE3
, IFMB.ATTRIBUTE4 ATTRIBUTE4
, IFMB.ATTRIBUTE5 ATTRIBUTE5
, IFMB.ATTRIBUTE6 ATTRIBUTE6
, IFMB.ATTRIBUTE7 ATTRIBUTE7
, IFMB.ATTRIBUTE8 ATTRIBUTE8
, IFMB.ATTRIBUTE9 ATTRIBUTE9
, IFMB.ATTRIBUTE10 ATTRIBUTE10
, IFMB.ATTRIBUTE11 ATTRIBUTE11
, IFMB.ATTRIBUTE12 ATTRIBUTE12
, IFMB.ATTRIBUTE13 ATTRIBUTE13
, IFMB.ATTRIBUTE14 ATTRIBUTE14
, IFMB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_IP_FILMS_B IFMB
, OKR_IP_FILMS_TL IFMT
WHERE IFMB.IP_ID = IFMT.IP_ID
AND IFMT.LANGUAGE = USERENV('LANG')