VIEW: APPS.OKL_K_ARTICLES_UV

Source

View Text - Preformatted

SELECT CAT.ID ID, CAT.CHR_ID CHR_ID, CAT.CLE_ID CLE_ID, CAT.CAT_ID CAT_ID, CAT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CAT.SFWT_FLAG SFWT_FLAG, CAT.SAV_SAE_ID SAV_SAE_ID, CAT.SAV_SAV_RELEASE SAV_SAV_RELEASE, CAT.SBT_CODE SBT_CODE, CAT.DNZ_CHR_ID DNZ_CHR_ID, CAT.COMMENTS COMMENTS, CAT.FULLTEXT_YN FULLTEXT_YN, CAT.VARIATION_DESCRIPTION VARIATION_DESCRIPTION, CAT.NAME NAME, CAT.CAT_TYPE CAT_TYPE, CAT.CREATED_BY CREATED_BY, CAT.CREATION_DATE CREATION_DATE, CAT.LAST_UPDATED_BY LAST_UPDATED_BY, CAT.LAST_UPDATE_DATE LAST_UPDATE_DATE, CAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKC_K_ARTICLES_V CAT WHERE CAT.CAT_TYPE = 'NSD' UNION select CAT.ID ID, CAT.CHR_ID CHR_ID, CAT.CLE_ID CLE_ID, CAT.CAT_ID CAT_ID, CAT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CAT.SFWT_FLAG SFWT_FLAG, CAT.SAV_SAE_ID SAV_SAE_ID, CAT.SAV_SAV_RELEASE SAV_SAV_RELEASE, CAT.SBT_CODE SBT_CODE, CAT.DNZ_CHR_ID DNZ_CHR_ID, CAT.COMMENTS COMMENTS, CAT.FULLTEXT_YN FULLTEXT_YN, CAT.VARIATION_DESCRIPTION VARIATION_DESCRIPTION, SAE.NAME NAME, CAT.CAT_TYPE CAT_TYPE, CAT.CREATED_BY CREATED_BY, CAT.CREATION_DATE CREATION_DATE, CAT.LAST_UPDATED_BY LAST_UPDATED_BY, CAT.LAST_UPDATE_DATE LAST_UPDATE_DATE, CAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKC_K_ARTICLES_V CAT,OKC_STD_ARTICLES_V SAE WHERE CAT.SAV_SAE_ID = SAE.ID AND CAT.cat_type = 'STA'

View Text - HTML Formatted

SELECT CAT.ID ID
, CAT.CHR_ID CHR_ID
, CAT.CLE_ID CLE_ID
, CAT.CAT_ID CAT_ID
, CAT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CAT.SFWT_FLAG SFWT_FLAG
, CAT.SAV_SAE_ID SAV_SAE_ID
, CAT.SAV_SAV_RELEASE SAV_SAV_RELEASE
, CAT.SBT_CODE SBT_CODE
, CAT.DNZ_CHR_ID DNZ_CHR_ID
, CAT.COMMENTS COMMENTS
, CAT.FULLTEXT_YN FULLTEXT_YN
, CAT.VARIATION_DESCRIPTION VARIATION_DESCRIPTION
, CAT.NAME NAME
, CAT.CAT_TYPE CAT_TYPE
, CAT.CREATED_BY CREATED_BY
, CAT.CREATION_DATE CREATION_DATE
, CAT.LAST_UPDATED_BY LAST_UPDATED_BY
, CAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_ARTICLES_V CAT
WHERE CAT.CAT_TYPE = 'NSD' UNION SELECT CAT.ID ID
, CAT.CHR_ID CHR_ID
, CAT.CLE_ID CLE_ID
, CAT.CAT_ID CAT_ID
, CAT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CAT.SFWT_FLAG SFWT_FLAG
, CAT.SAV_SAE_ID SAV_SAE_ID
, CAT.SAV_SAV_RELEASE SAV_SAV_RELEASE
, CAT.SBT_CODE SBT_CODE
, CAT.DNZ_CHR_ID DNZ_CHR_ID
, CAT.COMMENTS COMMENTS
, CAT.FULLTEXT_YN FULLTEXT_YN
, CAT.VARIATION_DESCRIPTION VARIATION_DESCRIPTION
, SAE.NAME NAME
, CAT.CAT_TYPE CAT_TYPE
, CAT.CREATED_BY CREATED_BY
, CAT.CREATION_DATE CREATION_DATE
, CAT.LAST_UPDATED_BY LAST_UPDATED_BY
, CAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_ARTICLES_V CAT
, OKC_STD_ARTICLES_V SAE
WHERE CAT.SAV_SAE_ID = SAE.ID
AND CAT.CAT_TYPE = 'STA'