eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKR_K_ARTICLES_HCV

Product:	OKR - Contracts for Rights (Obsolete)
Description:	View for okr_k_articles_v, okc_std_art_versions_v, okc_std_articles_v, fnd_lookups
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ARTH.ROW_ID
, ARTH.ID
, ARTH.MAJOR_VERSION
, ARTH.CHR_ID
, ARTH.CLE_ID
, ARTH.CAT_ID
, ARTH.OBJECT_VERSION_NUMBER
, ARTH.SFWT_FLAG
, ARTH.SAV_SAE_ID
, ARTH.SAV_SAV_RELEASE
, ARTH.SBT_CODE
, ARTH.DNZ_CHR_ID
, ARTH.COMMENTS
, ARTH.FULLTEXT_YN
, ARTH.VARIATION_DESCRIPTION
, ARTH.NAME
, ARTH.TEXT
, ARTH.ATTRIBUTE_CATEGORY
, ARTH.ATTRIBUTE1
, ARTH.ATTRIBUTE2
, ARTH.ATTRIBUTE3
, ARTH.ATTRIBUTE4
, ARTH.ATTRIBUTE5
, ARTH.ATTRIBUTE6
, ARTH.ATTRIBUTE7
, ARTH.ATTRIBUTE8
, ARTH.ATTRIBUTE9
, ARTH.ATTRIBUTE10
, ARTH.ATTRIBUTE11
, ARTH.ATTRIBUTE12
, ARTH.ATTRIBUTE13
, ARTH.ATTRIBUTE14
, ARTH.ATTRIBUTE15
, ARTH.CAT_TYPE
, ARTH.CREATED_BY
, ARTH.CREATION_DATE
, ARTH.LAST_UPDATED_BY
, ARTH.LAST_UPDATE_DATE
, ARTH.LAST_UPDATE_LOGIN
, FND.MEANING SUBJECT
FROM OKR_K_ARTICLES_HV ARTH
, OKC_STD_ART_VERSIONS_V SAV
, OKC_STD_ARTICLES_V SAE
, FND_LOOKUPS FND
WHERE ARTH.CAT_TYPE = 'NSD'
AND ARTH.SAV_SAE_ID = SAV.SAE_ID (+)
AND ARTH.SAV_SAV_RELEASE = SAV.SAV_RELEASE (+)
AND SAV.SAE_ID = SAE.ID (+)
AND FND.LOOKUP_TYPE = 'OKC_SUBJECT'
AND FND.LOOKUP_CODE = NVL(ARTH.SBT_CODE
, SAE.SBT_CODE) UNION ALL SELECT ARTH.ROW_ID
, ARTH.ID
, ARTH.MAJOR_VERSION
, ARTH.CHR_ID
, ARTH.CLE_ID
, ARTH.CAT_ID
, ARTH.OBJECT_VERSION_NUMBER
, ARTH.SFWT_FLAG
, ARTH.SAV_SAE_ID
, ARTH.SAV_SAV_RELEASE
, ARTH.SBT_CODE
, ARTH.DNZ_CHR_ID
, ARTH.COMMENTS
, ARTH.FULLTEXT_YN
, ARTH.VARIATION_DESCRIPTION
, SAE.NAME
, ARTH.TEXT
, ARTH.ATTRIBUTE_CATEGORY
, ARTH.ATTRIBUTE1
, ARTH.ATTRIBUTE2
, ARTH.ATTRIBUTE3
, ARTH.ATTRIBUTE4
, ARTH.ATTRIBUTE5
, ARTH.ATTRIBUTE6
, ARTH.ATTRIBUTE7
, ARTH.ATTRIBUTE8
, ARTH.ATTRIBUTE9
, ARTH.ATTRIBUTE10
, ARTH.ATTRIBUTE11
, ARTH.ATTRIBUTE12
, ARTH.ATTRIBUTE13
, ARTH.ATTRIBUTE14
, ARTH.ATTRIBUTE15
, ARTH.CAT_TYPE
, ARTH.CREATED_BY
, ARTH.CREATION_DATE
, ARTH.LAST_UPDATED_BY
, ARTH.LAST_UPDATE_DATE
, ARTH.LAST_UPDATE_LOGIN
, FND.MEANING SUBJECT
FROM OKR_K_ARTICLES_HV ARTH
, OKC_STD_ART_VERSIONS_V SAV
, OKC_STD_ARTICLES_V SAE
, FND_LOOKUPS FND
WHERE ARTH.CAT_TYPE = 'STA'
AND ARTH.SAV_SAE_ID = SAV.SAE_ID
AND ARTH.SAV_SAV_RELEASE = SAV.SAV_RELEASE
AND SAV.SAE_ID = SAE.ID
AND FND.LOOKUP_TYPE = 'OKC_SUBJECT'
AND FND.LOOKUP_CODE = SAE.SBT_CODE

Columns

Name
ROW_ID
ID
MAJOR_VERSION
CHR_ID
CLE_ID
CAT_ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
SAV_SAE_ID
SAV_SAV_RELEASE
SBT_CODE
DNZ_CHR_ID
COMMENTS
FULLTEXT_YN
VARIATION_DESCRIPTION
NAME
TEXT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CAT_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SUBJECT