Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT IPCR.ID ID
, IPCR.CHR_ID CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, OKR_UTIL_PUB.GET_VERSION_NUMBER(CHRB.ID) VERSION
, CHRB.STS_CODE STS_CODE
, OKR_UTIL_PUB.GET_K_STATUS_MEANING(CHRB.STS_CODE) STS_CODE_MEANING
, CHRB.BUY_OR_SELL BUY_OR_SELL
, IPCR.IP_ID IP_ID
, IPCT.NAME
, IPCB.IP_IDENTIFIER
, IPCB.IP_TYPE
, OKR_UTIL_PUB.GET_IP_TYP_MEANING(IP_TYPE) IP_TYPE_MEANING
, IPCB.ORIG_CPRGT_DATE
, IPCB.COUNTRY_OF_ORIGIN
, OKR_UTIL_PUB.GET_TERRITORY_NAME(IPCB.COUNTRY_OF_ORIGIN) COUNTRY_NAME
, IPCR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPCR.CREATED_BY CREATED_BY
, IPCR.CREATION_DATE CREATION_DATE
, IPCR.LAST_UPDATED_BY LAST_UPDATED_BY
, IPCR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPCR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_IP_CTRCT_RELS IPCR
, OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKR_IP_COMMON_B IPCB
, OKR_IP_COMMON_TL IPCT
WHERE IPCR.CHR_ID = CHRB.ID
AND CHRB.ID = CHRT.ID
AND IPCR.IP_ID = IPCB.IP_ID
AND IPCB.IP_ID = IPCT.IP_ID