[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | Complete view on tables OKC_LINES_B, OKC_RULES_B, OKC_K_ITEMS, OKC_RULE_GROUPS, OKC_K_HEADER_B, OKR_IP_COMMON_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IPYB.IP_ID IP_ID
, CLEB.ID RGT_CLE_ID
, CHR.ID CHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.STS_CODE STS_CODE
, OKR_UTIL_PUB.GET_K_STATUS_MEANING(CHR.STS_CODE) STS_CODE_MEANING
, CHR.TEMPLATE_YN TEMPLATE_YN
, CIM.OBJECT1_ID1 RGTP_ID
, CLET.NAME RGT_NAME
, CLET.ITEM_DESCRIPTION RGT_DESC
, CLEB.START_DATE START_DATE
, CLEB.END_DATE 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
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKC_RULES_B RULL
, OKC_RULES_B RULT
, OKC_RULES_B RULE
, OKC_K_ITEMS CIM
, OKC_K_LINES_B CLEIP
, OKC_K_LINES_B CLERG
, OKC_K_ITEMS CIMIP
, OKC_RULE_GROUPS_B RGP
, OKC_K_HEADERS_B CHR
, OKR_IP_COMMON_B IPYB
WHERE CLEIP.LSE_ID = 100
AND CLEIP.CHR_ID = CHR.ID
AND CIMIP.CLE_ID = CLEIP.ID
AND CLERG.LSE_ID = 101
AND CLERG.CLE_ID = CLEIP.ID
AND CLEB.LSE_ID = 104
AND CLEB.CLE_ID = CLERG.ID
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CIM.CLE_ID = CLEB.ID
AND RGP.CLE_ID = CLEB.ID
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'
AND TO_CHAR(IPYB.IP_ID) = CIMIP.OBJECT1_ID1