[Home] [Help]
View: OKC_KOL_K_ARTICLES_V
Product: | OKC - Contracts Core |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CATB.ID ID
, CATB.CHR_ID CHR_ID
, CATB.CLE_ID CLE_ID
, CATB.DNZ_CHR_ID DNZ_CHR_ID
, CATB.SAV_SAE_ID SAV_SAE_ID
, NVL(VERS.SAV_RELEASE
, VERS.ARTICLE_VERSION_NUMBER) SAV_SAV_RELEASE
, DECODE(ART.STANDARD_YN
, 'Y'
, 'STA'
, 'NSD') CAT_TYPE
, SUBSTR(OKC_UTIL.DECODE_LOOKUP('OKC_YES_NO'
, DECODE(ART.STANDARD_YN
, 'Y'
, 'YES'
, 'NO'))
, 1
, 80) STD_YES_NO
, SUBSTR(OKC_UTIL.DECODE_LOOKUP('OKC_SUBJECT'
, ART.ARTICLE_TYPE)
, 1
, 80) SUBJECT
, ART.ARTICLE_TYPE SBT_CODE
, ART.ARTICLE_TITLE NAME
, VERS.ARTICLE_DESCRIPTION COMMENTS
, VERS.VARIATION_DESCRIPTION VARIATION_DESCRIPTION
, VERS.ARTICLE_TEXT TEXT
, CATB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKC_K_ARTICLES_B CATB
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS VERS
WHERE CATB.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
AND CATB.SAV_SAE_ID = ART.ARTICLE_ID
Columns
Name |
ID |
CHR_ID |
CLE_ID |
DNZ_CHR_ID |
SAV_SAE_ID |
SAV_SAV_RELEASE |
CAT_TYPE |
STD_YES_NO |
SUBJECT |
SBT_CODE |
NAME |
COMMENTS |
VARIATION_DESCRIPTION |
TEXT |
OBJECT_VERSION_NUMBER |