View: OKC_K_HISTORY_V

Product:	OKC - Contracts Core
Description:	View for table OKC_K_HISTORY_B & _TL
Implementation/DBA Data:	APPS.OKC_K_HISTORY_V

View Text

SELECT HSTB.ROWID ROW_ID
, HSTB.ID ID
, HSTB.CHR_ID CHR_ID
, HSTB.CLE_ID CLE_ID
, HSTB.CONTRACT_VERSION CONTRACT_VERSION
, HSTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, HSTB.OPN_CODE OPN_CODE
, HSTB.STS_CODE_FROM STS_CODE_FROM
, HSTB.STS_CODE_TO STS_CODE_TO
, HSTB.REASON_CODE REASON_CODE
, HSTB.TRN_CODE TRN_CODE
, HSTB.MANUAL_YN MANUAL_YN
, HSTT.COMMENTS COMMENTS
, HSTB.CREATED_BY CREATED_BY
, HSTB.CREATION_DATE CREATION_DATE
, HSTB.LAST_UPDATED_BY LAST_UPDATED_BY
, HSTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HSTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HSTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, HSTB.PROGRAM_ID PROGRAM_ID
, HSTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, HSTB.REQUEST_ID REQUEST_ID
FROM OKC_K_HISTORY_B HSTB
, OKC_K_HISTORY_TL HSTT
WHERE HSTB.ID = HSTT.ID
AND HSTT.LANGUAGE = USERENV('LANG')

Columns