Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TXTE.ID ID
, TXTE.IP_RGTS_TXN_ID IP_RGTS_TXN_ID
, TXTE.DNZ_IP_ID DNZ_IP_ID
, TXTE.DNZ_RGTP_ID DNZ_RGTP_ID
, TXTE.DNZ_IP_RIGHTS_ID DNZ_IP_RIGHTS_ID
, TXTE.TERRITORY_ID TERRITORY_ID
, JTFT.LOCATION_AREA_NAME TERRITORY_NAME
, TXTE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TXTE.CREATED_BY CREATED_BY
, TXTE.CREATION_DATE CREATION_DATE
, TXTE.LAST_UPDATED_BY LAST_UPDATED_BY
, TXTE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TXTE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TXTE.START_DATE_ACTIVE START_DATE_ACTIVE
, TXTE.END_DATE_ACTIVE END_DATE_ACTIVE
FROM OKR_IP_RGTS_TXN_TERR TXTE
, JTF_LOC_AREAS_VL JTFT
WHERE TXTE.TERRITORY_ID = JTFT.LOCATION_AREA_ID