Product: | OKE - Project Contracts |
---|---|
Description: | Terms & Conditions History View |
Implementation/DBA Data: | APPS.OKE_K_TERMS_HV |
SELECT KT.ROWID
, KT.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
, TV.TERM_VALUE
, TV.DESCRIPTION
, TV.START_DATE_ACTIVE
, TV.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_H KT
, OKE_TERM_VALUES_V TV
, OKE_TERMS_VL T
, OKE_TERM_TYPES_V TT
WHERE TV.TERM_CODE = KT.TERM_CODE
AND TV.TERM_VALUE_PK1 = KT.TERM_VALUE_PK1
AND TV.TERM_VALUE_PK2 = KT.TERM_VALUE_PK2
AND T.TERM_CODE = TV.TERM_CODE
AND TT.TERM_TYPE_CODE = T.TERM_TYPE_CODE