Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RAPTV.USER_SESSION_ID USER_SESSION_ID
, RAPTV.SEARCH_ID SEARCH_ID
, RASTT.STS_ID STATUS_PERIOD_ID
, RAPTV.USER_NAME USER_NAME
, RAPTV.RGTS_TXN_ID RGTS_TXN_ID
, RAPTV.OBJECT1_ID1 OBJECT1_ID1
, RAPTV.OBJECT1_ID2 OBJECT1_ID2
, RAPTV.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, RAPTV.DNZ_RGTP_ID DNZ_RGTP_ID
, RAPTV.TXN_TYPE_CODE TXN_TYPE_CODE
, RAPTV.IP_RIGHTS_ID IP_RIGHTS_ID
, RAPTV.EXCLUSIVE_YN EXCLUSIVE_YN
, RAPTV.TXN_ID TXN_ID
, RAPTV.RESTRICTED_YN RESTRICTED_YN
, RAPTV.SELLABLE_YN SELLABLE_YN
, RAPTV.CHR_ID CHR_ID
, RAPTV.CLE_ID CLE_ID
, RAPTV.NAME NAME
, RAPTV.DESCRIPTION DESCRIPTION
, RAPTV.RESTRICTION_TEXT RESTRICTION_TEXT
, RAPTV.KEYWORD_TEXT KEYWORD_TEXT
, RAPTV.START_DATE_ACTIVE START_DATE_ACTIVE
, RAPTV.END_DATE_ACTIVE END_DATE_ACTIVE
, RAPTV.DURATION DURATION
, RAPTV.SOURCE_CHR_ID SOURCE_CHR_ID
, RAPTV.CONTRACT_NUMBER CONTRACT_NUMBER
, RAPTV.VERSION_NUMBER VERSION_NUMBER
, RAPTV.STS_CODE STS_CODE
, RAPTV.STS_CODE_MEANING STS_CODE_MEANING
, RAPTV.BUY_OR_SELL BUY_OR_SELL
, RAPTV.IP_NAME IP_NAME
, RAPTV.IP_TYPE IP_TYPE
, RAPTV.IP_TYPE_MEANING IP_TYPE_MEANING
, RAPTV.TERRITORY_ID TERRITORY_ID
, RAPTV.TERRITORY_NAME TERRITORY_NAME
, RAPTV.LANGUAGE_CODE LANGUAGE_CODE
, RAPTV.LANGUAGE_MEANING LANGUAGE_MEANING
, RAPTV.MEDIA_CODE MEDIA_CODE
, RAPTV.MEDIA_MEANING MEDIA_MEANING
FROM OKR_R_AVAIL_PREP_TEMP_V RAPTV
, OKR_R_AVAIL_STS_TXN_TEMP RASTT
WHERE RAPTV.USER_SESSION_ID = RASTT.USER_SESSION_ID AND RAPTV.SEARCH_ID = RASTT.SEARCH_ID AND RAPTV.RGTS_TXN_ID = RASTT.RGTS_TXN_ID