Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | View on tables OKC_K_LINES_B, OKC_RULES_B, OKC_K_ITEMS, OKC_RULE_GROUPS_TL, OKC_K_LINES_TL |
Implementation/DBA Data: | Not implemented in this database |
SELECT CLEB.ID ID
, CLEB.DNZ_CHR_ID CHR_ID
, CIM.OBJECT1_ID1 RGTP_ID
, CLET.NAME RGT_NAME
, CLET.ITEM_DESCRIPTION RGT_DESC
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, OKR_UTIL_PUB.GET_PERIOD_DURATION(CLEB.START_DATE
, CLEB.END_DATE)
, RULL.RULE_INFORMATION1 LANG_CODE
, RULT.RULE_INFORMATION1 TERR_ID
, RULE.RULE_INFORMATION1 EXCLUSIVITY_YN
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, RULT.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
FROM OKC_K_LINES_B CLEB
, OKC_RULES_B RULL
, OKC_RULES_B RULT
, OKC_RULES_B RULE
, OKC_K_ITEMS CIM
, OKC_RULE_GROUPS_B RGP
, OKC_K_LINES_TL CLET
WHERE CLEB.LSE_ID = 104
AND CIM.CLE_ID = CLEB.ID
AND RGP.CLE_ID = CLEB.ID
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND RULL.RGP_ID = RGP.ID
AND RULL.RULE_INFORMATION_CATEGORY = 'LAN'
AND RULT.RGP_ID = RGP.ID
AND RULT.RULE_INFORMATION_CATEGORY = 'TER'
AND RULE.RGP_ID = RGP.ID
AND RULE.RULE_INFORMATION_CATEGORY = 'EXC'