[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for table OKR_CLASSIFICATIONS |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CSNB.ROWID ROW_ID
, CSNB.IP_TYPE IP_TYPE
, CSNB.CLSF_TYPE CLSF_TYPE
, CSFT.MEANING CLSF_TYPE_MEANING
, CSNB.CLSF_CODE CLSF_CODE
, CSFC.MEANING CLSF_CODE_MEANING
, CSFC.DESCRIPTION CLSF_CODE_DESC
, OKR_UTIL_PUB.HAS_PROPERTIES(CSNB.IP_TYPE
, CSNB.CLSF_TYPE
, CSNB.CLSF_CODE) PROPERTIES_YN
, CSNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CSNB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CSNB.ATTRIBUTE1 ATTRIBUTE1
, CSNB.ATTRIBUTE2 ATTRIBUTE2
, CSNB.ATTRIBUTE3 ATTRIBUTE3
, CSNB.ATTRIBUTE4 ATTRIBUTE4
, CSNB.ATTRIBUTE5 ATTRIBUTE5
, CSNB.ATTRIBUTE6 ATTRIBUTE6
, CSNB.ATTRIBUTE7 ATTRIBUTE7
, CSNB.ATTRIBUTE8 ATTRIBUTE8
, CSNB.ATTRIBUTE9 ATTRIBUTE9
, CSNB.ATTRIBUTE10 ATTRIBUTE10
, CSNB.ATTRIBUTE11 ATTRIBUTE11
, CSNB.ATTRIBUTE12 ATTRIBUTE12
, CSNB.ATTRIBUTE13 ATTRIBUTE13
, CSNB.ATTRIBUTE14 ATTRIBUTE14
, CSNB.ATTRIBUTE15 ATTRIBUTE15
, CSNB.CREATED_BY CREATED_BY
, CSNB.CREATION_DATE CREATION_DATE
, CSNB.LAST_UPDATED_BY LAST_UPDATED_BY
, CSNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_CLASSIFICATIONS CSNB
, FND_LOOKUPS CSFT
, FND_LOOKUPS CSFC
WHERE CSFT.LOOKUP_TYPE = 'OKR_CLASSIFICATION_TYPES'
AND CSFT.LOOKUP_CODE = CSNB.CLSF_TYPE
AND CSFC.LOOKUP_TYPE = 'OKR_CLASSIFICATION_CODES'
AND CSFC.LOOKUP_CODE = CSNB.CLSF_CODE