[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for OKR_KSTS_NOTIFS table |
| Implementation/DBA Data: | Not implemented in this database |
SELECT KSTN.ROWID ROW_ID
, KSTN.ID ID
, KSTN.CATEGORY_CODE CATEGORY_CODE
, SCST.MEANING CATEGORY_CODE_MEANING
, KSTN.STATUS_TYPE STATUS_TYPE
, KSTN.STATUS_CODE STATUS_CODE
, OKR_UTIL_PUB.GET_K_STATUS_MEANING(KSTN.STATUS_CODE) STATUS_CODE_MEANING
, KSTN.EMAIL_ADDRESSES EMAIL_ADDRESSES
, KSTNR.ID ROLE_ID
, KSTNR.CONTACT_ROLE CONTACT_ROLE
, OKC_UTIL.DECODE_LOOKUP('OKC_CONTACT_ROLE'
, KSTNR.CONTACT_ROLE) CONTACT_ROLE_NAME
, KSTNR.CONTACT_RESOURCE CONTACT_RESOURCE
, KSTNR.BUY_OR_SELL BUY_OR_SELL
, KSTN.START_DATE_ACTIVE START_DATE_ACTIVE
, KSTN.END_DATE_ACTIVE END_DATE_ACTIVE
, KSTN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KSTN.ATTRIBUTE1 ATTRIBUTE1
, KSTN.ATTRIBUTE2 ATTRIBUTE2
, KSTN.ATTRIBUTE3 ATTRIBUTE3
, KSTN.ATTRIBUTE4 ATTRIBUTE4
, KSTN.ATTRIBUTE5 ATTRIBUTE5
, KSTN.ATTRIBUTE7 ATTRIBUTE6
, KSTN.ATTRIBUTE7 ATTRIBUTE7
, KSTN.ATTRIBUTE8 ATTRIBUTE8
, KSTN.ATTRIBUTE9 ATTRIBUTE9
, KSTN.ATTRIBUTE10 ATTRIBUTE10
, KSTN.ATTRIBUTE11 ATTRIBUTE11
, KSTN.ATTRIBUTE12 ATTRIBUTE12
, KSTN.ATTRIBUTE13 ATTRIBUTE13
, KSTN.ATTRIBUTE14 ATTRIBUTE14
, KSTN.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_K_STS_NOTIFS KSTN
, OKR_K_STS_NOTIF_ROLES_V KSTNR
, OKC_SUBCLASSES_B SCSB
, OKC_SUBCLASSES_TL SCST
, JTF_OBJECTS_VL JTF