Product: | OKE - Project Contracts |
---|---|
Description: | Terms & Conditions View |
Implementation/DBA Data: | APPS.OKE_K_ALL_TERMS_V |
SELECT KT.ROWID
, K.MAJOR_VERSION
, KT.K_HEADER_ID
, KT.K_LINE_ID
, KT.TERM_CODE
, KT.TERM_VALUE_PK1
, KT.TERM_VALUE_PK2
, KT.CREATION_DATE
, KT.CREATED_BY
, KT.LAST_UPDATE_DATE
, KT.LAST_UPDATED_BY
, KT.LAST_UPDATE_LOGIN
, OKE_UTILS.GET_TERM_VALUES(KT.TERM_CODE
, KT.TERM_VALUE_PK1
, KT.TERM_VALUE_PK2
, 'MEANING')
, OKE_UTILS.GET_TERM_VALUES(KT.TERM_CODE
, KT.TERM_VALUE_PK1
, KT.TERM_VALUE_PK2
, 'DESCRIPTION')
, TO_DATE(OKE_UTILS.GET_TERM_VALUES(KT.TERM_CODE
, KT.TERM_VALUE_PK1
, KT.TERM_VALUE_PK2
, 'START_DATE_ACTIVE'))
, TO_DATE(OKE_UTILS.GET_TERM_VALUES(KT.TERM_CODE
, KT.TERM_VALUE_PK1
, KT.TERM_VALUE_PK2
, 'END_DATE_ACTIVE'))
, T.TERM_NAME
, TT.TERM_TYPE_CODE
, TT.TERM_TYPE_NAME
, KT.ATTRIBUTE_CATEGORY
, KT.ATTRIBUTE1
, KT.ATTRIBUTE2
, KT.ATTRIBUTE3
, KT.ATTRIBUTE4
, KT.ATTRIBUTE5
, KT.ATTRIBUTE6
, KT.ATTRIBUTE7
, KT.ATTRIBUTE8
, KT.ATTRIBUTE9
, KT.ATTRIBUTE10
, KT.ATTRIBUTE11
, KT.ATTRIBUTE12
, KT.ATTRIBUTE13
, KT.ATTRIBUTE14
, KT.ATTRIBUTE15
FROM OKE_K_TERMS KT
, OKE_TERMS_VL T
, OKE_TERM_TYPES_V TT
, OKE_K_VERS_NUMBERS_V K
WHERE T.TERM_CODE = KT.TERM_CODE
AND TT.TERM_TYPE_CODE (+) = T.TERM_TYPE_CODE
AND K.CHR_ID = KT.K_HEADER_ID