Product: | OKC - Contracts Core |
---|---|
Description: | History view for OKC_CONDITION_HEADERS. |
Implementation/DBA Data: | APPS.OKC_CONDITION_HEADERS_HV |
SELECT CNHB.ROWID ROW_ID
, CNHB.ID ID
, CNHB.MAJOR_VERSION MAJOR_VERSION
, CNHB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CNHT.SFWT_FLAG SFWT_FLAG
, CNHB.ACN_ID ACN_ID
, CNHB.COUNTER_GROUP_ID COUNTER_GROUP_ID
, CNHT.DESCRIPTION DESCRIPTION
, CNHT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CNHT.COMMENTS COMMENTS
, CNHB.ONE_TIME_YN ONE_TIME_YN
, CNHT.NAME NAME
, CNHB.CONDITION_VALID_YN CONDITION_VALID_YN
, CNHB.BEFORE_AFTER BEFORE_AFTER
, CNHB.TRACKED_YN TRACKED_YN
, CNHB.CNH_VARIANCE CNH_VARIANCE
, CNHB.DNZ_CHR_ID DNZ_CHR_ID
, CNHB.TEMPLATE_YN TEMPLATE_YN
, CNHB.DATE_ACTIVE DATE_ACTIVE
, CNHB.OBJECT_ID OBJECT_ID
, CNHB.DATE_INACTIVE DATE_INACTIVE
, CNHB.JTOT_OBJECT_CODE JTOT_OBJECT_CODE
, CNHB.TASK_OWNER_ID
, CNHB.CNH_TYPE CNH_TYPE
, CNHB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CNHB.ATTRIBUTE1 ATTRIBUTE1
, CNHB.ATTRIBUTE2 ATTRIBUTE2
, CNHB.ATTRIBUTE3 ATTRIBUTE3
, CNHB.ATTRIBUTE4 ATTRIBUTE4
, CNHB.ATTRIBUTE5 ATTRIBUTE5
, CNHB.ATTRIBUTE6 ATTRIBUTE6
, CNHB.ATTRIBUTE7 ATTRIBUTE7
, CNHB.ATTRIBUTE8 ATTRIBUTE8
, CNHB.ATTRIBUTE9 ATTRIBUTE9
, CNHB.ATTRIBUTE10 ATTRIBUTE10
, CNHB.ATTRIBUTE11 ATTRIBUTE11
, CNHB.ATTRIBUTE12 ATTRIBUTE12
, CNHB.ATTRIBUTE13 ATTRIBUTE13
, CNHB.ATTRIBUTE14 ATTRIBUTE14
, CNHB.ATTRIBUTE15 ATTRIBUTE15
, CNHB.CREATED_BY CREATED_BY
, CNHB.CREATION_DATE CREATION_DATE
, CNHB.LAST_UPDATED_BY LAST_UPDATED_BY
, CNHB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CNHB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CNHB.LAST_RUNDATE LAST_RUNDATE
, CNHB.APPLICATION_ID APPLICATION_ID
, CNHB.SEEDED_FLAG SEEDED_FLAG
FROM OKC_CONDITION_HEADERS_BH CNHB
, OKC_CONDITION_HEADERS_TLH CNHT
WHERE CNHB.ID = CNHT.ID
AND CNHT.LANGUAGE = USERENV('LANG')
AND CNHB.MAJOR_VERSION= CNHT.MAJOR_VERSION