Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PTYB.IP_TYPE IP_TYPE
, PTYT.IP_TYPE_MEANING IP_TYPE_MEANING
, PTYB.IMAGE_SOURCE IMAGE_SOURCE
, PTYB.BASIC_IP_TYPE BASIC_IP_TYPE
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_BASE_PROPERTY_TYPES'
, PTYB.BASIC_IP_TYPE) BASIC_IP_TYPE_MEANING
, PTYT.DESCRIPTION DESCRIPTION
, PTYB.START_DATE_ACTIVE START_DATE_ACTIVE
, PTYT.SFWT_FLAG SFWT_FLAG
, PTYB.END_DATE_ACTIVE END_DATE_ACTIVE
, PTYB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PTYB.ATTRIBUTE1 ATTRIBUTE1
, PTYB.ATTRIBUTE2 ATTRIBUTE2
, PTYB.ATTRIBUTE3 ATTRIBUTE3
, PTYB.ATTRIBUTE4 ATTRIBUTE4
, PTYB.ATTRIBUTE5 ATTRIBUTE5
, PTYB.ATTRIBUTE6 ATTRIBUTE6
, PTYB.ATTRIBUTE7 ATTRIBUTE7
, PTYB.ATTRIBUTE8 ATTRIBUTE8
, PTYB.ATTRIBUTE9 ATTRIBUTE9
, PTYB.ATTRIBUTE10 ATTRIBUTE10
, PTYB.ATTRIBUTE11 ATTRIBUTE11
, PTYB.ATTRIBUTE12 ATTRIBUTE12
, PTYB.ATTRIBUTE13 ATTRIBUTE13
, PTYB.ATTRIBUTE14 ATTRIBUTE14
, PTYB.ATTRIBUTE15 ATTRIBUTE15
, PTYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PTYB.CREATED_BY CREATED_BY
, PTYB.CREATION_DATE CREATION_DATE
, PTYB.LAST_UPDATED_BY LAST_UPDATED_BY
, PTYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_PROP_TYPES_B PTYB
, OKR_PROP_TYPES_TL PTYT
WHERE PTYB.IP_TYPE=PTYT.IP_TYPE
AND PTYT.LANGUAGE = USERENV('LANG')