[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View on OKC_STD_ART_VERSIONS_V ,OKC_STD_ARTICLES_V V, FND_LOOKUPS |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SAVV.ROWID ROW_ID
, SAVV.SAE_ID SAE_ID
, SAVV.SAV_RELEASE SAV_RELEASE
, SAVV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SAVV.SFWT_FLAG SFWT_FLAG
, SAVV.DATE_ACTIVE DATE_ACTIVE
, SARV.NAME
, FND.LOOKUP_CODE SBT_CODE
, FND.MEANING SUBJECT
, OKR_DATATYPE_UTIL_PUB.OKR_CLOB_TO_VC(SAVV.TEXT) TEXT
, SAVV.SHORT_DESCRIPTION SHORT_DESCRIPTION
, SAVV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SAVV.ATTRIBUTE1 ATTRIBUTE1
, SAVV.ATTRIBUTE2 ATTRIBUTE2
, SAVV.ATTRIBUTE3 ATTRIBUTE3
, SAVV.ATTRIBUTE4 ATTRIBUTE4
, SAVV.ATTRIBUTE5 ATTRIBUTE5
, SAVV.ATTRIBUTE6 ATTRIBUTE6
, SAVV.ATTRIBUTE7 ATTRIBUTE7
, SAVV.ATTRIBUTE8 ATTRIBUTE8
, SAVV.ATTRIBUTE9 ATTRIBUTE9
, SAVV.ATTRIBUTE10 ATTRIBUTE10
, SAVV.ATTRIBUTE11 ATTRIBUTE11
, SAVV.ATTRIBUTE12 ATTRIBUTE12
, SAVV.ATTRIBUTE13 ATTRIBUTE13
, SAVV.ATTRIBUTE14 ATTRIBUTE14
, SAVV.ATTRIBUTE15 ATTRIBUTE15
, SAVV.CREATED_BY CREATED_BY
, SAVV.CREATION_DATE CREATION_DATE
, SAVV.LAST_UPDATED_BY LAST_UPDATED_BY
, SAVV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAVV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_STD_ART_VERSIONS_V SAVV
, OKC_STD_ARTICLES_V SARV
, FND_LOOKUPS FND
WHERE SAVV.SAE_ID = SARV.ID
AND FND.LOOKUP_TYPE = 'OKC_SUBJECT'
AND FND.LOOKUP_CODE = SARV.SBT_CODE