[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RAPT.USER_SESSION_ID USER_SESSION_ID
, RAPT.USER_NAME USER_NAME
, RAPT.SEARCH_ID SEARCH_ID
, RAPT.RGTS_TXN_ID RGTS_TXN_ID
, RAPT.OBJECT1_ID1 OBJECT1_ID1
, RAPT.OBJECT1_ID2 OBJECT1_ID2
, RAPT.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, RAPT.DNZ_RGTP_ID DNZ_RGTP_ID
, RAPT.TXN_TYPE_CODE TXN_TYPE_CODE
, RAPT.IP_RIGHTS_ID IP_RIGHTS_ID
, RAPT.EXCLUSIVE_YN EXCLUSIVE_YN
, RAPT.TXN_ID TXN_ID
, RAPT.RESTRICTED_YN RESTRICTED_YN
, RAPT.SELLABLE_YN SELLABLE_YN
, RAPT.CHR_ID CHR_ID
, RAPT.CLE_ID CLE_ID
, RAPT.NAME NAME
, RAPT.DESCRIPTION DESCRIPTION
, RAPT.RESTRICTION_TEXT RESTRICTION_TEXT
, RAPT.KEYWORD_TEXT KEYWORD_TEXT
, RAPT.START_DATE_ACTIVE START_DATE_ACTIVE
, RAPT.END_DATE_ACTIVE END_DATE_ACTIVE
, RAPT.DURATION DURATION
, RAPT.SOURCE_CHR_ID SOURCE_CHR_ID
, RAPT.CONTRACT_NUMBER CONTRACT_NUMBER
, RAPT.VERSION_NUMBER VERSION_NUMBER
, RAPT.STS_CODE STS_CODE
, RAPT.STS_CODE_MEANING STS_CODE_MEANING
, RAPT.BUY_OR_SELL BUY_OR_SELL
, RAPT.IP_NAME IP_NAME
, RAPT.IP_TYPE IP_TYPE
, RAPT.IP_TYPE_MEANING IP_TYPE_MEANING
, RAPT.TERRITORY_ID TERRITORY_ID
, RAPT.TERRITORY_NAME TERRITORY_NAME
, RAPT.LANGUAGE_CODE LANGUAGE_CODE
, RAPT.LANGUAGE_MEANING LANGUAGE_MEANING
, RAPT.MEDIA_CODE MEDIA_CODE
, RAPT.MEDIA_MEANING MEDIA_MEANING
, RAPT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RAPT.CREATED_BY CREATED_BY
, RAPT.CREATION_DATE CREATION_DATE
, RAPT.LAST_UPDATED_BY LAST_UPDATED_BY
, RAPT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RAPT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_R_AVAIL_PREP_TEMP RAPT