Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_K_ARTICLES_UV |
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'