Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RTXB.ROWID ROW_ID
, RTXB.ID ID
, RTXB.OBJECT1_ID1 OBJECT1_ID1
, RTXB.OBJECT1_ID2 OBJECT1_ID2
, RTXB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, IPRB.VAL_PTRT_ID VAL_PTRT_ID
, RTXB.DNZ_RGTP_ID DNZ_RGTP_ID
, RTXB.TXN_TYPE_CODE TXN_TYPE_CODE
, RTXB.IP_RIGHTS_ID IP_RIGHTS_ID
, RTXB.EXCLUSIVE_YN EXCLUSIVE_YN
, RTXB.TXN_ID TXN_ID
, RTXB.RESTRICTED_YN RESTRICTED_YN
, RTXB.SELLABLE_YN SELLABLE_YN
, RTXB.CHR_ID CHR_ID
, RTXB.CLE_ID CLE_ID
, RTXT.NAME NAME
, RTXT.DESCRIPTION DESCRIPTION
, RTXT.RESTRICTION_TEXT RESTRICTION_TEXT
, RTXT.KEYWORD_TEXT KEYWORD_TEXT
, RTXB.START_DATE_ACTIVE START_DATE_ACTIVE
, RTXB.END_DATE_ACTIVE END_DATE_ACTIVE
, OKR_UTIL_PUB.GET_PERIOD_DURATION(RTXB.START_DATE_ACTIVE
, RTXB.END_DATE_ACTIVE) DURATION
, RTXT.SFWT_FLAG SFWT_FLAG
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, CHR_ID
, 'OKR_TEMPLATE_CONTRACT'
, OBJECT1_ID1
, NULL) SOURCE_CHR_ID
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_CONTRACT_NUMBER(CHR_ID)
, 'OKR_TEMPLATE_CONTRACT'
, OKR_UTIL_PUB.GET_CONTRACT_NUMBER(OBJECT1_ID1)
, NULL) CONTRACT_NUMBER
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_VERSION_NUMBER(CHR_ID)
, 'OKR_TEMPLATE_CONTRACT'
, OKR_UTIL_PUB.GET_VERSION_NUMBER(OBJECT1_ID1)
, NULL) VERSION_NUMBER
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_CONTRACT_STATUS(CHR_ID)
, 'OKR_TEMPLATE_CONTRACT'
, OKR_UTIL_PUB.GET_CONTRACT_STATUS(OBJECT1_ID1)
, NULL) STS_CODE
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_K_STATUS_MEANING(CHR_ID)
, 'OKR_TEMPLATE_CONTRACT'
, OKR_UTIL_PUB.GET_K_STATUS_MEANING(OBJECT1_ID1)
, NULL) STS_CODE_MEADNING
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_CONTRACT_INTENT(CHR_ID)
, 'OKR_TEMPLATE_CONTRACT'
, OKR_UTIL_PUB.GET_CONTRACT_INTENT(OBJECT1_ID1)
, NULL) BUY_OR_SELL
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_IP_NAME(OBJECT1_ID1)
, NULL) IP_NAME
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_IP_TYPE_CODE(OBJECT1_ID1)
, NULL) IP_TYPE
, DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_IP_TYP_MEANING(DECODE(JTOT_OBJECT1_CODE
, 'OKR_IP'
, OKR_UTIL_PUB.GET_IP_TYPE_CODE(OBJECT1_ID1)
, NULL))
, NULL) IP_TYPE_MEANING
, RTXB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RTXB.CREATED_BY CREATED_BY
, RTXB.CREATION_DATE CREATION_DATE
, RTXB.LAST_UPDATED_BY LAST_UPDATED_BY
, RTXB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RTXB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RTXB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RTXB.ATTRIBUTE1 ATTRIBUTE1
, RTXB.ATTRIBUTE2 ATTRIBUTE2
, RTXB.ATTRIBUTE3 ATTRIBUTE3
, RTXB.ATTRIBUTE4 ATTRIBUTE4
, RTXB.ATTRIBUTE5 ATTRIBUTE5
, RTXB.ATTRIBUTE6 ATTRIBUTE6
, RTXB.ATTRIBUTE7 ATTRIBUTE7
, RTXB.ATTRIBUTE8 ATTRIBUTE8
, RTXB.ATTRIBUTE9 ATTRIBUTE9
, RTXB.ATTRIBUTE10 ATTRIBUTE10
, RTXB.ATTRIBUTE11 ATTRIBUTE11
, RTXB.ATTRIBUTE12 ATTRIBUTE12
, RTXB.ATTRIBUTE13 ATTRIBUTE13
, RTXB.ATTRIBUTE14 ATTRIBUTE14
, RTXB.ATTRIBUTE15 ATTRIBUTE15
, RTXB.REQUEST_ID REQUEST_ID
, RTXB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, RTXB.PROGRAM_ID PROGRAM_ID
, RTXB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM OKR_IP_RGTS_B IPRB
, OKR_IP_RGTS_TXN_B RTXB
, OKR_IP_RGTS_TXN_TL RTXT
WHERE RTXB.ID = RTXT.ID
AND RTXB.IP_RIGHTS_ID = IPRB.ID
AND RTXT.LANGUAGE = USERENV('LANG')