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