View: OKC_K_ITEMS_HV

Product:	OKC - Contracts Core
Description:	History view for OKC_K_ITEMS.
Implementation/DBA Data:	APPS.OKC_K_ITEMS_HV

View Text

SELECT CIMB.ROWID ROW_ID
, CIMB.ID ID
, CIMB.MAJOR_VERSION MAJOR_VERSION
, CIMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CIMB.CLE_ID CLE_ID
, CIMB.CHR_ID CHR_ID
, CIMB.CLE_ID_FOR CLE_ID_FOR
, CIMB.DNZ_CHR_ID DNZ_CHR_ID
, CIMB.OBJECT1_ID1 OBJECT1_ID1
, CIMB.OBJECT1_ID2 OBJECT1_ID2
, CIMB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, CIMB.UOM_CODE UOM_CODE
, CIMB.EXCEPTION_YN EXCEPTION_YN
, CIMB.NUMBER_OF_ITEMS NUMBER_OF_ITEMS
, CIMB.PRICED_ITEM_YN PRICED_ITEM_YN
, CIMB.CREATED_BY CREATED_BY
, CIMB.CREATION_DATE CREATION_DATE
, CIMB.LAST_UPDATED_BY LAST_UPDATED_BY
, CIMB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CIMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CIMB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CIMB.PROGRAM_ID PROGRAM_ID
, CIMB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CIMB.REQUEST_ID REQUEST_ID
FROM OKC_K_ITEMS_H CIMB

Columns