[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RAST.ID ID
, RAST.USER_SESSION_ID USER_SESSION_ID
, RAST.USER_NAME USER_NAME
, RAST.SEARCH_ID SEARCH_ID
, RAST.IP_ID IP_ID
, RAST.IP_NAME IP_NAME
, RAST.IP_RIGHTS_ID IP_RIGHTS_ID
, RAST.RIGHTS_NAME RIGHTS_NAME
, RAST.MEDIA_CODE MEDIA_CODE
, RAST.MEDIA_NAME MEDIA_NAME
, RAST.TERRITORY_ID TERRITORY_ID
, RAST.TERRITORY_TYPE_ID TERRITORY_TYPE_ID
, RAST.PARENT_TERRITORY_ID PARENT_TERRITORY_ID
, RAST.TERRITORY_NAME TERRITORY_NAME
, RAST.TERRITORY_TYPE_NAME TERRITORY_TYPE_NAME
, RAST.LANGUAGE_CODE LANGUAGE_CODE
, RAST.LANGUAGE_NAME LANGUAGE_NAME
, RAST.INPUT_START_DATE INPUT_START_DATE
, RAST.INPUT_END_DATE INPUT_END_DATE
, RAST.CALCULATED_PERIOD_START_DATE CALCULATED_PERIOD_START_DATE
, RAST.CALCULATED_PERIOD_END_DATE CALCULATED_PERIOD_END_DATE
, RAST.RIGHTS_AVAIL_STATUS_CODE RIGHTS_AVAIL_STATUS_CODE
, RAST.RIGHTS_AVAIL_STATUS_NAME RIGHTS_AVAIL_STATUS_NAME
, RAST.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RAST.CREATED_BY CREATED_BY
, RAST.CREATION_DATE CREATION_DATE
, RAST.LAST_UPDATED_BY LAST_UPDATED_BY
, RAST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RAST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_R_AVAIL_STATUS_TEMP RAST